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!