View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gil Doron Gil Doron is offline
external usenet poster
 
Posts: 1
Default Retrieving the Top 10 Average Entries by displaying a third column

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?