ナンバーズ3の予想をしてみる - エクセル関数の使い方

ナンバーズ3の予想をしてみる
（いろんな関数のいろんな使い方を紹介）

ナンバーズ3(NUMBERS3)過去の抽せん結果のページから
「100回号分」を検索して結果をコピーしてB1に貼り付けます

000～999の3桁の数値だとつまらないので
3桁の数字として考えず1桁1桁予測します

---------3桁の数値を百の位、十の位、一の位と分割します

K3セルに百の位を呼び出します
エクセルに貼り付けると最初の「0」は消えてしまうので3桁あるものとして考えます
=IF(LEN(D3)<3,"0",MID(D3,LEN(D3)-2,1))
LEN関数で文字数を数えて2文字以下なら0と判断し3桁あればMID関数で1文字抜き出します

L3セルに十の位を呼び出します
=IF(LEN(D3)<2,"0",MID(D3,LEN(D3)-1,1))
LEN関数で文字数を数えて1文字以下なら0と判断し2桁あればMID関数で1文字抜き出します

M3セルに十の位を呼び出します
=MID(D3,LEN(D3),1)
MID関数で1文字抜き出します

K3からM4のセルを選択して下へソートします
※K3からM3だと1行の空白に変な数値が出ます空白をキープするためK3からM4のセルを選択します

これで百の位、十の位、一の位と分離できます

---------
---------出現数と出現率を出します

まず列に対する出現数を出します
セルP3百の位）=COUNTIF(K:K,O3)
セルQ3十の位）=COUNTIF(L:L,O3)
セルR3一の位）=COUNTIF(M:M,O3)

上記に対する出現率を出します
セルV3百の位）=P3/SUM($P$3:$P$12)*100
セルW3十の位）=Q3/SUM($Q$3:$Q$12)*100
セルX3一の位）=R3/SUM($R$3:$R$12)*100

100回の出現率ですから同じになります
出現数を列で数えているので過去の抽せん結果から
100回以上300回でも400回でも対応できます

予想の考え方ですが
・過去に出現数が少ない方が出やすい
と考えるか
・いっぱいでるんだからまた出る
と考えるか
ここでは両方を考慮します

出現率に順位を付けます
セルAB3百の位）=RANK(V3,$V$3:$V$12,1)
セルAC3十の位）=RANK(W3,$W$3:$W$12,1)
セルAD3一の位）=RANK(X3,$X$3:$X$12,1)

これだけだと過去の出現率に対する数値ですから
直近10回を取得します
（全体の出現数が同じ場合、直近10回が少ない方を有利にするため）

10回出現数
セルS3百の位）=COUNTIF($K$3:$K$22,O3)
セルT3十の位）=COUNTIF($L$3:$L$22,O3)
セルU3一の位）=COUNTIF($M$3:$M$22,O3)

上記に対する出現率を出します
セルY3百の位）=S3/SUM($S$3:$S$12)*100
セルZ3十の位）=T3/SUM($T$3:$T$12)*100
セルAA3一の位）=U3/SUM($U$3:$U$12)*100

上記に対する出現率の順位を出します
セルAE3百の位）=RANK(Y3,$Y$3:$Y$12,1)
セルAF3十の位）=RANK(Z3,$Z$3:$Z$12,1)
セルAG3一の位）=RANK(AA3,$AA$3:$AA$12,1)

最後に片寄った出現数があるかもしれないので
全体に対する出現数を取得します

セルAH3全体数）=COUNTIF(K:M,O3)
セルAH3全体数順位）=RANK(AH3,$AH$3:$AH$12,1)

百の位、十の位、一の位出現率

---------
---------抽選

これで使用する全部のデータが集まりました
下記の考え方で組み合わせていきます

・100回中1番少ない出現数と2番少ない出現数、1番多い出現数の値が出る確率が高い？
・直近10回で出現数の少ない方が出やすい？
・全体の数値から出現数の少ない方が出やすい？

100回中の順位が同じならば
10回中の出現数が少ない方が少しだけ有利にするため
100回中の順位に「10回中/2」を足してみる
同じように
全体の出現数が少ない方が少しだけ有利にするため
全体の順位に「全体/5」を足してみる
セルAB17百の位）=AB3+(AE3/2)+(AI3/5)
セルAC17十の位）=AC3+(AF3/2)+(AI3/5)
セルAD17一の位）=AD3+(AG3/2)+(AI3/5)

上記に順位を付けます
セルAE17百の位）=RANK(AB17,$AB$17:AB$26,1)
セルAF17十の位）=RANK(AC17,$AC$17:AC$26,1)
セルAG17一の位）=RANK(AD17,$AD$17:AD$26,1)

確率から計算しないのは40%と60%では20も差がありますが
順位なら3位とか5位とか差が少なくなるようにするためです

順位付けはここまでで本題の予測
予想2から数値の低い順（出現数が少ない数値）に2つ
予想2から数値の高い順（出現数が多い数値）に1つ
抜き出します

セルAE29百の位　1番出現数が少ない）
=VLOOKUP(SMALL($AE$17:$AE$26,1),$AE$17:$AJ$26,6,0)
セルAE30百の位　2番目に出現数が少ない）
=VLOOKUP(SMALL($AE$17:$AE$26,2),$AE$17:$AJ$26,6,0)
セルAE31百の位　1番出現数が多い）
=VLOOKUP(LARGE($AE$17:$AE$26,1),$AE$17:$AJ$26,6,0)
これで百の位の候補を3つ取り出しました

同じように十の位
セルAF29十の位　1番出現数が少ない）
=VLOOKUP(SMALL($AF$17:$AF$26,1),$AF$17:$AJ$26,5,0)
セルAF30十の位　2番目に出現数が少ない）
=VLOOKUP(SMALL($AF$17:$AF$26,2),$AF$17:$AJ$26,5,0)
セルAF31十の位　1番出現数が多い）
=VLOOKUP(LARGE($AF$17:$AF$26,1),$AF$17:$AJ$26,5,0)
これで十の位の候補を3つ取り出しました

続いて一の位
セルAG29一の位　1番出現数が少ない）
=VLOOKUP(SMALL($AG$17:$AG$26,1),$AG$17:$AJ$26,4,0)
セルAG30一の位　2番目に出現数が少ない）
=VLOOKUP(SMALL($AG$17:$AG$26,2),$AG$17:$AJ$26,4,0)
セルAG31一の位　1番出現数が多い）
=VLOOKUP(LARGE($AG$17:$AG$26,1),$AG$17:$AJ$26,4,0)
これで一の位の候補を3つ取り出しました

1・1・1
2・2・2
10・10・10

3つずつですから組み合わせは27種類ですが
「1番出現数が多い」が2つ以上は少ないと思われますので減ります
ここからカンで
1・1・1
1・2・10
10・1・2
など取り出しても良いのですが
それでは関数のお勉強になりません（ﾍﾞﾝｷｮｳﾀﾞｯﾀﾉｶｯ

RAND()関数を使いたいところですが
シートが再計算されてしまうので使いません

予想4は27通りすべての結果になります
ここからこれは無いだろうと思われるものを排除します

---------
---------ここからは勝手な排除

まず10が2個以上は無いと思う（出現数が高いのが2つ以上）
セルAH34）=IF(AA34+AB34+AC34>20,"×","")（セルAH60まで）
あんまり減りません（7つ）

2が2個以上も排除してみる
セルAI34）=IF( COUNTIF(AA34:AC34,"2")>1,"×","")（セルAI60まで）
やっぱり減りません（7つ）

1が連続した場合を排除してみる
セルAJ34）=IF(AA34+AB34=2,"×",IF(AB34+AC34=2,"×",""))（セルAJ60まで）
やっぱり減りません（5つ）
過去100回に同じ数字があれば排除
セルAK34）
=IFERROR(IF(VLOOKUP(INT(AE34&AF34&AG34),D:D,1,0)=INT(AE34&AF34&AG34),"×",""),"")
過去100回だとあまりないでしょう

出現率

---------
---------結果

予想5が今回の数式で出る確率が高いものになります

---------
---------おまけ

ここまでです
数が多すぎてめんどくさっと思われる方は
下記をコピーしてセルK1に貼り付けてください
（K1からAM60までのコピーです）（書式はコピーされません）
テーブルに変換してます実際の結果とは違うかもしれませんセルK,M,Lは過去の結果から取得した分ソートしてください
過去の結果が無いと多くのセルがエラーになります

<table border="1">
<tr>
<td></td><td></td><td></td><td></td><td></td><td>100出現数</td><td></td><td></td><td>10出現数</td><td></td><td></td><td>100出現率</td><td></td><td></td><td>10出現率</td><td></td><td></td><td>100出現順位</td><td></td><td></td><td>10出現順位</td><td></td><td></td><td>全体</td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>百</td><td>十</td><td>一</td><td></td><td></td><td>百</td><td>十</td><td>一</td><td>百</td><td>十</td><td>一</td><td>百</td><td>十</td><td>一</td><td>百</td><td>十</td><td>一</td><td>百</td><td>十</td><td>一</td><td>百</td><td>十</td><td>一</td><td>数</td><td>順位</td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D3)<3,"0",MID(D3,LEN(D3)-2,1))</td><td>=IF(LEN(D3)<2,"0",MID(D3,LEN(D3)-1,1))</td><td>=MID(D3,LEN(D3),1)</td><td></td><td>0</td><td>=COUNTIF(K:K,O3)</td><td>=COUNTIF(L:L,O3)</td><td>=COUNTIF(M:M,O3)</td><td>=COUNTIF($K$3:$K$22,O3)</td><td>=COUNTIF($L$3:$L$22,O3)</td><td>=COUNTIF($M$3:$M$22,O3)</td><td>=P3/SUM($P$3:$P$12)*100</td><td>=Q3/SUM($Q$3:$Q$12)*100</td><td>=R3/SUM($R$3:$R$12)*100</td><td>=S3/SUM($S$3:$S$12)*100</td><td>=T3/SUM($T$3:$T$12)*100</td><td>=U3/SUM($U$3:$U$12)*100</td><td>=RANK(V3,$V$3:$V$12,1)</td><td>=RANK(W3,$W$3:$W$12,1)</td><td>=RANK(X3,$X$3:$X$12,1)</td><td>=RANK(Y3,$Y$3:$Y$12,1)</td><td>=RANK(Z3,$Z$3:$Z$12,1)</td><td>=RANK(AA3,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O3)</td><td>=RANK(AH3,$AH$3:$AH$12,1)</td><td>0</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td>1</td><td>=COUNTIF(K:K,O4)</td><td>=COUNTIF(L:L,O4)</td><td>=COUNTIF(M:M,O4)</td><td>=COUNTIF($K$3:$K$22,O4)</td><td>=COUNTIF($L$3:$L$22,O4)</td><td>=COUNTIF($M$3:$M$22,O4)</td><td>=P4/SUM($P$3:$P$12)*100</td><td>=Q4/SUM($Q$3:$Q$12)*100</td><td>=R4/SUM($R$3:$R$12)*100</td><td>=S4/SUM($S$3:$S$12)*100</td><td>=T4/SUM($T$3:$T$12)*100</td><td>=U4/SUM($U$3:$U$12)*100</td><td>=RANK(V4,$V$3:$V$12,1)</td><td>=RANK(W4,$W$3:$W$12,1)</td><td>=RANK(X4,$X$3:$X$12,1)</td><td>=RANK(Y4,$Y$3:$Y$12,1)</td><td>=RANK(Z4,$Z$3:$Z$12,1)</td><td>=RANK(AA4,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O4)</td><td>=RANK(AH4,$AH$3:$AH$12,1)</td><td>1</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D5)<3,"0",MID(D5,LEN(D5)-2,1))</td><td>=IF(LEN(D5)<2,"0",MID(D5,LEN(D5)-1,1))</td><td>=MID(D5,LEN(D5),1)</td><td></td><td>2</td><td>=COUNTIF(K:K,O5)</td><td>=COUNTIF(L:L,O5)</td><td>=COUNTIF(M:M,O5)</td><td>=COUNTIF($K$3:$K$22,O5)</td><td>=COUNTIF($L$3:$L$22,O5)</td><td>=COUNTIF($M$3:$M$22,O5)</td><td>=P5/SUM($P$3:$P$12)*100</td><td>=Q5/SUM($Q$3:$Q$12)*100</td><td>=R5/SUM($R$3:$R$12)*100</td><td>=S5/SUM($S$3:$S$12)*100</td><td>=T5/SUM($T$3:$T$12)*100</td><td>=U5/SUM($U$3:$U$12)*100</td><td>=RANK(V5,$V$3:$V$12,1)</td><td>=RANK(W5,$W$3:$W$12,1)</td><td>=RANK(X5,$X$3:$X$12,1)</td><td>=RANK(Y5,$Y$3:$Y$12,1)</td><td>=RANK(Z5,$Z$3:$Z$12,1)</td><td>=RANK(AA5,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O5)</td><td>=RANK(AH5,$AH$3:$AH$12,1)</td><td>2</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td>3</td><td>=COUNTIF(K:K,O6)</td><td>=COUNTIF(L:L,O6)</td><td>=COUNTIF(M:M,O6)</td><td>=COUNTIF($K$3:$K$22,O6)</td><td>=COUNTIF($L$3:$L$22,O6)</td><td>=COUNTIF($M$3:$M$22,O6)</td><td>=P6/SUM($P$3:$P$12)*100</td><td>=Q6/SUM($Q$3:$Q$12)*100</td><td>=R6/SUM($R$3:$R$12)*100</td><td>=S6/SUM($S$3:$S$12)*100</td><td>=T6/SUM($T$3:$T$12)*100</td><td>=U6/SUM($U$3:$U$12)*100</td><td>=RANK(V6,$V$3:$V$12,1)</td><td>=RANK(W6,$W$3:$W$12,1)</td><td>=RANK(X6,$X$3:$X$12,1)</td><td>=RANK(Y6,$Y$3:$Y$12,1)</td><td>=RANK(Z6,$Z$3:$Z$12,1)</td><td>=RANK(AA6,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O6)</td><td>=RANK(AH6,$AH$3:$AH$12,1)</td><td>3</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D7)<3,"0",MID(D7,LEN(D7)-2,1))</td><td>=IF(LEN(D7)<2,"0",MID(D7,LEN(D7)-1,1))</td><td>=MID(D7,LEN(D7),1)</td><td></td><td>4</td><td>=COUNTIF(K:K,O7)</td><td>=COUNTIF(L:L,O7)</td><td>=COUNTIF(M:M,O7)</td><td>=COUNTIF($K$3:$K$22,O7)</td><td>=COUNTIF($L$3:$L$22,O7)</td><td>=COUNTIF($M$3:$M$22,O7)</td><td>=P7/SUM($P$3:$P$12)*100</td><td>=Q7/SUM($Q$3:$Q$12)*100</td><td>=R7/SUM($R$3:$R$12)*100</td><td>=S7/SUM($S$3:$S$12)*100</td><td>=T7/SUM($T$3:$T$12)*100</td><td>=U7/SUM($U$3:$U$12)*100</td><td>=RANK(V7,$V$3:$V$12,1)</td><td>=RANK(W7,$W$3:$W$12,1)</td><td>=RANK(X7,$X$3:$X$12,1)</td><td>=RANK(Y7,$Y$3:$Y$12,1)</td><td>=RANK(Z7,$Z$3:$Z$12,1)</td><td>=RANK(AA7,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O7)</td><td>=RANK(AH7,$AH$3:$AH$12,1)</td><td>4</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td>5</td><td>=COUNTIF(K:K,O8)</td><td>=COUNTIF(L:L,O8)</td><td>=COUNTIF(M:M,O8)</td><td>=COUNTIF($K$3:$K$22,O8)</td><td>=COUNTIF($L$3:$L$22,O8)</td><td>=COUNTIF($M$3:$M$22,O8)</td><td>=P8/SUM($P$3:$P$12)*100</td><td>=Q8/SUM($Q$3:$Q$12)*100</td><td>=R8/SUM($R$3:$R$12)*100</td><td>=S8/SUM($S$3:$S$12)*100</td><td>=T8/SUM($T$3:$T$12)*100</td><td>=U8/SUM($U$3:$U$12)*100</td><td>=RANK(V8,$V$3:$V$12,1)</td><td>=RANK(W8,$W$3:$W$12,1)</td><td>=RANK(X8,$X$3:$X$12,1)</td><td>=RANK(Y8,$Y$3:$Y$12,1)</td><td>=RANK(Z8,$Z$3:$Z$12,1)</td><td>=RANK(AA8,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O8)</td><td>=RANK(AH8,$AH$3:$AH$12,1)</td><td>5</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D9)<3,"0",MID(D9,LEN(D9)-2,1))</td><td>=IF(LEN(D9)<2,"0",MID(D9,LEN(D9)-1,1))</td><td>=MID(D9,LEN(D9),1)</td><td></td><td>6</td><td>=COUNTIF(K:K,O9)</td><td>=COUNTIF(L:L,O9)</td><td>=COUNTIF(M:M,O9)</td><td>=COUNTIF($K$3:$K$22,O9)</td><td>=COUNTIF($L$3:$L$22,O9)</td><td>=COUNTIF($M$3:$M$22,O9)</td><td>=P9/SUM($P$3:$P$12)*100</td><td>=Q9/SUM($Q$3:$Q$12)*100</td><td>=R9/SUM($R$3:$R$12)*100</td><td>=S9/SUM($S$3:$S$12)*100</td><td>=T9/SUM($T$3:$T$12)*100</td><td>=U9/SUM($U$3:$U$12)*100</td><td>=RANK(V9,$V$3:$V$12,1)</td><td>=RANK(W9,$W$3:$W$12,1)</td><td>=RANK(X9,$X$3:$X$12,1)</td><td>=RANK(Y9,$Y$3:$Y$12,1)</td><td>=RANK(Z9,$Z$3:$Z$12,1)</td><td>=RANK(AA9,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O9)</td><td>=RANK(AH9,$AH$3:$AH$12,1)</td><td>6</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td>7</td><td>=COUNTIF(K:K,O10)</td><td>=COUNTIF(L:L,O10)</td><td>=COUNTIF(M:M,O10)</td><td>=COUNTIF($K$3:$K$22,O10)</td><td>=COUNTIF($L$3:$L$22,O10)</td><td>=COUNTIF($M$3:$M$22,O10)</td><td>=P10/SUM($P$3:$P$12)*100</td><td>=Q10/SUM($Q$3:$Q$12)*100</td><td>=R10/SUM($R$3:$R$12)*100</td><td>=S10/SUM($S$3:$S$12)*100</td><td>=T10/SUM($T$3:$T$12)*100</td><td>=U10/SUM($U$3:$U$12)*100</td><td>=RANK(V10,$V$3:$V$12,1)</td><td>=RANK(W10,$W$3:$W$12,1)</td><td>=RANK(X10,$X$3:$X$12,1)</td><td>=RANK(Y10,$Y$3:$Y$12,1)</td><td>=RANK(Z10,$Z$3:$Z$12,1)</td><td>=RANK(AA10,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O10)</td><td>=RANK(AH10,$AH$3:$AH$12,1)</td><td>7</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D11)<3,"0",MID(D11,LEN(D11)-2,1))</td><td>=IF(LEN(D11)<2,"0",MID(D11,LEN(D11)-1,1))</td><td>=MID(D11,LEN(D11),1)</td><td></td><td>8</td><td>=COUNTIF(K:K,O11)</td><td>=COUNTIF(L:L,O11)</td><td>=COUNTIF(M:M,O11)</td><td>=COUNTIF($K$3:$K$22,O11)</td><td>=COUNTIF($L$3:$L$22,O11)</td><td>=COUNTIF($M$3:$M$22,O11)</td><td>=P11/SUM($P$3:$P$12)*100</td><td>=Q11/SUM($Q$3:$Q$12)*100</td><td>=R11/SUM($R$3:$R$12)*100</td><td>=S11/SUM($S$3:$S$12)*100</td><td>=T11/SUM($T$3:$T$12)*100</td><td>=U11/SUM($U$3:$U$12)*100</td><td>=RANK(V11,$V$3:$V$12,1)</td><td>=RANK(W11,$W$3:$W$12,1)</td><td>=RANK(X11,$X$3:$X$12,1)</td><td>=RANK(Y11,$Y$3:$Y$12,1)</td><td>=RANK(Z11,$Z$3:$Z$12,1)</td><td>=RANK(AA11,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O11)</td><td>=RANK(AH11,$AH$3:$AH$12,1)</td><td>8</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td>9</td><td>=COUNTIF(K:K,O12)</td><td>=COUNTIF(L:L,O12)</td><td>=COUNTIF(M:M,O12)</td><td>=COUNTIF($K$3:$K$22,O12)</td><td>=COUNTIF($L$3:$L$22,O12)</td><td>=COUNTIF($M$3:$M$22,O12)</td><td>=P12/SUM($P$3:$P$12)*100</td><td>=Q12/SUM($Q$3:$Q$12)*100</td><td>=R12/SUM($R$3:$R$12)*100</td><td>=S12/SUM($S$3:$S$12)*100</td><td>=T12/SUM($T$3:$T$12)*100</td><td>=U12/SUM($U$3:$U$12)*100</td><td>=RANK(V12,$V$3:$V$12,1)</td><td>=RANK(W12,$W$3:$W$12,1)</td><td>=RANK(X12,$X$3:$X$12,1)</td><td>=RANK(Y12,$Y$3:$Y$12,1)</td><td>=RANK(Z12,$Z$3:$Z$12,1)</td><td>=RANK(AA12,$AA$3:$AA$12,1)</td><td>=COUNTIF(K:M,O12)</td><td>=RANK(AH12,$AH$3:$AH$12,1)</td><td>9</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D13)<3,"0",MID(D13,LEN(D13)-2,1))</td><td>=IF(LEN(D13)<2,"0",MID(D13,LEN(D13)-1,1))</td><td>=MID(D13,LEN(D13),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D15)<3,"0",MID(D15,LEN(D15)-2,1))</td><td>=IF(LEN(D15)<2,"0",MID(D15,LEN(D15)-1,1))</td><td>=MID(D15,LEN(D15),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>予想1</td><td></td><td></td><td>予想2</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>百</td><td>十</td><td>一</td><td>百</td><td>十</td><td>一</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D17)<3,"0",MID(D17,LEN(D17)-2,1))</td><td>=IF(LEN(D17)<2,"0",MID(D17,LEN(D17)-1,1))</td><td>=MID(D17,LEN(D17),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB3+(AE3/2)+(AI3/5)</td><td>=AC3+(AF3/2)+(AI3/5)</td><td>=AD3+(AG3/2)+(AI3/5)</td><td>=RANK(AB17,$AB$17:AB$26,1)</td><td>=RANK(AC17,$AC$17:AC$26,1)</td><td>=RANK(AD17,$AD$17:AD$26,1)</td><td></td><td></td><td>0</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB4+(AE4/2)+(AI4/5)</td><td>=AC4+(AF4/2)+(AI4/5)</td><td>=AD4+(AG4/2)+(AI4/5)</td><td>=RANK(AB18,$AB$17:AB$26,1)</td><td>=RANK(AC18,$AC$17:AC$26,1)</td><td>=RANK(AD18,$AD$17:AD$26,1)</td><td></td><td></td><td>1</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D19)<3,"0",MID(D19,LEN(D19)-2,1))</td><td>=IF(LEN(D19)<2,"0",MID(D19,LEN(D19)-1,1))</td><td>=MID(D19,LEN(D19),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB5+(AE5/2)+(AI5/5)</td><td>=AC5+(AF5/2)+(AI5/5)</td><td>=AD5+(AG5/2)+(AI5/5)</td><td>=RANK(AB19,$AB$17:AB$26,1)</td><td>=RANK(AC19,$AC$17:AC$26,1)</td><td>=RANK(AD19,$AD$17:AD$26,1)</td><td></td><td></td><td>2</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB6+(AE6/2)+(AI6/5)</td><td>=AC6+(AF6/2)+(AI6/5)</td><td>=AD6+(AG6/2)+(AI6/5)</td><td>=RANK(AB20,$AB$17:AB$26,1)</td><td>=RANK(AC20,$AC$17:AC$26,1)</td><td>=RANK(AD20,$AD$17:AD$26,1)</td><td></td><td></td><td>3</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D21)<3,"0",MID(D21,LEN(D21)-2,1))</td><td>=IF(LEN(D21)<2,"0",MID(D21,LEN(D21)-1,1))</td><td>=MID(D21,LEN(D21),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB7+(AE7/2)+(AI7/5)</td><td>=AC7+(AF7/2)+(AI7/5)</td><td>=AD7+(AG7/2)+(AI7/5)</td><td>=RANK(AB21,$AB$17:AB$26,1)</td><td>=RANK(AC21,$AC$17:AC$26,1)</td><td>=RANK(AD21,$AD$17:AD$26,1)</td><td></td><td></td><td>4</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB8+(AE8/2)+(AI8/5)</td><td>=AC8+(AF8/2)+(AI8/5)</td><td>=AD8+(AG8/2)+(AI8/5)</td><td>=RANK(AB22,$AB$17:AB$26,1)</td><td>=RANK(AC22,$AC$17:AC$26,1)</td><td>=RANK(AD22,$AD$17:AD$26,1)</td><td></td><td></td><td>5</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D23)<3,"0",MID(D23,LEN(D23)-2,1))</td><td>=IF(LEN(D23)<2,"0",MID(D23,LEN(D23)-1,1))</td><td>=MID(D23,LEN(D23),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB9+(AE9/2)+(AI9/5)</td><td>=AC9+(AF9/2)+(AI9/5)</td><td>=AD9+(AG9/2)+(AI9/5)</td><td>=RANK(AB23,$AB$17:AB$26,1)</td><td>=RANK(AC23,$AC$17:AC$26,1)</td><td>=RANK(AD23,$AD$17:AD$26,1)</td><td></td><td></td><td>6</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB10+(AE10/2)+(AI10/5)</td><td>=AC10+(AF10/2)+(AI10/5)</td><td>=AD10+(AG10/2)+(AI10/5)</td><td>=RANK(AB24,$AB$17:AB$26,1)</td><td>=RANK(AC24,$AC$17:AC$26,1)</td><td>=RANK(AD24,$AD$17:AD$26,1)</td><td></td><td></td><td>7</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D25)<3,"0",MID(D25,LEN(D25)-2,1))</td><td>=IF(LEN(D25)<2,"0",MID(D25,LEN(D25)-1,1))</td><td>=MID(D25,LEN(D25),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB11+(AE11/2)+(AI11/5)</td><td>=AC11+(AF11/2)+(AI11/5)</td><td>=AD11+(AG11/2)+(AI11/5)</td><td>=RANK(AB25,$AB$17:AB$26,1)</td><td>=RANK(AC25,$AC$17:AC$26,1)</td><td>=RANK(AD25,$AD$17:AD$26,1)</td><td></td><td></td><td>8</td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>=AB12+(AE12/2)+(AI12/5)</td><td>=AC12+(AF12/2)+(AI12/5)</td><td>=AD12+(AG12/2)+(AI12/5)</td><td>=RANK(AB26,$AB$17:AB$26,1)</td><td>=RANK(AC26,$AC$17:AC$26,1)</td><td>=RANK(AD26,$AD$17:AD$26,1)</td><td></td><td></td><td>9</td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D27)<3,"0",MID(D27,LEN(D27)-2,1))</td><td>=IF(LEN(D27)<2,"0",MID(D27,LEN(D27)-1,1))</td><td>=MID(D27,LEN(D27),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>予想3</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D29)<3,"0",MID(D29,LEN(D29)-2,1))</td><td>=IF(LEN(D29)<2,"0",MID(D29,LEN(D29)-1,1))</td><td>=MID(D29,LEN(D29),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>=VLOOKUP(SMALL($AE$17:$AE$26,1),$AE$17:$AJ$26,6,0)</td><td>=VLOOKUP(SMALL($AF$17:$AF$26,1),$AF$17:$AJ$26,5,0)</td><td>=VLOOKUP(SMALL($AG$17:$AG$26,1),$AG$17:$AJ$26,4,0)</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>=VLOOKUP(SMALL($AE$17:$AE$26,2),$AE$17:$AJ$26,6,0)</td><td>=VLOOKUP(SMALL($AF$17:$AF$26,2),$AF$17:$AJ$26,5,0)</td><td>=VLOOKUP(SMALL($AG$17:$AG$26,2),$AG$17:$AJ$26,4,0)</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D31)<3,"0",MID(D31,LEN(D31)-2,1))</td><td>=IF(LEN(D31)<2,"0",MID(D31,LEN(D31)-1,1))</td><td>=MID(D31,LEN(D31),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>=VLOOKUP(LARGE($AE$17:$AE$26,1),$AE$17:$AJ$26,6,0)</td><td>=VLOOKUP(LARGE($AF$17:$AF$26,1),$AF$17:$AJ$26,5,0)</td><td>=VLOOKUP(LARGE($AG$17:$AG$26,1),$AG$17:$AJ$26,4,0)</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr>
<td>=IF(LEN(D33)<3,"0",MID(D33,LEN(D33)-2,1))</td><td>=IF(LEN(D33)<2,"0",MID(D33,LEN(D33)-1,1))</td><td>=MID(D33,LEN(D33),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>組み合わせ</td><td></td><td></td><td></td><td>予想4</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>予想5</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>1</td><td>1</td><td></td><td>=VLOOKUP(AA34,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB34,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC34,$AD$29:$AG$31,4,0)</td><td>=IF(AA34+AB34+AC34>20,"×","")</td><td>=IF( COUNTIF(AA34:AC34,"2")>1,"×","")</td><td>=IF(AA34+AB34=2,"×",IF(AB34+AC34=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE34&AF34&AG34),D:D,1,0)=INT(AE34&AF34&AG34),"×",""),"")</td><td>=IF(AH34&AI34&AJ34&AK34="","〇","")</td><td>=IF(AL34="〇",AE34&AF34&AG34,"")</td></tr>
<tr>
<td>=IF(LEN(D35)<3,"0",MID(D35,LEN(D35)-2,1))</td><td>=IF(LEN(D35)<2,"0",MID(D35,LEN(D35)-1,1))</td><td>=MID(D35,LEN(D35),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>1</td><td>2</td><td></td><td>=VLOOKUP(AA35,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB35,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC35,$AD$29:$AG$31,4,0)</td><td>=IF(AA35+AB35+AC35>20,"×","")</td><td>=IF( COUNTIF(AA35:AC35,"2")>1,"×","")</td><td>=IF(AA35+AB35=2,"×",IF(AB35+AC35=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE35&AF35&AG35),D:D,1,0)=INT(AE35&AF35&AG35),"×",""),"")</td><td>=IF(AH35&AI35&AJ35&AK35="","〇","")</td><td>=IF(AL35="〇",AE35&AF35&AG35,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>1</td><td>10</td><td></td><td>=VLOOKUP(AA36,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB36,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC36,$AD$29:$AG$31,4,0)</td><td>=IF(AA36+AB36+AC36>20,"×","")</td><td>=IF( COUNTIF(AA36:AC36,"2")>1,"×","")</td><td>=IF(AA36+AB36=2,"×",IF(AB36+AC36=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE36&AF36&AG36),D:D,1,0)=INT(AE36&AF36&AG36),"×",""),"")</td><td>=IF(AH36&AI36&AJ36&AK36="","〇","")</td><td>=IF(AL36="〇",AE36&AF36&AG36,"")</td></tr>
<tr>
<td>=IF(LEN(D37)<3,"0",MID(D37,LEN(D37)-2,1))</td><td>=IF(LEN(D37)<2,"0",MID(D37,LEN(D37)-1,1))</td><td>=MID(D37,LEN(D37),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>2</td><td>1</td><td></td><td>=VLOOKUP(AA37,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB37,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC37,$AD$29:$AG$31,4,0)</td><td>=IF(AA37+AB37+AC37>20,"×","")</td><td>=IF( COUNTIF(AA37:AC37,"2")>1,"×","")</td><td>=IF(AA37+AB37=2,"×",IF(AB37+AC37=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE37&AF37&AG37),D:D,1,0)=INT(AE37&AF37&AG37),"×",""),"")</td><td>=IF(AH37&AI37&AJ37&AK37="","〇","")</td><td>=IF(AL37="〇",AE37&AF37&AG37,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>2</td><td>2</td><td></td><td>=VLOOKUP(AA38,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB38,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC38,$AD$29:$AG$31,4,0)</td><td>=IF(AA38+AB38+AC38>20,"×","")</td><td>=IF( COUNTIF(AA38:AC38,"2")>1,"×","")</td><td>=IF(AA38+AB38=2,"×",IF(AB38+AC38=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE38&AF38&AG38),D:D,1,0)=INT(AE38&AF38&AG38),"×",""),"")</td><td>=IF(AH38&AI38&AJ38&AK38="","〇","")</td><td>=IF(AL38="〇",AE38&AF38&AG38,"")</td></tr>
<tr>
<td>=IF(LEN(D39)<3,"0",MID(D39,LEN(D39)-2,1))</td><td>=IF(LEN(D39)<2,"0",MID(D39,LEN(D39)-1,1))</td><td>=MID(D39,LEN(D39),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>2</td><td>10</td><td></td><td>=VLOOKUP(AA39,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB39,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC39,$AD$29:$AG$31,4,0)</td><td>=IF(AA39+AB39+AC39>20,"×","")</td><td>=IF( COUNTIF(AA39:AC39,"2")>1,"×","")</td><td>=IF(AA39+AB39=2,"×",IF(AB39+AC39=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE39&AF39&AG39),D:D,1,0)=INT(AE39&AF39&AG39),"×",""),"")</td><td>=IF(AH39&AI39&AJ39&AK39="","〇","")</td><td>=IF(AL39="〇",AE39&AF39&AG39,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>10</td><td>1</td><td></td><td>=VLOOKUP(AA40,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB40,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC40,$AD$29:$AG$31,4,0)</td><td>=IF(AA40+AB40+AC40>20,"×","")</td><td>=IF( COUNTIF(AA40:AC40,"2")>1,"×","")</td><td>=IF(AA40+AB40=2,"×",IF(AB40+AC40=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE40&AF40&AG40),D:D,1,0)=INT(AE40&AF40&AG40),"×",""),"")</td><td>=IF(AH40&AI40&AJ40&AK40="","〇","")</td><td>=IF(AL40="〇",AE40&AF40&AG40,"")</td></tr>
<tr>
<td>=IF(LEN(D41)<3,"0",MID(D41,LEN(D41)-2,1))</td><td>=IF(LEN(D41)<2,"0",MID(D41,LEN(D41)-1,1))</td><td>=MID(D41,LEN(D41),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>10</td><td>2</td><td></td><td>=VLOOKUP(AA41,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB41,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC41,$AD$29:$AG$31,4,0)</td><td>=IF(AA41+AB41+AC41>20,"×","")</td><td>=IF( COUNTIF(AA41:AC41,"2")>1,"×","")</td><td>=IF(AA41+AB41=2,"×",IF(AB41+AC41=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE41&AF41&AG41),D:D,1,0)=INT(AE41&AF41&AG41),"×",""),"")</td><td>=IF(AH41&AI41&AJ41&AK41="","〇","")</td><td>=IF(AL41="〇",AE41&AF41&AG41,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>1</td><td>10</td><td>10</td><td></td><td>=VLOOKUP(AA42,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB42,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC42,$AD$29:$AG$31,4,0)</td><td>=IF(AA42+AB42+AC42>20,"×","")</td><td>=IF( COUNTIF(AA42:AC42,"2")>1,"×","")</td><td>=IF(AA42+AB42=2,"×",IF(AB42+AC42=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE42&AF42&AG42),D:D,1,0)=INT(AE42&AF42&AG42),"×",""),"")</td><td>=IF(AH42&AI42&AJ42&AK42="","〇","")</td><td>=IF(AL42="〇",AE42&AF42&AG42,"")</td></tr>
<tr>
<td>=IF(LEN(D43)<3,"0",MID(D43,LEN(D43)-2,1))</td><td>=IF(LEN(D43)<2,"0",MID(D43,LEN(D43)-1,1))</td><td>=MID(D43,LEN(D43),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>1</td><td>1</td><td></td><td>=VLOOKUP(AA43,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB43,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC43,$AD$29:$AG$31,4,0)</td><td>=IF(AA43+AB43+AC43>20,"×","")</td><td>=IF( COUNTIF(AA43:AC43,"2")>1,"×","")</td><td>=IF(AA43+AB43=2,"×",IF(AB43+AC43=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE43&AF43&AG43),D:D,1,0)=INT(AE43&AF43&AG43),"×",""),"")</td><td>=IF(AH43&AI43&AJ43&AK43="","〇","")</td><td>=IF(AL43="〇",AE43&AF43&AG43,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>1</td><td>2</td><td></td><td>=VLOOKUP(AA44,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB44,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC44,$AD$29:$AG$31,4,0)</td><td>=IF(AA44+AB44+AC44>20,"×","")</td><td>=IF( COUNTIF(AA44:AC44,"2")>1,"×","")</td><td>=IF(AA44+AB44=2,"×",IF(AB44+AC44=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE44&AF44&AG44),D:D,1,0)=INT(AE44&AF44&AG44),"×",""),"")</td><td>=IF(AH44&AI44&AJ44&AK44="","〇","")</td><td>=IF(AL44="〇",AE44&AF44&AG44,"")</td></tr>
<tr>
<td>=IF(LEN(D45)<3,"0",MID(D45,LEN(D45)-2,1))</td><td>=IF(LEN(D45)<2,"0",MID(D45,LEN(D45)-1,1))</td><td>=MID(D45,LEN(D45),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>1</td><td>10</td><td></td><td>=VLOOKUP(AA45,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB45,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC45,$AD$29:$AG$31,4,0)</td><td>=IF(AA45+AB45+AC45>20,"×","")</td><td>=IF( COUNTIF(AA45:AC45,"2")>1,"×","")</td><td>=IF(AA45+AB45=2,"×",IF(AB45+AC45=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE45&AF45&AG45),D:D,1,0)=INT(AE45&AF45&AG45),"×",""),"")</td><td>=IF(AH45&AI45&AJ45&AK45="","〇","")</td><td>=IF(AL45="〇",AE45&AF45&AG45,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>2</td><td>1</td><td></td><td>=VLOOKUP(AA46,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB46,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC46,$AD$29:$AG$31,4,0)</td><td>=IF(AA46+AB46+AC46>20,"×","")</td><td>=IF( COUNTIF(AA46:AC46,"2")>1,"×","")</td><td>=IF(AA46+AB46=2,"×",IF(AB46+AC46=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE46&AF46&AG46),D:D,1,0)=INT(AE46&AF46&AG46),"×",""),"")</td><td>=IF(AH46&AI46&AJ46&AK46="","〇","")</td><td>=IF(AL46="〇",AE46&AF46&AG46,"")</td></tr>
<tr>
<td>=IF(LEN(D47)<3,"0",MID(D47,LEN(D47)-2,1))</td><td>=IF(LEN(D47)<2,"0",MID(D47,LEN(D47)-1,1))</td><td>=MID(D47,LEN(D47),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>2</td><td>2</td><td></td><td>=VLOOKUP(AA47,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB47,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC47,$AD$29:$AG$31,4,0)</td><td>=IF(AA47+AB47+AC47>20,"×","")</td><td>=IF( COUNTIF(AA47:AC47,"2")>1,"×","")</td><td>=IF(AA47+AB47=2,"×",IF(AB47+AC47=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE47&AF47&AG47),D:D,1,0)=INT(AE47&AF47&AG47),"×",""),"")</td><td>=IF(AH47&AI47&AJ47&AK47="","〇","")</td><td>=IF(AL47="〇",AE47&AF47&AG47,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>2</td><td>10</td><td></td><td>=VLOOKUP(AA48,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB48,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC48,$AD$29:$AG$31,4,0)</td><td>=IF(AA48+AB48+AC48>20,"×","")</td><td>=IF( COUNTIF(AA48:AC48,"2")>1,"×","")</td><td>=IF(AA48+AB48=2,"×",IF(AB48+AC48=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE48&AF48&AG48),D:D,1,0)=INT(AE48&AF48&AG48),"×",""),"")</td><td>=IF(AH48&AI48&AJ48&AK48="","〇","")</td><td>=IF(AL48="〇",AE48&AF48&AG48,"")</td></tr>
<tr>
<td>=IF(LEN(D49)<3,"0",MID(D49,LEN(D49)-2,1))</td><td>=IF(LEN(D49)<2,"0",MID(D49,LEN(D49)-1,1))</td><td>=MID(D49,LEN(D49),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>10</td><td>1</td><td></td><td>=VLOOKUP(AA49,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB49,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC49,$AD$29:$AG$31,4,0)</td><td>=IF(AA49+AB49+AC49>20,"×","")</td><td>=IF( COUNTIF(AA49:AC49,"2")>1,"×","")</td><td>=IF(AA49+AB49=2,"×",IF(AB49+AC49=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE49&AF49&AG49),D:D,1,0)=INT(AE49&AF49&AG49),"×",""),"")</td><td>=IF(AH49&AI49&AJ49&AK49="","〇","")</td><td>=IF(AL49="〇",AE49&AF49&AG49,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>10</td><td>2</td><td></td><td>=VLOOKUP(AA50,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB50,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC50,$AD$29:$AG$31,4,0)</td><td>=IF(AA50+AB50+AC50>20,"×","")</td><td>=IF( COUNTIF(AA50:AC50,"2")>1,"×","")</td><td>=IF(AA50+AB50=2,"×",IF(AB50+AC50=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE50&AF50&AG50),D:D,1,0)=INT(AE50&AF50&AG50),"×",""),"")</td><td>=IF(AH50&AI50&AJ50&AK50="","〇","")</td><td>=IF(AL50="〇",AE50&AF50&AG50,"")</td></tr>
<tr>
<td>=IF(LEN(D51)<3,"0",MID(D51,LEN(D51)-2,1))</td><td>=IF(LEN(D51)<2,"0",MID(D51,LEN(D51)-1,1))</td><td>=MID(D51,LEN(D51),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>2</td><td>10</td><td>10</td><td></td><td>=VLOOKUP(AA51,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB51,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC51,$AD$29:$AG$31,4,0)</td><td>=IF(AA51+AB51+AC51>20,"×","")</td><td>=IF( COUNTIF(AA51:AC51,"2")>1,"×","")</td><td>=IF(AA51+AB51=2,"×",IF(AB51+AC51=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE51&AF51&AG51),D:D,1,0)=INT(AE51&AF51&AG51),"×",""),"")</td><td>=IF(AH51&AI51&AJ51&AK51="","〇","")</td><td>=IF(AL51="〇",AE51&AF51&AG51,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>1</td><td>1</td><td></td><td>=VLOOKUP(AA52,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB52,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC52,$AD$29:$AG$31,4,0)</td><td>=IF(AA52+AB52+AC52>20,"×","")</td><td>=IF( COUNTIF(AA52:AC52,"2")>1,"×","")</td><td>=IF(AA52+AB52=2,"×",IF(AB52+AC52=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE52&AF52&AG52),D:D,1,0)=INT(AE52&AF52&AG52),"×",""),"")</td><td>=IF(AH52&AI52&AJ52&AK52="","〇","")</td><td>=IF(AL52="〇",AE52&AF52&AG52,"")</td></tr>
<tr>
<td>=IF(LEN(D53)<3,"0",MID(D53,LEN(D53)-2,1))</td><td>=IF(LEN(D53)<2,"0",MID(D53,LEN(D53)-1,1))</td><td>=MID(D53,LEN(D53),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>1</td><td>2</td><td></td><td>=VLOOKUP(AA53,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB53,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC53,$AD$29:$AG$31,4,0)</td><td>=IF(AA53+AB53+AC53>20,"×","")</td><td>=IF( COUNTIF(AA53:AC53,"2")>1,"×","")</td><td>=IF(AA53+AB53=2,"×",IF(AB53+AC53=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE53&AF53&AG53),D:D,1,0)=INT(AE53&AF53&AG53),"×",""),"")</td><td>=IF(AH53&AI53&AJ53&AK53="","〇","")</td><td>=IF(AL53="〇",AE53&AF53&AG53,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>1</td><td>10</td><td></td><td>=VLOOKUP(AA54,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB54,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC54,$AD$29:$AG$31,4,0)</td><td>=IF(AA54+AB54+AC54>20,"×","")</td><td>=IF( COUNTIF(AA54:AC54,"2")>1,"×","")</td><td>=IF(AA54+AB54=2,"×",IF(AB54+AC54=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE54&AF54&AG54),D:D,1,0)=INT(AE54&AF54&AG54),"×",""),"")</td><td>=IF(AH54&AI54&AJ54&AK54="","〇","")</td><td>=IF(AL54="〇",AE54&AF54&AG54,"")</td></tr>
<tr>
<td>=IF(LEN(D55)<3,"0",MID(D55,LEN(D55)-2,1))</td><td>=IF(LEN(D55)<2,"0",MID(D55,LEN(D55)-1,1))</td><td>=MID(D55,LEN(D55),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>2</td><td>1</td><td></td><td>=VLOOKUP(AA55,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB55,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC55,$AD$29:$AG$31,4,0)</td><td>=IF(AA55+AB55+AC55>20,"×","")</td><td>=IF( COUNTIF(AA55:AC55,"2")>1,"×","")</td><td>=IF(AA55+AB55=2,"×",IF(AB55+AC55=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE55&AF55&AG55),D:D,1,0)=INT(AE55&AF55&AG55),"×",""),"")</td><td>=IF(AH55&AI55&AJ55&AK55="","〇","")</td><td>=IF(AL55="〇",AE55&AF55&AG55,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>2</td><td>2</td><td></td><td>=VLOOKUP(AA56,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB56,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC56,$AD$29:$AG$31,4,0)</td><td>=IF(AA56+AB56+AC56>20,"×","")</td><td>=IF( COUNTIF(AA56:AC56,"2")>1,"×","")</td><td>=IF(AA56+AB56=2,"×",IF(AB56+AC56=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE56&AF56&AG56),D:D,1,0)=INT(AE56&AF56&AG56),"×",""),"")</td><td>=IF(AH56&AI56&AJ56&AK56="","〇","")</td><td>=IF(AL56="〇",AE56&AF56&AG56,"")</td></tr>
<tr>
<td>=IF(LEN(D57)<3,"0",MID(D57,LEN(D57)-2,1))</td><td>=IF(LEN(D57)<2,"0",MID(D57,LEN(D57)-1,1))</td><td>=MID(D57,LEN(D57),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>2</td><td>10</td><td></td><td>=VLOOKUP(AA57,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB57,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC57,$AD$29:$AG$31,4,0)</td><td>=IF(AA57+AB57+AC57>20,"×","")</td><td>=IF( COUNTIF(AA57:AC57,"2")>1,"×","")</td><td>=IF(AA57+AB57=2,"×",IF(AB57+AC57=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE57&AF57&AG57),D:D,1,0)=INT(AE57&AF57&AG57),"×",""),"")</td><td>=IF(AH57&AI57&AJ57&AK57="","〇","")</td><td>=IF(AL57="〇",AE57&AF57&AG57,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>10</td><td>1</td><td></td><td>=VLOOKUP(AA58,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB58,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC58,$AD$29:$AG$31,4,0)</td><td>=IF(AA58+AB58+AC58>20,"×","")</td><td>=IF( COUNTIF(AA58:AC58,"2")>1,"×","")</td><td>=IF(AA58+AB58=2,"×",IF(AB58+AC58=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE58&AF58&AG58),D:D,1,0)=INT(AE58&AF58&AG58),"×",""),"")</td><td>=IF(AH58&AI58&AJ58&AK58="","〇","")</td><td>=IF(AL58="〇",AE58&AF58&AG58,"")</td></tr>
<tr>
<td>=IF(LEN(D59)<3,"0",MID(D59,LEN(D59)-2,1))</td><td>=IF(LEN(D59)<2,"0",MID(D59,LEN(D59)-1,1))</td><td>=MID(D59,LEN(D59),1)</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>10</td><td>2</td><td></td><td>=VLOOKUP(AA59,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB59,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC59,$AD$29:$AG$31,4,0)</td><td>=IF(AA59+AB59+AC59>20,"×","")</td><td>=IF( COUNTIF(AA59:AC59,"2")>1,"×","")</td><td>=IF(AA59+AB59=2,"×",IF(AB59+AC59=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE59&AF59&AG59),D:D,1,0)=INT(AE59&AF59&AG59),"×",""),"")</td><td>=IF(AH59&AI59&AJ59&AK59="","〇","")</td><td>=IF(AL59="〇",AE59&AF59&AG59,"")</td></tr>
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>10</td><td>10</td><td>10</td><td></td><td>=VLOOKUP(AA60,$AD$29:$AE$31,2,0)</td><td>=VLOOKUP(AB60,$AD$29:$AF$31,3,0)</td><td>=VLOOKUP(AC60,$AD$29:$AG$31,4,0)</td><td>=IF(AA60+AB60+AC60>20,"×","")</td><td>=IF( COUNTIF(AA60:AC60,"2")>1,"×","")</td><td>=IF(AA60+AB60=2,"×",IF(AB60+AC60=2,"×",""))</td><td>=IFERROR(IF(VLOOKUP(INT(AE60&AF60&AG60),D:D,1,0)=INT(AE60&AF60&AG60),"×",""),"")</td><td>=IF(AH60&AI60&AJ60&AK60="","〇","")</td><td>=IF(AL60="〇",AE60&AF60&AG60,"")</td></tr>
</table>

いやいやそれもめんくさって方にはエクセル表があります
旧型式でダウンロード（.xls）　新形式でダウンロード（.xlsx）
右クリックで「対象を保存」してください

以上　ナンバーズ3の予想でした
100件程度のデータでは当たるとは思え、、ﾄﾞｶﾞｯ、、ｳｯｯ、、
当たっても外れても当方は一切関与いたしません

もし当たるようであればこの方法で
ナンバーズ4やミニlotoも作ってみたいと思います

LOTO7のツールはPHP版ですでに公開しています（まったく当たらない。）
お暇でしたらご覧ください
ロト7(LOTO7)購入支援ツール

TOP ＞正〇〇角形（正多角形）を表にしてみる

表計算や集計で使う関数