How to check a column so that no duplicate number?

Rocky · Jan 9, 2005

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 · Jan 9, 2005

Rocky

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

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

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

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

Gord Dibben Excel MVP

Rocky · Jan 9, 2005

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

Thanks

Rocky

Alan Beban · Jan 9, 2005

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

Gord Dibben · Jan 9, 2005

That's unfortunate.

Both links work fine for me.

Gord