I have used countif to check for duplicates for years without a problem. For some reason, it is not working now. Please see the image I uploaded. Here is the formula I used - =COUNTIF($K$5:$K$9610,K5). i then filtered on the number 32. If you look at the screen shot that I attached, you can see that all of the values in column K are different, yet countif gives the result of 32. This happened 4 times on this spreadsheet. The format for Column K is Text.
I don't understand why this formula is not working.
Any Help would be greatly appreciated.
Larry
I don't understand why this formula is not working.
Any Help would be greatly appreciated.
Larry