To find duplicated values in a range

B

beechum1

and range a1:a6 if i have

aaa
bbb
ccc
ddd
aaa
ccc
I would like to have sometype of notification that a5 is the same as a1
and a3 is the same as a6

This is the case for 350 part#s so i'm hoping theres a way to do this
easily. References to tut's welcomed
 
J

JMB

One way you could identify a duplicate value

In cell B1 type

=IF(COUNTIF($A$1:A1,A1)=1,"",COUNTIF($A$1:A1,A1))

This would identify the 2nd, 3rd, 4th, etc, times that particular value has
appeared.
 
Top