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?
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?
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?
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks