| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Weighted Average
I want to average a series of grades (ex: C1 through K1), but want to drop
the lowest score in the series. However if 2 or more grades are the same, I want to drop only ONE of them. Additionally I wish to have that "dropped" grade highlighted (conditionally formatted) in the list even though it is not calculated into the average. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating a weighted average using formula | Excel Worksheet Functions | |||
| calculating a weighted average uisng formula | Excel Worksheet Functions | |||
| Can you calculate "weighted average cost of capital? | Excel Discussion (Misc queries) | |||
| Show weighted average value after filter. | Excel Worksheet Functions | |||
| Weighted Average | Excel Discussion (Misc queries) | |||
Threaded Mode
