|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I filter out duplicate values in Excel 2000?
Thanks!
"Gary L Brown" wrote:
1) Highlight the range that has the duplicates (include the heading).
2) DataFilterAdvanced 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
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"missy2992" wrote:
Does anyone know how I would go about filtering out duplicate values in a
list.
|