Subtotal("报考单位,职位","总成绩","2") And EvalFor(Grid,"名次","if(row=firstrow,1,if([总成绩]=cell(Row-1,""总成绩""),cell(Row-1,""名次""),CountFor(Grid,""报考单位"",""="",[报考单位],""职位"",""="",[职位],1,row)))") And ClearSubtotal()