Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to find the median 3 values in a range, which will be added together.
I will have either 3, 5, or 7 values in the range. If I have 3 values, I just need to add them; with 5 values, I need to throw out the high and low values; and with 7 values, I need to throw out the 2 high and 2 low values. For example: Range: 3, 5, 5, 6, 4 Result: 5+5+4 (throw out 3 and 6) Range: 5, 7, 6, 5, 7, 7, 6 Result: 7+6+6 (throw out both 5s and two of the 7s) Can anyone help with this? Thanks, ~ Horatio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to display graph if only mean, SD & median values available? | Charts and Charting in Excel | |||
find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
Counting values lower then the median. | Excel Worksheet Functions | |||
Median ignoring Zero Values | Excel Worksheet Functions | |||
Find Median of Positive numbers only in Range | Excel Worksheet Functions |