There are two columns- Name and e-mail. Need to remove duplicate email without affecting my original data. Data is attached.
There are two columns- Name and e-mail. Need to remove duplicate email without affecting my original data. Data is attached.
You could copy the sheet by CTRL-drag of the sheet tab, and then act upon this new sheet, so that you still have the original data.
One quick way of deleting the duplicates (but still retain the first occurence) is to put this formula in C2:
=IF(AND(COUNTIF(B:B,B2)>1,COUNTIF(B$2:B2,B2)<>1),"delete","ok")
then copy this down to the bottom of your data (double-click on the fill icon in the bottom right corner of the cursor). Now you can apply autofilter to that column, select "delete" from the filter drop-down, select all the visible rows and click delete.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks