| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
