Need some help deleting duplicate values in Excel
Sort your table by the phone column
Add a column to the right of your data
Put a formula = IF ( phonecolumn[ROWNUMBER] <> phonecolumn[ROWNUMBER-1] , 0 ,1 )
Double click cell corner so that the formula is copy pasted / propagated all the way to the last row
Now the cells will have 1 if the phone number is identical to previous row's phone number.
So now you can enable filter on the top row (go on row, press Ctrl+Shift + L or use the menu option) and you can select only the rows with 1 (as in rows that have same number as previous row)
Now you can select the phone numbers (drag mouse over the cells or Shift + down / up ) and hit DELETE to erase cells
Disable filter to see your whole table again.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now