Forum Discussion
Solved
Sorting out duplicates.
Hello I have a big list of data (email subscribers) and I need to remove the unsubscribers. I do know how to use conditional formatting and highlight duplicates but how do I remove them without havin...
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
Wow I had no idea I could filter by color?? DUH!!! You have no idea how much work you've just saved me!!!!!! Thanks a million.