Deleting multiple rows through a formula

M

mike_vr

So does anyone know a formula that will allow me to delete multiple rows of
re-occuring data in a spreadsheet.
For example, I have a spreadsheet of 10,000 lines, with multiple mobile
numbers on it. I need to only have one of each mobile number and delete the
remaining rows where the mobile has been repeated?
 
T

tina

Mike
you may be able to use the advance filter where can select unique records
only.
select data filter advanced filter select copy to another location then in
list range box enter range to filter in the copy to box enter a free column
select unique records only then ok
then just delete original column

Tina
 
Top