Conditional Formatting

B

Brurobiney

I have column A with over 500 account numbers. What is the formula that will
allow me to see which of those accounts are listed more than once.
 
D

Dave F

One way:

1) Sort the column in ascending order
2) In B2 enter a formula: =IF(A2=A1,1,"") and fill down to the bottom of
your column of numbers in column A
3) Anywhere where a 1 appears, there are duplicates.

Dave
 
T

Teethless mama

Highlight your range
Conditional Formatting
Formula Is =COUNTIF($A$1:$A1,$A1)>1
Click Format button and select Pattern then click OK and OK
 
Top