I tried this but is does not hide the duplicates. Can you help?

"Gord Dibben" wrote:

DataFilterAdvanced Filter.

Unique records only and copy to another location.


Gord Dibben Excel MVP

On Thu, 23 Jun 2005 14:47:04 -0700, "Amber"
wrote:

I have a large spreadsheet and because of system parameters, it has lots of
duplicate records. How can I get just one of each record without manually
deleting the duplicates?