View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angie M. Angie M. is offline
external usenet poster
 
Posts: 10
Default Delete duplicates

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.