| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
subtract all numbers in an array
How can I subtract any two numbers in an array? I have a line of 24 values,
I want to be able to subtract every single possible variation of those numbers to see if it satisfies a specific criteria? |
|
#2
|
|||
|
|||
|
With 24 values, that means you'll have 24 x 24 matrix
of "variations". If your values are in A1:A24, select C1:Z24, enter the following formula in the formula bar: =A1:A24-TRANSPOSE(A1:A24) and press ctrl + shift + enter. HTH Jason Atlanta, GA -----Original Message----- How can I subtract any two numbers in an array? I have a line of 24 values, I want to be able to subtract every single possible variation of those numbers to see if it satisfies a specific criteria? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Linear Mode
