Hi,
I've got about 50,000 rows in my spreadsheet and need to keep rows that have same information in column A and F and remove the rest.
example:
Picture1.png
I need to keep both yellow rows because they have same information in column A and F even though the information in other columns is not the same.
I was wondering if there is any quick way to do that?
Any suggestions will be much appreciated
Thanks
Bookmarks