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? |
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? . |
All times are GMT +1. The time now is 04:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com