NO REPEATS

H

HOMER

I have about 700 8 digit codes that are sorted numericaly. I received an
additional 2,600. My problem is that some of these new #'s are repeats of my
own. Someone told me to do a "V LOOKUP". What is that and how do I do
it??????????
 
M

macropod

Hi Homer,

If you put all the numbers into column A, starting at row 1, the following formula, put into B1, and copied down to the last row,
will put an exclamation mark in that column for any duplicates:
=IF(SUMIF($A1:A1,A1)>1,"!","")
If you then sort both columns by column B, the duplicates will be on successive rows (at the bottom, by default) and you can then
delete those rows.
 
P

Patty

With a slight variation this formula in B2 it will put "!" beside the dups
=IF(SUMIF(A$1:A1,A2)>1,"!","")
 
M

macropod

Hi Patty,

Coded that way, the formula could put the '!' on the wong line (ie the line after the duplicates), especially if the list hasn't
been sorted. You'll note that, with the solution I posted, it can be used before the list is sorted (ideally, row 1 would be the
header row, which doesn't get sorted).
 
Top