How do I filter out duplicate values in Excel 2000?
 

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

How do I filter out duplicate values in Excel 2000?
 

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.

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.

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.

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.