I have 4 columns and 3 rows that will have a number in them. No number in a column will be the same but numbers in the rows can be the same. I need a box to automatically tell me the if the numbers are the same.

Example

A1 - 3 B1 - 5 C1 - 5 D1 - 4

A2 - 5 B2 - 3 C2 - 1 D2 - 7

A3 - 1 B3 - 6 C3 - 3 D3 - 5

So I want a box to say that 5 is in all of them.

Another box to say 3 is in 3 of them.

And another 1 that says 1 is in 2 of them.

Can someone help me out if this is possible?