[算表] 出現次數統計
軟體:Excel
版本:2007
前輩好, 小弟遇到的問題如下:
{原始資料}
Subsystem Part Number Category Qty
AUDIO CH3100 C1 2
AUDIO CH3100 C1 5
AUDIO CH4103 C2 1
AUDIO CH4100 C2 2
欲輸出成:
Subsystem ID Category Type(共有幾種相異Part Number) Total(Qty加總)
AUDIO C1 1 7
AUDIO C2 2 3
小弟目前遇到的問題是, Total可以由SUMIFS求得, 但是Type因為有重覆而無法得知
正確結果
謝謝^^
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.62.83.222
→
11/09 23:28, , 1F
11/09 23:28, 1F
→
11/10 04:48, , 2F
11/10 04:48, 2F
→
11/10 04:49, , 3F
11/10 04:49, 3F
推
11/10 16:17, , 4F
11/10 16:17, 4F
→
11/10 16:18, , 5F
11/10 16:18, 5F
→
11/10 16:19, , 6F
11/10 16:19, 6F
→
11/10 16:19, , 7F
11/10 16:19, 7F
→
11/10 16:20, , 8F
11/10 16:20, 8F
→
11/11 01:46, , 9F
11/11 01:46, 9F
→
11/11 09:16, , 10F
11/11 09:16, 10F
→
11/11 09:17, , 11F
11/11 09:17, 11F
→
11/11 09:54, , 12F
11/11 09:54, 12F
→
11/11 22:10, , 13F
11/11 22:10, 13F
Office 近期熱門文章
PTT數位生活區 即時熱門文章