出現唯一值 提出 (10766)

F2=IFERROR(RIGHT(SMALL(IF(COUNTIF(B:D,B$2:D$9)=1,ROW(2:9)/1%%+{1,2,3}/1%+B$2:D$9),ROW(A1)),2)*1,"")

格式化 B2:D9=COUNTIF($B:$D,B2)=1

另解=IFERROR(INDIRECT(TEXT(SMALL(IF(COUNTIF(B:D,B$2:D$9)=1,ROW($2:$9)/1%+{2,3,4}),ROW(A1)),"!R0C00"),),"")