You could sort the data: highlight all the data and go to Data | Sort
and sort by columns G, E and A.

Alternatively, you could use dependent ranking formulae. Chip Pearson
explains how he

http://www.cpearson.com/excel/rank.htm

Hope this helps.

Pete