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

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.

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.

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.

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.