[算表] VBA 資料選取
軟體:excel
版本:2013
目前工作常遇到要將一個矩陣資料做列選取或是行選取
EX: 1表選取 0表不選
情況一 列選取
A B C D E ....
1 11 12 13 14 15 1
2 21 22 23 24 25 0
3 31 32 33 34 35 1
4 41 42 43 44 45 1
.
.
.
輸出
A B C D E ....
1 12 13 14 15 16
2 31 32 33 34 35
3 41 42 43 44 45
.
.
情況二 行選取
A B C D E ....
1 11 12 13 14 15
2 21 22 23 24 25
3 31 32 33 34 35
4 41 42 43 44 45
.
.
. 1 0 1 0 1
輸出
A B C D E ....
1 11 13 15
2 21 23 25
3 31 33 35
4 41 43 45
.
.
.
類似這樣，用函數或是程序都可以
感謝各位高手!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.160.70.233
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1490588836.A.561.html
→
03/27 12:31, , 1F
03/27 12:31, 1F
→
03/27 12:33, , 2F
03/27 12:33, 2F
→
03/27 12:34, , 3F
03/27 12:34, 3F
→
03/27 12:38, , 4F
03/27 12:38, 4F
→
03/27 12:44, , 5F
03/27 12:44, 5F
→
03/27 12:44, , 6F
03/27 12:44, 6F
→
03/27 12:58, , 7F
03/27 12:58, 7F
→
03/27 23:30, , 8F
03/27 23:30, 8F
→
03/27 23:30, , 9F
03/27 23:30, 9F
→
03/27 23:31, , 10F
03/27 23:31, 10F
→
03/27 23:33, , 11F
03/27 23:33, 11F
→
03/27 23:53, , 12F
03/27 23:53, 12F
→
03/27 23:54, , 13F
03/27 23:54, 13F
→
03/28 00:43, , 14F
03/28 00:43, 14F
→
03/28 16:21, , 15F
03/28 16:21, 15F
→
03/28 16:22, , 16F
03/28 16:22, 16F
→
03/28 16:23, , 17F
03/28 16:23, 17F
→
03/28 16:32, , 18F
03/28 16:32, 18F
→
03/28 16:38, , 19F
03/28 16:38, 19F
→
03/28 16:39, , 20F
03/28 16:39, 20F
→
03/28 22:15, , 21F
03/28 22:15, 21F
→
03/28 22:16, , 22F
03/28 22:16, 22F
→
03/28 22:17, , 23F
03/28 22:17, 23F
→
03/28 22:17, , 24F
03/28 22:17, 24F
→
03/29 02:04, , 25F
03/29 02:04, 25F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
