往上3个不同的数值比对 (9479)

C5{=1-OR(A5=OFFSET(A4,,,MAX(LARGE(IF(COUNTIF(OFFSET(A$1,,,ROW($1:4)),A$1:A4)=COUNTIF(A$1:A4,A$1:A4),ROW($1:4)),3)-ROW())))

D5{=ISNA(MATCH(A5,OFFSET(A4,,,LARGE(IF(COUNTIF(OFFSET(A$1,,,ROW($1:4)),A$1:A4)=COUNTIF(A$1:A4,A$1:A4),ROW($1:4)),3)-ROW()),))*1