NO REPEATS

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??????????
--
HOMER

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.

--
Cheers
macropod
[MVP - Microsoft Word]


"HOMER" <HOMER@discussions.microsoft.com> wrote in message news:6A026C52-52BD-4CD5-BEC6-9145CDC27FB6@microsoft.com...
>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??????????
> --
> HOMER

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

"HOMER" wrote:

> 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??????????
> --
> HOMER

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

--
Cheers
macropod
[MVP - Microsoft Word]


"Patty" <Patty@discussions.microsoft.com> wrote in message news:417452D8-2E7E-42F9-86FE-9151EE2CBE74@microsoft.com...
> With a slight variation this formula in B2 it will put "!" beside the dups
> =IF(SUMIF(A$1:A1,A2)>1,"!","")
>
> "HOMER" wrote:
>
>> 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??????????
>> --
>> HOMER