check for repetition of cell contents

D

David

How can i check for repetition of cell contents in a row/column? Please let
me know if a formula needs to be used for this or is there an already inbuilt
provision for checking this functionality? If there is a formula or steps to
be followed, please narrate the same.
 
M

Max

David said:
How can i check for repetition of cell contents in a row/column? Please let
me know if a formula needs to be used for this or is there an already inbuilt
provision for checking this functionality? If there is a formula or steps to
be followed, please narrate the same.
Click to expand...

Assuming source data in A2 down,
Put in B2:
=IF(A2="","",IF(COUNTIF($A$1:A2,A2)>1,"dup",""))
Copy down. Duplicates in col A, if any, will be flagged as "dup". You could
then use autofilter on col B to filter out the "dup"s for closer inspection
 
Top