How do i remove duplicates from a massive range in a column.

thanks

Karen

Here is a good start.

http://www.cpearson.com/excel/duplicat.htm

Mike

"Karen" wrote:

How do i remove duplicates from a massive range in a column.

thanks

Karen

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

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

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