How do I filter out duplicate values in Excel 2000?

[missy2992]

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

 

[Gary L Brown]

1) Highlight the range that has the duplicates (include the heading).
2) Data>Filter>Advanced Filter
3) Select the 'Copy to another location' button
4) Check the 'Unique records only' box
5) Select a 'Copy to:' starting cell
6) Hit 'OK'

HTH,

 

[Peo Sjoblom]

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

 

[missy2992]

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

 

[missy2992]

Thanks!

1) Highlight the range that has the duplicates (include the heading).
2) Data>Filter>Advanced Filter
3) Select the 'Copy to another location' button
4) Check the 'Unique records only' box
5) Select a 'Copy to:' starting cell
6) Hit 'OK'

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.