<div>
=countif(datarange,number)<wbr />
</div>


<div>
If you have multiple IDs duplicated, you could you the contingency table (visual group by SQL equivalent in Excel) to find out which IDs and how many times are duplicated. Then you can use the countif to search for one after another.
</div>


If you have multiple IDs duplicated, you could you the contingency table (visual group by SQL equivalent in Excel) to find out which IDs and how many times are duplicated. Then you can use the countif to search for one after another.

<div>
What does the Contingency table mean?
</div>


<div>
<div class="content wysiwyg-content">
Hi Guys, there is duplication of trade IDs in an Excel spreadsheet I have. If I have a trade Id &quot;567893.28&quot; for example. How can I count how many times this appears in Column &quot;C&quot;? Is it a &quot;Countif&quot; formula? If I have the Value in the Cells (&quot;F1&quot;) and I want to find out how many times that appears in Column C, what would be the formula?
</div>
</div>


Hi Guys, there is duplication of trade IDs in an Excel spreadsheet I have. If I have a trade Id "567893.28" for example. How can I count how many times this appears in Column "C"? Is it a "Countif" formula? If I have the Value in the Cells ("F1") and I want to find out how many times that appears in Column C, what would be the formula?

How to find out about duplicate Id?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.