Hi Jerry,
I did gave the macro a try but unfortunately I cannot get it to produce the desired results. This is because I want to avoid counting duplicate matches. The maximum match each column can have is 1. So the max total result in AE that can be achieved in any circumstance is 7.

By taking for example the first column, if all 10 values in J33:J42 look for the numbers in the B column in order to count a possible match with number 3 in W42, and two cells in column B match number 3 in W42, the count for the 1st column is still 1, not 2.

I hope I am making sense. Thank you for your reply