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?