View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How do I filter out duplicate values in Excel 2000?

Make sure the list has a header, select it, do datafilteradvanced filter,
check unique records only and copy to another location, select the location
and click OK

--

Regards,

Peo Sjoblom


"missy2992" wrote in message
...
Does anyone know how I would go about filtering out duplicate values in a
list.