Is there a simple way of removing duplicate data in Excel?

M

Martin Hextall

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

Gary''s Student

Use filtering:

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