[算表] 篩選後的資料想做順序編號
軟體: Excel
版本: 2007
請問各位高手
小弟目前遇到一個問題
就是我有幾千筆的資料
我先用篩選功能 把裡面一些名稱相同的列全部找出來
(Ex: AAA
AAA
AAA
...
AAA )
之後我想對這些篩選過後的列進行順序編號
如 : AAA_1
AAA_2
AAA_3
.....
請問需要怎麼樣操作??
如果直接用拉的
會全部都變成
AAA_1
AAA_1
AAA_1
.....
不知道有沒有人可以幫忙?
感激不盡!!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.225.45.116
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1448198533.A.F0A.html
→
11/22 22:36, , 1F
11/22 22:36, 1F
→
11/22 22:39, , 2F
11/22 22:39, 2F
→
11/23 00:12, , 3F
11/23 00:12, 3F
→
11/23 00:12, , 4F
11/23 00:12, 4F
→
11/23 00:22, , 5F
11/23 00:22, 5F
→
11/23 00:44, , 6F
11/23 00:44, 6F
→
11/23 00:44, , 7F
11/23 00:44, 7F
→
11/23 00:45, , 8F
11/23 00:45, 8F
→
11/23 00:45, , 9F
11/23 00:45, 9F
→
11/23 00:48, , 10F
11/23 00:48, 10F
→
11/23 00:48, , 11F
11/23 00:48, 11F
→
11/23 00:51, , 12F
11/23 00:51, 12F
→
11/23 00:52, , 13F
11/23 00:52, 13F
→
11/23 00:53, , 14F
11/23 00:53, 14F
→
11/23 00:53, , 15F
11/23 00:53, 15F
→
11/23 00:53, , 16F
11/23 00:53, 16F
→
11/23 00:57, , 17F
11/23 00:57, 17F
→
11/23 01:01, , 18F
11/23 01:01, 18F
→
11/23 01:02, , 19F
11/23 01:02, 19F
→
11/23 01:02, , 20F
11/23 01:02, 20F
→
11/23 01:04, , 21F
11/23 01:04, 21F
→
11/23 01:05, , 22F
11/23 01:05, 22F
→
11/23 01:05, , 23F
11/23 01:05, 23F
→
11/23 01:12, , 24F
11/23 01:12, 24F
→
11/23 01:14, , 25F
11/23 01:14, 25F
→
11/23 01:14, , 26F
11/23 01:14, 26F
→
11/23 01:18, , 27F
11/23 01:18, 27F
→
11/23 01:21, , 28F
11/23 01:21, 28F
→
11/23 01:22, , 29F
11/23 01:22, 29F
→
11/23 01:24, , 30F
11/23 01:24, 30F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
