判斷老師有否跨年級 (13218)

F2 同老師同班級需相聚=REPT(1,VLOOKUP(E2,B:C,2,)<>LOOKUP(1,0/(B:B=E2),C:C))

均可 另解{=REPT(1,SUM((B$2:B$21=E2)/COUNTIFS(B:B,B$2:B$21,C:C,C$2:C$21))>1)

均可 另解=IF(COUNTIF(B:B,E2)<>COUNTIFS(B:B,E2,C:C,VLOOKUP(E2,B:C,2,)),1,"")