非空提取 且相同相聚 (12842)

H2{=IF(COUNTIF(A:F,H1)>COUNTIF(H$1:H1,H1),H1,INDIRECT(TEXT(MIN(IF((A$1:F$9<>"")*(COUNTIF(H$1:H1,A$1:F$9)=0),ROW($1:$9)/1%+COLUMN(A:F),9999)),"!R0C00"),))&""



留言