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 there any formula that can tell me if any 2 numbers in each line add up to a 3rd number?
For instance, in
4-7-11-12-40-42-56-83, 4 and 7 add up to 11.
So I would like to get the sum 11.
If there are more two pairs of number 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.
I hope someone can help me out.
Thank you
Nasp
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 there any formula that can tell me if any 2 numbers in each line add up to a 3rd number?
For instance, in
4-7-11-12-40-42-56-83, 4 and 7 add up to 11.
So I would like to get the sum 11.
If there are more two pairs of number 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.
I hope someone can help me out.
Thank you
Nasp