lookup values vertically in a list and return the repeats

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
 
S

Sheeloo

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 Values 4
Vlookup and return sheet name also 2
vlookup and lookup 12
LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE 6
Lookup multiple values return one value corresponding value Excel 1
Lookup 2 values to return 1 9
Idetnifying repeats in a column 1

Top