[算表] 計算扣除重複項目的數量
軟體:Excel
版本:2003
A1到A10為貨品名甲甲乙乙乙丙丁戊己庚
要怎麼用函數計算出幾項幾件(6項10件)
首先我用COUNTA(A1:A10)可以算出有10件
請問我該如何算出有幾項呢?
感謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.223.103.244
→
12/22 01:19, , 1F
12/22 01:19, 1F
→
12/22 01:21, , 2F
12/22 01:21, 2F
→
12/22 01:22, , 3F
12/22 01:22, 3F
→
12/22 20:13, , 4F
12/22 20:13, 4F
推
12/22 20:35, , 5F
12/22 20:35, 5F
→
12/28 21:32, , 6F
12/28 21:32, 6F