Ok thanks thats fine




"Bob Phillips" wrote in message
...
DataFilterAdvanced Filter can copy only unique values to a new range.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Karen" <poppy.com wrote in message
...
How do i remove duplicates from a massive range in a column.

thanks

Karen