Tracking for identical numbers

Posted by wilson on September 25, 2001 7:36 PM

I dont use macro but I know it can be done this way to cut down checking time. Here we go:

I have a thousand rows to check whether they have any identical phone numbers. Is it possible to highlight them in colour so we can check them further..or perhaps listing the column numbers as a result of the identicals.

Thanks for all the help.

Posted by Richard S on September 25, 2001 8:42 PM

You could use COUNTIF

If your phone numbers are in cells A1 to A1000, in cell B1, enter =COUNTIF($A$1:$A$1000,A1) and copy down to the bottom. This counts the number of occurences of the value in cell A1. If you want to highlight, you could conditionally format for values >1, or you could sort the results to get all the duplicates together.

HTH
Richard