| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to average last 25 entries in a column? | Excel Discussion (Misc queries) | |||
| How to make a cell show average of the last 5 entries in a column? | Excel Worksheet Functions | |||
| Displaying unique entries from a filtered list | Excel Worksheet Functions | |||
| Displaying an error message if entries exceed 100% | Excel Discussion (Misc queries) | |||
| Average of column entries | Excel Discussion (Misc queries) | |||
Threaded Mode
