ExcelBanter - check for repetition of cell contents

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - check for repetition of cell contents (https://www.excelbanter.com/excel-worksheet-functions/109933-check-repetition-cell-contents.html)

check for repetition of cell contents

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.

check for repetition of cell contents

"David" wrote:
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.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---