How to check a column so that no duplicate number?

[Rocky]

I have a spreadsheet that has 3500 items and I like to check the column that
no duplicate UPC code exist on the column. What is the simple way to do
that.

Thanks

Rocky

[Gord Dibben]

Rocky

To tag/highlight the duplicates see Chip Pearson's site.

http://www.cpearson.com/excel/duplic...gingDuplicates

To create a unique list see Debra Dalglesih's site.

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben Excel MVP

On Sun, 9 Jan 2005 11:37:45 -0800, "Rocky" <rockylamATyahooDOTcom> wrote:

>I have a spreadsheet that has 3500 items and I like to check the column that
>no duplicate UPC code exist on the column. What is the simple way to do
>that.
>
>Thanks
>
>Rocky
>

[Embalmer]

Using the 'countif' function then filtering on the top line to see if there are any numbers above 1 should help you find any duplicates

[Rocky]

I have tried the link you gave me it doesn't work.

Thanks

Rocky


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Rocky
>
> To tag/highlight the duplicates see Chip Pearson's site.
>
> http://www.cpearson.com/excel/duplic...gingDuplicates
>
> To create a unique list see Debra Dalglesih's site.
>
> http://www.contextures.on.ca/xladvfi....html#FilterUR
>
>
> Gord Dibben Excel MVP
>
> On Sun, 9 Jan 2005 11:37:45 -0800, "Rocky" <rockylamATyahooDOTcom> wrote:
>
>>I have a spreadsheet that has 3500 items and I like to check the column
>>that
>>no duplicate UPC code exist on the column. What is the simple way to do
>>that.
>>
>>Thanks
>>
>>Rocky
>>
>

[Alan Beban]

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your file

=COUNTA(A:A)=ArrayCount(ArrayUniques(A:A))
will return TRUE if there are no duplicates, FALSE otherwise; assuming
that you do not consider ok and OK as duplicates. If you do consider
them as duplicates you can use
=COUNTA(A:A)=ArrayCount(ArrayUniques(A:A,False))

Alan Beban

Rocky wrote:
> I have tried the link you gave me it doesn't work.
>
> Thanks
>
> Rocky
>
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:[email protected]...
>
>>Rocky
>>
>>To tag/highlight the duplicates see Chip Pearson's site.
>>
>>http://www.cpearson.com/excel/duplic...gingDuplicates
>>
>>To create a unique list see Debra Dalglesih's site.
>>
>>http://www.contextures.on.ca/xladvfi....html#FilterUR
>>
>>
>>Gord Dibben Excel MVP
>>
>>On Sun, 9 Jan 2005 11:37:45 -0800, "Rocky" <rockylamATyahooDOTcom> wrote:
>>
>>
>>>I have a spreadsheet that has 3500 items and I like to check the column
>>>that
>>>no duplicate UPC code exist on the column. What is the simple way to do
>>>that.
>>>
>>>Thanks
>>>
>>>Rocky
>>>
>>
>
>

[Gord Dibben]

That's unfortunate.

Both links work fine for me.

Gord

On Sun, 9 Jan 2005 12:53:58 -0800, "Rocky" <rockylamATyahooDOTcom> wrote:

>I have tried the link you gave me it doesn't work.
>
>Thanks
>
>Rocky
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:[email protected]...
>> Rocky
>>
>> To tag/highlight the duplicates see Chip Pearson's site.
>>
>> http://www.cpearson.com/excel/duplic...gingDuplicates
>>
>> To create a unique list see Debra Dalglesih's site.
>>
>> http://www.contextures.on.ca/xladvfi....html#FilterUR
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Sun, 9 Jan 2005 11:37:45 -0800, "Rocky" <rockylamATyahooDOTcom> wrote:
>>
>>>I have a spreadsheet that has 3500 items and I like to check the column
>>>that
>>>no duplicate UPC code exist on the column. What is the simple way to do
>>>that.
>>>
>>>Thanks
>>>
>>>Rocky
>>>
>>
>

[brettdj]

Hi Rocky,

Another option is to download an addin, The Duplicate Master, from my site @ http://members.iinet.net.au/~brettdj

In this case it could be used to

• List any duplicates on a summary sheet
• Highlight any duplicates
• Select any duplicates
• List the uniques

Cheers

Dave