J4:K4下拉{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(($B$3:$F$3=$B$3)*($B$4:$F$999>0),$B$4:$F$999*10^8+ROW($4:$999)/1%+COLUMN(B:F)),ROW(A1)),4),"!R0C00"),),"")
L4下拉{=IF(J4="","",IFERROR(INDEX(D:D,SMALL(IF((B$4:B$999=J4)*(C$4:C$999=K4),ROW($4:$999)),COUNTIFS(J$4:J4,J4,K$4:K4,K4))),""))
M4下拉{=IF((J4="")+(L4<>""),"",IFERROR(INDEX(H:H,SMALL(IF((F$4:F$999=J4)*(G$4:G$999=K4),ROW($4:$999)),COUNTIFS(J$4:J4,J4,K$4:K4,K4,L$4:L4,""))),""))
留言
張貼留言