Convert from the table of 9 sums to the line of each lottery draw

[piter]

Convert from the table of 9 sums to the line of each lottery draw
http://www.mediafire.com/file/pcwdkvbbe6yqst7/pasta_sum_1a_9.xlsx

 

[Special-K99]

Convert from the table of 9 sums to the line of each lottery draw

I don't understand this.

Can you explain more?
Show with examples

 

[piter]

Você deve ver na tabela soma, as referências
Exemplo
Número 11 = igual à soma 2, portanto na posição equivalente é 2
Outro exemplo 87 olhando para a mesa e a soma 6 é, portanto, 6
A tabela de soma é a base

 

[piter]

You have to see in the table soma, the references
Example
Number 11 = equals sum 2 therefore in the equivalent position is 2
Another example 87 looking at the table and sum 6 is therefore 6
The sum table is the base

 

[piter]

In the value (00) can represent by zero (0)

 

[Special-K99]

Ah, yes

try

in AQ6:AQ14 put the row numbers 1...9 (without "row")

in V5
=SUMPRODUCT(($AS$6:$BC$14=A5)*$AQ$6:$AQ$14)

This is coming up with some odd answers like row 10 for 54 as 54 is repeated in the grid.

Or use this
in V5
=INDEX($AQ$6:$AQ$14,MAX(IF($AS$6:$BC$14=A5,ROW($AQ$6:$AQ$14)-ROW($AQ$6)+1)))
Array formula, use Ctrl-Shift-Enter

and copy to the other cells.

This ignores repeats but only finds the first occurrence in the grid.

 

[piter]

Do you get why the formula in the worksheet is for download? please

 

[piter]

sorry, sorry, error 54= correct 64

 

[piter]

hello, please

 

[markmzz]

Maybe this:

=IF(MOD(A5,9),MOD(A5,9),9)*(A5>0)

Markmzz