This appears to work but the zero does not actually exsist ie not in FX Box
when copy and paste it does show zero,


Thanks

Karen






"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