主题：[求助]程序如何修改,才能解决以下两个问题

做了一段语言班级排名的公式，其它的自己参照做吧。

if(ListFor(Grid,"语文_成绩")="",true,Do(112) And FilterFor("月份", "=" ,[%月份2%]) And SortCol(GridName,"语文_成绩",2) And SortCol(GridName,"班",1) And SortCol(GridName,"月份",1) And evalfor(grid,"语文_班名","if(Row=1,1,if(cell(Row-1,""月份"")=[月份] And cell(Row-1,""班"")=[班] And cell(Row-1,""语文_成绩"")<>[语文_成绩],VisibleRow,if(cell(Row-1,""班"")<>[班],1,cell(row-1,""语文_班名""))))",1,Rows,1))

看自定义按钮：

egd文件下载

if(ListFor(Grid,"语文_成绩")="",true,Eval("FilterFor(""月份"",""="",[%月份2%],""班"",""="","""+Substitute([%班%],"|",""",2) And [%排名%] And FilterFor(""月份"",""="",[%月份2%],""班"",""="",""")+""",2) And [%排名%]") And FilterFor("月份","=",[%月份2%],2) And SortCol(Grid,"语文_成绩",2) And SortCol(Grid,"月份",1)And EvalFor(Grid,"语文_级名","if(VisibleRow=1,1,if([语文_成绩]=cell(row-1,""语文_成绩""),cell(row-1,""语文_级名""),VisibleRow))",1,Rows,1))

易有易的好处，难也有难的好处。
如果用简单易懂的CountFor进行排名，牺牲的是时间。
曾有一个例子，用CountFor排名在作者的电脑中用时80分种以上，而用Eval进行操作只不过三五十秒。
个人认为，初级用户循规蹈矩用简单易懂的公式应是最好的选择，中高级用户用用难懂易用的公式也无妨。