check for repetition of cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows based on contents of Col A 0
Returning row and column headers of a value 3
Formula for Value 4
SORT REPETITIVE DATA FROM ROWS TO COLUMNS 9
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel VBA 1
Software for "repetitions" 5
Cut & Paste in Excel without erasing cell borders? 1

Back
Top