Delete duplicates

  • Thread starter Thread starter Angie M.
  • Start date Start date
A

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.
 
Hi Angie

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

--
Regards
Roger Govier

Angie M. said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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
 
Back
Top