I am taking a list of product codes from a spreadsheet. Some of the product
codes are in the list more than once.

Is there a quick & easy way of removing the duplicate data so that I have
just one entry per product code?

Use filtering:

1. Insure that there is a descriptive cell at the top.
2. Pull-down:
Data FIlter Advanced Filter... and click unique records

--
Gary's Student


"Martin Hextall" wrote:

I am taking a list of product codes from a spreadsheet. Some of the product
codes are in the list more than once.

Is there a quick & easy way of removing the duplicate data so that I have
just one entry per product code?

http://xldynamic.com/source/xld.Deleting.html

--
Kind regards,

Niek Otten

"Martin Hextall" wrote in message
...
I am taking a list of product codes from a spreadsheet. Some of the product
codes are in the list more than once.

Is there a quick & easy way of removing the duplicate data so that I have
just one entry per product code?