Duplicates

[Karen]

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

thanks

Karen

 

[Mike]

Here is a good start.

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

Mike

 

[Bob Phillips]

Data>Filter>Advanced 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]

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

 

[Karen]

Ok thanks thats fine

Data>Filter>Advanced 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)