Duplicates

Thread view:

Thread rating:

Karen - 18 Apr 2007 14:50 GMT

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

thanks

Karen

Mike - 18 Apr 2007 15:00 GMT

Here is a good start.

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

Mike

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

Bob Phillips - 18 Apr 2007 15:01 GMT

Data>Filter>Advanced Filter can copy only unique values to a new range.

Signature

---
HTH

Bob

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

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

Karen - 18 Apr 2007 15:24 GMT

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

> Data>Filter>Advanced Filter can copy only unique values to a new range.
>
[quoted text clipped - 3 lines]
>>
>> Karen

Karen - 18 Apr 2007 15:29 GMT

Ok thanks thats fine

> Data>Filter>Advanced Filter can copy only unique values to a new range.
>
[quoted text clipped - 3 lines]
>>
>> Karen