Deleting Duplicates

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

Angie M.

I have a list of numbers in column A as follows:

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

I would like to delete the duplicate values in this list. I can utilize
column B if necessary. Can anybody help? Thanks
 
A simple IF statement should work, as long as your data is sorted numerically.

In column B enter:

=IF(A1=A2,"X","")

All duplicated numbers will have an "X", then filter for the X's .
 
Back
Top