唯一數據 二種方式提取 (12378)

J2{=IFERROR(INDIRECT(TEXT(SMALL(IF((COUNTIF(J$1:J1,B$2:F11)=0)*(B$2:F11<>""),ROW($2:11)/1%+COLUMN(B:F)),1),"!r0c00"),),"")

K2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF((COUNTIF(K$1:K1,B$2:F11)=0)*(B$2:F11<>""),ROW($2:11)/1%+COLUMN(B:F)*10001),1),4),"!r0c00"),),"")