I was wondering if someone could help me with this. I am trying to create a macro to achieve the following:
I have the following excel table:
Letter Number A 15 A 2212 A 3741 B 251 B 7 B 14201 C 13503 C 97 C 113
I would like to build a macro which would go through the "letter column" and whenever there is the same letter, look at the "number column" beside it and delete the smaller values - keeping only the largest values.
I would like the end result to have only one entry for each letter and the corresponding value next to it as shown below:
Letter Number A 3741 B 14201 C 13503
Not sure how complicated of a macro this would be. Thanks in advance guys.