主题：考场安排：这个座位公式错在哪里？

在“学生成绩表中”的“座号”列的公式，怎么写，我的意图是：把“考场安排”中相应的学生姓名，对应到“学生成绩表”中“座号”列中，并在“座号”列中填入这个学生应该在“哪场哪列”，现在这个公式不对，不知错在哪里了，请版主改一下。egd文件下载


-=-=-=- 以下内容由 hbfnmxb 在 2009年11月20日 05:19pm 时添加 -=-=-=-
“哪场哪列哪行”

if(FindRow("考场安排","第一列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第一列_姓名","=",[姓名])+" 第1列 "+FindText("考场安排","行号","第一列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第二列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第二列_姓名","=",[姓名])+" 第2列 "+FindText("考场安排","行号","第二列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第三列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第三列_姓名","=",[姓名])+" 第3列 "+FindText("考场安排","行号","第三列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第四列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第四列_姓名","=",[姓名])+" 第4列 "+FindText("考场安排","行号","第四列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第五列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第五列_姓名","=",[姓名])+" 第5列 "+FindText("考场安排","行号","第五列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第六列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第六列_姓名","=",[姓名])+" 第6列 "+FindText("考场安排","行号","第六列_姓名","=",[姓名]),"")+
if(FindRow("考场安排","第七列_姓名","=",[姓名])>0,FindText("考场安排","考场号","第七列_姓名","=",[姓名])+" 第7列 "+FindText("考场安排","行号","第七列_姓名","=",[姓名]),"")

写成功了

但是重名的就有点麻烦了,1班有一个叫"周杉"的在第六场,16班也有一个叫"周杉"的,在18场,后面的"座号显示了他们所在的两场的声号,怎样解决这个重名的问题,请CZy版再看看,谢谢!!

我的思路：在现在的基础上能不能再加上一个对“班级”的判断，如果可以，怎样写这个公式。

我试试

-=-=-=- 以下内容由 hbfnmxb 在 2009年11月23日 10:45am 时添加 -=-=-=-
if(FindRow("考场安排","第一列_姓名","=",[姓名],"第一列_班级","=",[班级])>0,FindText("考场安排","考场号","第一列_姓名","=",[姓名],"第一列_班级","=",[班级])+" 第1列 "+FindText("考场安排","行号","第一列_姓名","=",[姓名],"第一列_班级","=",[班级]),"")+
if(FindRow("考场安排","第二列_姓名","=",[姓名],"第二列_班级","=",[班级])>0,FindText("考场安排","考场号","第二列_姓名","=",[姓名],"第二列_班级","=",[班级])+" 第2列 "+FindText("考场安排","行号","第二列_姓名","=",[姓名],"第二列_班级","=",[班级]),"")+
if(FindRow("考场安排","第三列_姓名","=",[姓名],"第三列_班级","=",[班级])>0,FindText("考场安排","考场号","第三列_姓名","=",[姓名],"第三列_班级","=",[班级])+" 第3列 "+FindText("考场安排","行号","第三列_姓名","=",[姓名],"第三列_班级","=",[班级]),"")+
if(FindRow("考场安排","第四列_姓名","=",[姓名],"第四列_班级","=",[班级])>0,FindText("考场安排","考场号","第四列_姓名","=",[姓名],"第四列_班级","=",[班级])+" 第4列 "+FindText("考场安排","行号","第四列_姓名","=",[姓名],"第四列_班级","=",[班级]),"")+
if(FindRow("考场安排","第五列_姓名","=",[姓名],"第五列_班级","=",[班级])>0,FindText("考场安排","考场号","第五列_姓名","=",[姓名],"第五列_班级","=",[班级])+" 第5列 "+FindText("考场安排","行号","第五列_姓名","=",[姓名],"第五列_班级","=",[班级]),"")+
if(FindRow("考场安排","第六列_姓名","=",[姓名],"第六列_班级","=",[班级])>0,FindText("考场安排","考场号","第六列_姓名","=",[姓名],"第六列_班级","=",[班级])+" 第6列 "+FindText("考场安排","行号","第六列_姓名","=",[姓名],"第六列_班级","=",[班级]),"")+
if(FindRow("考场安排","第七列_姓名","=",[姓名],"第七列_班级","=",[班级])>0,FindText("考场安排","考场号","第七列_姓名","=",[姓名],"第七列_班级","=",[班级])+" 第7列 "+FindText("考场安排","行号","第七列_姓名","=",[姓名],"第七列_班级","=",[班级]),"")

成功，谢谢！！