| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating averages (olympic style)
good morning,
i have a worksheet and i need to calculate averages with a catch. i know how to do basic averages and stuff. i need a formula to calculate the following example: data is in row 1. column a, b, c, d, e and f all have values entered in them. i need the formula to drop the lowest value and give an average for the remaining 5 only. thank you, jat jaswal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Block Averages | Excel Discussion (Misc queries) | |||
| How do I make my borded automatic black instead of pink? | Excel Worksheet Functions | |||
| Calculating weighted averages | Excel Discussion (Misc queries) | |||
| calculating averages | Excel Discussion (Misc queries) | |||
| creating intervals and calculating averages | Excel Discussion (Misc queries) | |||
Threaded Mode
