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.