B2{=IF(AND(IF(C$2:C$13=A2,D$2:D$13,VLOOKUP(A2,C:D,2,))=VLOOKUP(A2,C:D,2,)),VLOOKUP(A2,C:D,2,),"错误")
另解{=IF(SUM(N((C$2:C$13=A2)*D$2:D$13=VLOOKUP(A2,C:D,2,)))=COUNTIF(C:C,A2),VLOOKUP(A2,C:D,2,),"错误")
另解{=IF(SUM(IF($C$2:$C$13=A2,1/COUNTIFS($C$2:$C$13,A2,$D$2:$D$13,$D$2:$D$13),0))=1,VLOOKUP(A2,C:D,2,),"错误")
另解{=IF(SUM(N(IF(C$2:C$13=A2,D$2:D$13)=VLOOKUP(A2,C:D,2,)))=COUNTIF(C:C,A2),VLOOKUP(A2,C:D,2,),"错误")
另解{=iferror(MODE(QUARTILE(IF(C$2:C$13=A2,D$2:D$13),{0,4})),"错误")
留言
張貼留言