Forum Discussion
Solved
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 ...
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.