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

"Angie M." wrote in message
...
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.