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?