请高手帮忙:座位设置公式问题。有急用!! Post By:2006/8/12 9:43:00 [只看该作者]
我想把相同职位、相同报考单位排到相同(相近)的教室,其准考证号码的公式怎么设计?我设计了一个公式:evalfor(GridName,"座位号","rand(rows)") and sortcol(GridName,"座位号",1) and sortcol(GridName,"职位",1) And evalfor(GridName,"座位号","Row") and sortcol(GridName,"考场号",1) And RecalcCol(grid,"考场号","准考证号码")但没有达到目的。请帮忙检查原因。谢谢!egd文件下载 Excel:RAR文件下载