HELP: Find last appearance of a number in excel ?

Hi !

I have this file in excel test.xlsx. As you can see it search for every given number (in column H) and returns its last appearance in column I.
For doing this it uses this formula:

=MIN(IFERROR(MATCH(H2;$B$1:$B$1000;0);10^99);IFERROR(MATCH(H2;$C$1:$C$1000;0 );10^99);IFERROR(MATCH(H2;$D$1:$D$1000;0);10^99);IFERROR(MATCH(H2;$E$1:$E$1000;0);10^99);IFERROR(MATCH(H2;$F$1:$F$1000;0);10^99);IFERROR(MATCH(H2;$G$1:$G$1000;0);10^99))

and it works perfectly.

Now I am trying to get the last appearance of each number but this time horizontally and not vertically, and a little different.

Let's say I have these numbers which represents lottery draws:

31 27 19 12 38 13
15 5 40 32 3 25
40 19 36 3 25 33
6 35 11 37 5 21
38 25 36 18 6 28
25 7 39 38 4 21
20 35 8 29 5 28

What I want is to get another table with the last appearance for each number drawn in each lottery draw.

e.g. let's say for table above i should get this table:

11 2 15 81 71 32
37 13 73 88 25 99
76 40 34 23 83 2
72 27 62 31 91 2
6 82 60 39 98 85
9 12 15 78 24 72
55 80 50 30 55 15

Which means that the number 31 from above first table appeared last time 11 draws ago (valued shown in this last table). After that we see value 2 which means that number 27 from the first table appeared last time just 2 draws ago. And so on, for each number. It shows just when each number appeared last time and that's all.

I tried to do this into the table I added as attachment but it doesn't work. I used this formula:

=MIN(IFERROR(MATCH(Table45[@[Nr.1 ]];$B3:$G3;0);10^99))

Which means it looks for the number below the present draw and in each draw row by row. It is not working.
Please check attachments and please give to me some help with this problem.

Thank you so much !