Hi all,
We have spreadsheet that has muliple grades such as ...
John Smith 500 76
John Smith 500 62
Joe Green 1000 42
Joe Green 1000 76
Joe Green 1000 58
John Smith 1000 77
So what I need is a formula that for each person and category, it will take the two highest values and average them. For exam, John Smith 500 - should average 73.62, Joe Green 1000 - should average 76,58, John Smith 1000 - average should be 77
does anyone know how to do this using excel formulas
Bookmarks