Help: Find the last appearence of a number ?

Hello !

Let's say I have ten rows filled with numbers on six columns, which represent the last ten lottery draws.
I need a formula to find out when the present number appeared last time in these draws.

Let's say the 11 draws is 23-37-45-9-1-39
On the other table I will get something like this:
0-3-1-8-7-2 which means:
23 has not been drawn at all in the last existent 10 draws;
37 has been drawn in the draw number 7 (or 3 draws ago);
45 has been drawn just in the last draw;
9 has been drawn in the second draw of those 10 existent draws;
1 has been drawn in the 3rd draw of those existent 10 draws;
and
39 has been drawn not in the last draw but in the one before the last one draw.

Moreover, the formula I need to do this should not count for the number position inside the rows but it should cont for the number's position from a row to another because the row itself represents a draw.

If someone could help me, this would be appreciated.

Thank you so much !