A3=IF(LARGE(IF(Sheet2!$A$2:$A$16=Sheet1!$B$1,ROUND(Sheet2!$D$2:$D$16,4)*1000000+ROW($A$2:$A$16),0),ROW(1:1))=0,"",INDEX(Sheet2!A:A,MOD(LARGE(IF(Sheet2!$A$2:$A$16=Sheet1!$B$1,ROUND(Sheet2!$D$2:$D$16,4)*1000000+ROW($A$2:$A$16),0),ROW(1:1)),1000))),数组公式,公式向右拉,向下拉 但请注意,你两个表中的1班是不相等的,一个不"1斑 ",一个是"1班"
[此贴子已经被作者于2010-3-30 20:03:05编辑过] |