是否合规671、根据“日期+学生号码”两列组合查询对应的最大值、最小值
372、判断考试成绩是否在最大和最小值之间,若是则显示成绩,否则空白4757最大值:在单元格I2输入公式
30.6=INDEX($D$2:$D$21,MATCH(F2&G2,$A$2:$A$21&$B$2:$B$21,))20.4最小值:在单元格J2输入公式
34
=INDEX($C$2:$C$21,MATCH(F2&G2,$A$2:$A$21&$B$2:$B$21,))是否合规:在单元格K2输入公式(无需过渡列)
336623803、输入公式后,按Ctrl+Shift+Enter结束
473524174835
=IF((H2>=INDEX($C$2:$C$21,MATCH(F2&G2,$A$2:$A$21&$B$2:$B$21,)))*(H2<=INDEX($D$2:$D$21,MATCH(F2&G2,$A$2:$A$21&$B$2:$B$21,))),H2,"")