Deleting multiple rows through a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

Deleting multiple rows through a formula? 1
Summary of rows 2
Macro 1
Excel Subtracting multiple columns from another column 3
Deleting Multiple Blank Rows 6
Filtering data using a drop down menu 5
Returning a certain row using vlookup 2
hide rows if nil result of formula in specific column 2

Back
Top