Matching Cells

[nirsky]

Hey

I have a list of 18,000 cells in one column.
The cells contain Names.
Ex:

LISTN, CAHY
LITCELD, CLA
LITTLE, BAA S
LITTLE, PATRK
LITTLE, TRY Y
LITTLE, TRY Y
LITE, VONELLA
EFIELD, JOY A
LELY, JAMES R
LIVET, LARR


I need to search it and find on what cells I have the same name.

I really do not want to go through each of those 18.000 cells.

Thanks Much

Nirsky

[VBA Noob]

Hi,

Say your data is in Col A. Enter this in B1 and drag down (or double click cross bar on fill handle)

=IF(COUNTIF(A:A,A1)>1,"Duplicate find in row "&ROW(),"")

VBA Noob