Delete duplicates

[Angie M.]

Hi, I have a list of numbers that contain lots of duplicates like the
following:

133150
133150
133150
133154
133154
133154
133155
133156
133156
133156
198355
198355
198355

This list lives in column A. Is there a function I can use to get rid of
the duplicates? It's okay if the list is transposed into another column.
Thanks for any help.

 

[Roger Govier]

Hi Angie

Try
Data>Filter>Advanced Filter>Copy to another location>choose Copy To>Unique
records only

--
Regards
Roger Govier

Hi, I have a list of numbers that contain lots of duplicates like the
following:

133150
133150
133150
133154
133154
133154
133155
133156
133156
133156
198355
198355
198355

This list lives in column A. Is there a function I can use to get rid of
the duplicates? It's okay if the list is transposed into another column.
Thanks for any help.

__________ Information from ESET Smart Security, version of virus
signature database 4832 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4832 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gord Dibben]

Data>Filter>Advanced Filter.

Copy to a new location and checkmark "unique records"

Gives you one of each record............duplicates are filtered out.


Gord Dibben MS Excel MVP

 

[Ashish Mathur]

Hi,

You may use the Remove duplicates feature of Advanced filters (it is on the
Data Tab)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Ashish Mathur]

Hi,

Sorry fot eh earlier post. There is a Remove duplicates feature in the Data
Tab of Excel 2007

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com