Hello,
I am new to excel and and it would be amazing if anyone could help me out.
I have around 2000 rows with a set of 8 different numbers in each row. For instance,
2-4-7-11-15-29-35-36
4-16-20-29-32-37-49-50
etc...
Is it possible to be able to get if any 2 numbers in each line add up to a 3rd number?
For instance, in
1) 4-7-11-12-40-42-56-83, 4 + 7 add up to 11.
So I would like to get the sum 11.
2) If there are more two pairs of numbers that add up to a third number, for instance, in 1-2-4-16-20-29-49-210, 4 + 16 add up to 20 and 20+29 add up to 49, I would like to get again as a result the two sums.
If the above is not possible, please suggest any other way that I can get an indication that the lines have the above characteristic. For instance instead of getting the sums, get the number 1 instead of 11 as in the first example and get the number 2 when two pairs add up to a sum as in the second example.
I hope someone can help me out.
Thank you
Nasp