identifying duplications

[RAM]

Can someone tell me the most efficient way to identify duplicated text in a
long list. Example: I have a long list of names and want to find the
duplicated ones. One way is to sort alphabetically, but this is time
consuming. Is there a better method? Maybe a formula that can be used? Thanks

 

[Frank Kabel]

Hi see:
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[BenjieLop]

This formula might help (enter in, say, Cell C2 and copy down until you
requirements are met):

=(countif(A$2:A$1000,A2)>1)+0

... what it does is that if the name is unique, it then returns a valu
of zero (0) otherwise, it is a duplicated name.

Hope this helps you.

 

[Arvi Laanemets]

Hi

Another way - into cell on row 2 enter the formula

=IF(COUNTIF(A$2:A2,A2)>1,COUNTIF(A$2:A2,A2),"")
or
=IF(COUNTIF(A$2:A2,A2)>1,"X","")
and copy down. for first occurence of the value in column A the formula
returns an empty string (blank cell), for 2nd, 3rd etc. returns a number or
'X'.


Arvi Laanemets