Retrieving the Top 10 Average Entries by displaying a third column
Hi Gil,
You can use the AVERAGE formula in column4. For example,
cell D1 would be "=AVERAGE(B1:C1)". Then just use the
autofilter feature to display the top 5.
Hope this helps...
Chong Moua
-----Original Message-----
I'm new to Excel programing, so please bear with me.
I have an excel spreadsheet with 3 columns.
Column1 Column2 Column3
--------------------------------------
John Doe 5 3
Jane Smith 2 9
Bill Smith 4 2
What I need to do is take the average of Column 2 and 3,
find the
highest average of the entire list and display Column 1
as the final
result.
In other words: I need to create a Top 5 List of the
people with the
highest grade average. I don't care much for displaying
the grade, I
just need the top 5 names.
Can this be done with an excel formula or do I need to
write a macro?
.
|