Count number in row if another number exist

Hi,

I want to count how many times specific number appear (f.x. no 12) in a column if number 1 is in the column.
I want to count how many times specific number appear (f.x. no 10) in a column if number 2 is in the column.

Problem is, I have many columns I cannot combine it.

Example
A B C
1 1 9
15 5 15
33 17 23
36 22 28
38 36 29

I want to find out in row A, B and C if 1 is in any column (here in column A), how many times number 2, 3, 4 etc appears.

Result here is
Number 1
5 , 1x
15, 1x
17, 1x
22, 1x
33, 1x
36, 2x
38, 1x

Number 15
1, 1x
9, 1x
23,1x
28,1x
29,1x
33,1x
36,1x
38,1x

I want to put this in array

Please confirm that when you say ROW, you mean COLUMN?

I want to find out in row A, B and C

These are columns, not rows?

Take a look at the attached. Im not sure which way you want to do this...the 1st tableA9:D49 is based on the values of each column, the 2nd table is based on the values from all columns

@ toothless...true

Happy to help