lookup values vertically in a list and return the repeats

  • Thread starter Thread starter April_2004
  • Start date Start date
A

April_2004

I have a huge table with account numbers and I need to find out all the ones
that are repeated in one column so that I can delete them and just keep one
value (one Row)..

Does anybody know how to do this with VLOokup or some other function?

Thank you
 
If you have your account numbers in Col A then enter this in B1 and copy down
=IF(COUNTIF($A$1:A1,A1)>1,"Duplicate",A1)
Filter on Duplicate and delete those rows..
 

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

Formula (or code) return the largest number of duplicates in a list. 16
Lookup returning wrong results 0
Vlookup and return sheet name also 2
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6
Lookup Values 4
Lookup Value Not Being Returned 2
Lookup 2 values to return 1 9
Lookup returns wrong value 5

Back
Top