Find highest value in one column, eliminate duplicates in two columns

Excel.JPG

I have a spreadsheet with 300,000 rows. A lot of them have the same information. I need to keep one row for each ID but I need the maximum value for the 'G' row.

So in this example, I'd like my final sheet to look like this:

Captureexcel.JPG

In other words, I need the highest G value for each ID #.

Any help would be so appreciated!

1. Sort TeamID Ascending and G Descending
2. Use Excel's Remove Duplicate feature to remove duplicates only based on TeamID

you should get desired results.

Thanks! For some reason it didn't work yesterday but it is now. I must not have sorted or selected both for removal.