| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find average of the best 2 of 3 scores
Hello, I have a spreadsheet that has test scores in 3 columns . All 3 tests
are out of 10. I would like to create a formula that takes the average of the best 2 or the 3 tests. How would I do that? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I average 4 of the last 8 golf scores to calculate a handic | Excel Worksheet Functions | |||
| formulate tests scores then average them as percentiles in excel | New Users to Excel | |||
| Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
| I have 12 scores over 12 weeks . I want to average the highest 5 | Excel Worksheet Functions | |||
| Find top 10 scores | Excel Worksheet Functions | |||
Threaded Mode
