请教,在excelABC三列中有1,2,0三个数字顺序不定,答:=IF(OR(INDEX(A$1:A2,MAX(IF(A$1:A2=A2,0,ROW(A$1:A2)))=A3,A3=A2)*OR(INDEX(B$1:B2,MAX(IF(B$1:B2=B2,0,ROW(B$1:B2)))=B3,B3=B2)*OR(INDEX(C$1:C2,MAX(IF(C$1:C2=C2,0,ROW(C$1:C2)))=C3,C3=C2)*1=1,"z","g")数组公式,Ctrl+Shift+Enter三键结束 ...