多组数据合并成一列 (10737)


J2:L12{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF((J$1=$B$1:$H$1)*($B$2:$H$6>0),ROW($2:$6)/1%+COLUMN($B:$H)*10001),ROW(A1)),4),"!r0c00"),),"")


留言