Hi
I've attached a file for your reference.
I'm trying to remove the duplicates on column B ('Amount') and E ('SId') but also want to keep a specific row from all the duplicates. I want to keep the row that has 'EN' in Column G ('Reference qualifier').
I found a way to remove the duplicates (from the 'remove duplicates' function) and realize that Excel always keep the first row of the bunch of duplicates. But I can't figure out a way to keep a specific/designated row. Hope this make sense.
It's something I will have to do on a regular basis. So an easy solution that I can use regurlarly will be appreciate.
Thanks in advance
Bookmarks