Please help beginner with a 20 number problem

Hello !
I am a complete beginner to Excel !
I want to solve the following numbers problem.
I was able to use some lessons on the internet to create a formula that will work for my problem, however I can`t finish it completely , so I would love for someone to help me if possible.

I attached my excel file to this post.

I created the first yellow row called ''Check for these numbers''. Here you can insert up to 20 numbers. I chose to enter only 10.
The next 5 rows each contain 10 random numbers from 1 to 20.
The ''Matches'' column on the right shows how many of the numbers from each of the 5 rows are matching with the original numbers from the yellow row.
Here is my problem:
I want the total result of matches of the 2nd row to not include numbers that already matched in the 1st row.
I want the total result of matches of the 3rd row to not include numbers that already matched in the 1st & 2nd rows. etc...
In other words duplicate matches shouldn`t be counted.

Right now the matches column displays : 4 , 4 , 7 , 6, 6, and I would like the final result to display : 4, 3, 2 , 1 , 0

Thank you very much !!!

Welcome to the forum.

XP is your Windows version - please update your profile with the version of Excel that you are using.

I am no pro here, i just made slight alteration to your existing formula in the sheet.

there might be other easier options too. right out of my head this came to my mind. see if it helps.

I kept the already existing formula in the first row of the matches as it is. ie =COUNTIF($B$2:$U$2,B3)

in the next row, i added an IF condition in the beginning =IF(W3<>0,0,COUNTIF($B$2:$U$2,B4)), since this row has to take only the previous one row into consideration.

in the next row, i added an OR function inside the IF condition. =IF(OR(W4<>0,W3<>0),0,COUNTIF($B$2:$U$2,B5)), and now this formula will take the 2 previous rows into consideration.

in the next row, adding one more OR condition and so on.

note that for each additional "place to check" rows you will have to add one more condition to the OR() in the IF.

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Sure thing. I will edit my answer. since it was a mere extension to the formula already created by the questioner, i made the answer minimal. however i will keep this in mind whenever i post a response from here on out.

this is much more easier
for some reason i always go for the longer formula

Maybe Regional settings? Try changing comma ( , ) to semi-colon ( ; ).

Post what apparently does not work with the formula in post #6 : it certainly does work!

And please show example of

If i were to add 100 more places to check