| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SMALL() on unknown length of list
To add the smallest 50% values in A1, A3, A5, A7: SUM( SMALL(
(A1,A3,A5,A7), {1,2} ) ) How do I do this if the length of my list is not fixed. Say, the length is stored in B1. Assume the list always starts at A1 and skips 1 column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
| How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| Font too small in Incell drop down list | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Threaded Mode
