Deleting Duplicates

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
 
I

Iriemon

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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete duplicates 4
Augmenting an integer in a column to reflect duplicates in another 23
is there a simple formula that will remove all duplicates 3
Help with An Array Formula and Duplicates 3
Finding and Deleting duplicates in a column 3
sorting data 1
Duplicates Deletion ? 2
Columns and Conditional Formattin 2

Top