Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the values from a list?
Referring to the post in General Question
Does anyone have any idea on how to determine the values under following conditions? Given a list of numbers sorted by ascending order from top to bottom under column A, I would like to determine the minimum range within this list covering 50% of total numbers, and return the smallest number within the range in cell B1 and the largest number within the range in cell B2. Does anyone have any suggestions? Thank you in advance Eric |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the values from a list?
More description on question
If the list contains 10 numbers, then I need to select 5 numbers covering the minimum range, such as following example with 10 numbers, and I need to select 50% of 10 = 5 numbers covering minimum ranges. 1,3,21,40,41,42,43,44,88,99 In this case, I should select 40,41,42,43,44 41 returns in cell B1 44 returns in cell B2 Thank for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the values from a list? | Excel Discussion (Misc queries) | |||
I need to determine how frequently two values appear together | Excel Discussion (Misc queries) | |||
How to determine geometric mean of 152 values? | Excel Worksheet Functions | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
Index to determine total of values | Excel Worksheet Functions |