I have a spreadsheet of a group of people that took a test, columns A-F are the personal information of the individual, and column G is their test score. Some of the people took the test multiple times and got different scores so those people are listed multiple times. Is there a way that I can delete all but the highest score for each person

for example

1:Joe Smith(Column A).... 200(Column G)
2:Joe Smith(Column A).... 170(Column G)
3:Joe Smith(Column A).... 215(Column G)

I only want to keep Row 3 where Joe Smith scored a 215 and delete rows 1 and 2