| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using an array with an additional independent cell value
I want to calculate the kth smallest number of an array, but the formula must
take the array values by subtracting a constant from each array value. I know you can tell me to design a new array by subtracting a constant from each array value, but i wonder whether i can skip an additional column. The formula below is WRONG but can express what i meant to do: =SMALL(({A1-B1;A2-B1;A3-B1;A4-B1});3) Thanks for help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Additional cell colours | Excel Discussion (Misc queries) | |||
| how to set up a simple variable in Excel, but cell location independent | New Users to Excel | |||
| how to set up a simple variable in Excel, but cell location independent | Excel Worksheet Functions | |||
| can one cell contain more than one independent number | Excel Discussion (Misc queries) | |||
| Add additional value to a cell | Excel Programming | |||
Threaded Mode
