先上下 F2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(A$2:D$99<>"",{1,2,3,4}*10001+ROW($2:$99)/1%),ROW(A1)),4),"!R0C00"),),"")
先左右 G2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(A$2:D$99<>"",{1,2,3,4}+ROW($2:$99)/1%),ROW(A1)),4),"!R0C00"),),"")
另解F2=INDEX((A$2:A$9,D$2:D$9),IF(ROW(A1)>COUNTA(A$2:A$9),ROW(A1)-COUNTA(A$2:A$9),ROW(A1)),,1+(ROW(A1)>COUNTA(A$2:A$9)))&""
另解F2=INDEX(A$2:B$9,IF(ROW(A1)>COUNTA(A$2:A$9),ROW(A1)-COUNTA(A$2:A$9),ROW(A1)),1+(ROW(A1)>COUNTA(A$2:A$9)))&""
留言
張貼留言