NO REPEATS

  • Thread starter Thread starter HOMER
  • Start date Start date
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??????????
 
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.
 
With a slight variation this formula in B2 it will put "!" beside the dups
=IF(SUMIF(A$1:A1,A2)>1,"!","")
 
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).
 
Back
Top