I hope you can help me with the following problem I am encountering.
I have around 2000 rows with a set of 8 different numbers in each row. For instance,
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 a “Yes” or “X” when this happens.
If the above is not possible, I don’t mind any other solution that would give me an indication that the above event exists in a line.
Just to be honest, I have posted a question to this problem in another forum but I have not gotten a reply.
Thank you in advance