Forum Discussion
Keep first occurrence and remove duplicates
Hello,
I need a process or formula that can do the following:
Remove all but the first occurrence of an email address.
Example below:
Before:
After
Note that I would need duplicates of the other columns to not be counted as duplicates, only the Teacher Email column. I've tried finding duplicates with Conditional Formatting but I have thousands of rows to go through and I can't do that by hand.
This is something I've been trying to figure out off and on for months and I think I just stumbled across it, so for future people having a similar issue, I went to Data, Filter, Advanced Filter, selected the column (in example it's column E) and clicked the check box labelled "Unique Records Only".
While typing this I also got a response, Thank you to wdx223_Daniel for the quick response, that also seems to work and leave the first occurrence as well, so now I have two options!
- Another option is to use UNIQUE() function.
