[算表] 日期次數統計問題
軟體: Microsoft office
版本: 2003
sheet1
A
1 1/3
2 1/4
3 1/8
4 1/8
5 1/8
6 2/2
7 2/10
6 2/11
7 7/12
sheet2
1月 2月 3月 4月 5月 6月 7月 ....
日期出現次數 3 3 0 0 0 0 1
--------
請教版友
如果要統計各月日期次數,但是不能重複日期,
例如:1月有3筆,2月有3筆,這樣該如何下手呢?
感謝。
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 111.253.20.220
→
01/14 18:53, , 1F
01/14 18:53, 1F
→
01/14 19:59, , 2F
01/14 19:59, 2F
→
01/14 22:27, , 3F
01/14 22:27, 3F
※ 編輯: nfuman 來自: 111.253.20.220 (01/14 22:29)
→
01/14 22:35, , 4F
01/14 22:35, 4F
→
01/14 22:40, , 5F
01/14 22:40, 5F
→
01/14 22:40, , 6F
01/14 22:40, 6F
→
01/14 22:42, , 7F
01/14 22:42, 7F
→
01/14 22:45, , 8F
01/14 22:45, 8F
→
01/14 22:53, , 9F
01/14 22:53, 9F
→
01/14 22:58, , 10F
01/14 22:58, 10F
→
01/14 23:03, , 11F
01/14 23:03, 11F
→
01/14 23:04, , 12F
01/14 23:04, 12F
→
01/14 23:09, , 13F
01/14 23:09, 13F
→
01/14 23:09, , 14F
01/14 23:09, 14F
→
01/14 23:10, , 15F
01/14 23:10, 15F
→
01/14 23:11, , 16F
01/14 23:11, 16F
→
01/14 23:15, , 17F
01/14 23:15, 17F
→
01/14 23:18, , 18F
01/14 23:18, 18F
→
01/14 23:18, , 19F
01/14 23:18, 19F
→
01/14 23:28, , 20F
01/14 23:28, 20F
→
01/14 23:31, , 21F
01/14 23:31, 21F
→
01/14 23:35, , 22F
01/14 23:35, 22F
→
01/14 23:52, , 23F
01/14 23:52, 23F
→
01/15 00:01, , 24F
01/15 00:01, 24F
→
01/15 00:03, , 25F
01/15 00:03, 25F
→
01/15 00:04, , 26F
01/15 00:04, 26F
→
01/15 00:10, , 27F
01/15 00:10, 27F
→
01/15 00:11, , 28F
01/15 00:11, 28F
→
01/15 00:11, , 29F
01/15 00:11, 29F
→
01/15 00:12, , 30F
01/15 00:12, 30F
→
01/15 00:16, , 31F
01/15 00:16, 31F