In a sheet that has two columns, the first represents a string and the second represents some field value associated to that string as shown below. I roughly have 30,000 rows like that.
My Question is, how can I remove the duplicates with least field value?
For example, I'd like to get rid of (F,4) while maintaining F, 5)
A B 1 F 5 2 F 4 3 G 2 4 E 1 5 G 3 6 E 2