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
"Ashish Mathur" wrote in message
...
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.