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

Thanks! You saved me a full day of cross referencing!!!!

"Peo Sjoblom" wrote:

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.