主题：应如何计算？

egd文件下载
计算表中数据在10期和20期内已出现的数字中，出现的次数最多的三到四个数。请教应如何计算？请各位大师帮助。

10期公式试试？
Eval("Eval(""If(10-Len(Substitute(Text(Cell(Row-9+""+Substitute(""0|1|2|3|4|5|6|7|8|9"",""|"","",2)+Cell(Row-9+"")+"",2)),"""""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute("0|1|2|3|4|5|6|7|8|9","|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""""","""""""")) >= 3,"""" "),"|",""""","""""""")"")+Eval(""If(10-Len(Substitute(Text(Cell(Row-9+""+Substitute(""0|1|2|3|4|5|6|7|8|9"",""|"","",2)+Cell(Row-9+"")+"",2)),""""")+""""","""""""")"")")

-=-=-=- 以下内容由 wjq1072 在 2009年12月28日 04:06pm 时添加 -=-=-=-
20期公式试试？
If(Row < 20,"",Eval("Eval(""If(20-Len(Substitute(Text(Cell(Row-19+""+Substitute(""0|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19"",""|"","",2)+Cell(Row-19+"")+"",2)),"""""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute("0|1|2|3|4|5|6|7|8|9","|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""""","""""""")) >= 3,"""" "),"|",""""","""""""")"")+Eval(""If(20-Len(Substitute(Text(Cell(Row-19+""+Substitute(""0|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19"",""|"","",2)+Cell(Row-19+"")+"",2)),""""")+""""","""""""")"")"))

egd文件下载
大师我看了十期的统计，有点问题，我把最后十期做了一下，请你看看。我要的是这样的结果。

10期公式试试？
Eval("Eval(""If(10-Len(Substitute(Text(Cell(Row-9+""+Substitute(""0|1|2|3|4|5|6|7|8|9"",""|"","",2)+Cell(Row-9+"")+"",2)),"""""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute("0|1|2|3|4|5|6|7|8|9","|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""""","""""""")) >= 2,"""" "),"|",""""","""""""")"")+Eval(""If(10-Len(Substitute(Text(Cell(Row-9+""+Substitute(""0|1|2|3|4|5|6|7|8|9"",""|"","",2)+Cell(Row-9+"")+"",2)),""""")+""""","""""""")"")")

-=-=-=- 以下内容由 wjq1072 在 2009年12月28日 08:14pm 时添加 -=-=-=-
“出现的次数最多的三到四个数”

最多是多少？？？
三到四个数，三个还是四个？？

现在的统计就可以。谢谢大师。

20期公式试试？
If(Row < 20,"",Eval("Eval(""If(20-Len(Substitute(Text(Cell(Row-19+""+Substitute(""0|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19"",""|"","",2)+Cell(Row-19+"")+"",2)),"""""+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute("0|1|2|3|4|5|6|7|8|9","|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@",""""","""""""")) >= 3,"""" "),"|",""""","""""""")"")+Eval(""If(20-Len(Substitute(Text(Cell(Row-19+""+Substitute(""0|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19"",""|"","",2)+Cell(Row-19+"")+"",2)),""""")+""""","""""""")"")"))
大师,这个20期的公式还是没有理解,是针对的第几列数据使用,应如何调整?请你解释一下.谢谢.

不学习就是套用一下你都不可能会，你还可能理解吗？
劝你放弃吧！你真心要研究彩票的话，就从概率论学习起吧！
egd文件下载