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)),""""")+""""","""""""")"")"))
|