Hello !
Could you please help me with the formulas required to solve the following conditions ?
All possible numbers are from 1-70
In the first yellow row can be inserted 20 different numbers. I inserted the numbers from 1-20. These 20 numbers will be excluded from the count. So now only 50 numbers remain in the problem.
The following rows each contain 20 numbers.
I need the RESULTS collumn to show how many numbers out of the 50 are in each row but excluding duplicates.
So for example the first result in my attached example is 11. These 11 numbers also need to be excluded from the following count. The next result is 14 , these 14 numbers also need to be excluded from the following count etc.
The last result will be 0 , and if I add the results I will get the total of 50.
Can anybody please help ?
Thank you very much in advance !
Bookmarks