Isaac Garcia
New Member
Hello,
I need to average the highest scores only of each name in the attached file.
For example, Joe Schmoe should be 100 since his highest value is 100.
Jane Doe should be 81.70 (Average of 84.34 and 79.07) and so on.
I have more names than this which is why I need an easier way to figure this out.
OR
If it's easier, is there a way to find the lowest value and have the whole row removed? Then I could use a pivot table to find the average of the remaining. Thanks!
I need to average the highest scores only of each name in the attached file.
For example, Joe Schmoe should be 100 since his highest value is 100.
Jane Doe should be 81.70 (Average of 84.34 and 79.07) and so on.
I have more names than this which is why I need an easier way to figure this out.
OR
If it's easier, is there a way to find the lowest value and have the whole row removed? Then I could use a pivot table to find the average of the remaining. Thanks!