EXCEL中有兩欄三列:
A B C
1 407 278
2 516 921
3 319 718
如何在C欄排序成 :
1 407
2 278
3 516
4 921
5 319
6 718
各位大大感謝回答~
如何在EXCEL中排序(進階)
2013-04-22 1:52 am
回答 (2)
2013-04-25 1:50 am
✔ 最佳答案
ABC1407278407251691227833197185164 9125 3196 718 C1 =INDIRECT(ADDRESS(ROUNDUP(ROW()/2,0),IF(MOD(ROW(),2)=1,1,2),4)) 然後下拉, ok
2013-05-07 09:37:25 補充：
多謝漢鐘離兄指教。公式收藏了
2013-04-29 7:36 am
BB正解, 稍瘦身:
=INDIRECT(ADDRESS(INT(ROW(A2)/2),MOD(ROW(A2),2)+1,4))
其他思路, 僅供參考:
=INDIRECT(TEXT(INT((ROW(A2))/2)/1%+MOD(ROW(A2),2)+1,"\R0C00"),0)
=SUMPRODUCT((ROW(A$1:B$3)*2+COLUMN(A$1:B$3)=ROW(A3))*A$1:B$3)
2013-04-28 23:40:58 補充：
符號"＼" 被Yahoo吃掉, 改正:
=INDIRECT(TEXT(INT((ROW(A2))/2)/1%+MOD(ROW(A2),2)+1,"＼R0C00"),0)
=INDIRECT(ADDRESS(INT(ROW(A2)/2),MOD(ROW(A2),2)+1,4))
其他思路, 僅供參考:
=INDIRECT(TEXT(INT((ROW(A2))/2)/1%+MOD(ROW(A2),2)+1,"\R0C00"),0)
=SUMPRODUCT((ROW(A$1:B$3)*2+COLUMN(A$1:B$3)=ROW(A3))*A$1:B$3)
2013-04-28 23:40:58 補充：
符號"＼" 被Yahoo吃掉, 改正:
=INDIRECT(TEXT(INT((ROW(A2))/2)/1%+MOD(ROW(A2),2)+1,"＼R0C00"),0)
收錄日期: 2021-04-21 15:09:49
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20130421000051KK00265