请教有关自动填充问题？ - 用户社区 - 易表在线答疑 - 简单实用的数据管理软件|数据统计软件|数据分析软件|电子表格软件

[这个贴子最后由wjq1072在 2010/12/24 00:15pm 第 2 次编辑]

下面引用由sdqz6173在 2010/12/24 10:57am 发表的内容：
首先谢谢大侠的帮助，这样完全达到了我的目的，但是我也想学学这个软件，使自己掌握更多一点知识，对里面公式很不了解，想了很久也没明白，像Eval("EvalFor(Grid,""下考序"","&qu ...

Eval("EvalFor(Grid,""下考序"",""If(Row=1,1,If([班名] <= "+Substitute(Substitute(ListFor("班统","p"),"/",",MaxFor(Grid,""""下考序"""",1,Row-1)+1,""""""""))"",""班级"",""="","""),"|",""") And EvalFor(Grid,""下考序"",""If(Row=1,1,If([班名] <= ")+""")")

以上公式实际上就是下面公式的一个简化的通用公式！（这样就解决了各班取名数和增减班级而不需要调整公式的问题）

EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 15,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","266") And
EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 20,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","267") And
EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 25,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","268") And
EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 30,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","269") And
EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 35,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","270") And
EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 40,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","271") And
EvalFor(Grid,"下考序","If(Row=1,1,If([班名] <= 45,MaxFor(Grid,""下考序"",1,Row-1)+1,""""))","班级","=","272")
----
----
这个需要能够灵活应用Evaj函数的技巧，你可以在论坛搜索有关Eval函数的贴子参考学习。

主题：请教有关自动填充问题？