Hi all was hoping someone could give me some incite on how I might be able to work this problem out. I currently have a list of names in Col. C and 3 digit test scores in Col. G. However some names are repeated as a person can take a test multiple times.

Example

C. G.
1. Michael 500
2. Michael 510
3. Gary 920
4. Gary 920
5. Gary 960
6. Joan 800
7. Joan 740
8. Eric 160
6. Jenn 410
7. Jenn 410

I need a way to convert that list into this:

Michael 510
Gary 960
Joan 800
Eric 160
Jenn 410

Where each name is only displayed once, and the max test score is next to it.

Any help is greatly appreciated.

Thanks