H4:H18{=OFFSET(A$3,,SMALL(IF(MMULT(COLUMN(A:F)^0,(A$3:F$3<>B$3)*(A$4:F$9<>""))>=ROW($1:$9),COLUMN(A:F)-1,99),ROW(A1)))&""
I4:J18{=IFERROR(INDIRECT(TEXT(SMALL(IF(($A$4:$F$9<>"")*($A$3:$F$3=$H4),ROW($4:$9)/1%+COLUMN($A:$F)),COUNTIF($H$4:$H4,$H4))+COLUMN(A1)-1,"!R0C00"),),"")
留言
張貼留言