excel有冇得GROUP數??

這是統計上常用的方法. 其實, excel 是有內建函數 frequency( ) 來處理的.
步驟如下:
1. 假設 你的 data 在 A1:A10
2. 在 B1:B4 輸入 5, 10, 15, 20.
3. Highlight C1:C4, 並輸入 =FREQUENCY(A1:A10, B1:B4)
然後按 ctrl+shift+enter (即 同時按下 ctrl 和 shift, 再按 enter)
4. C1:C4 就會出現 3, 4, 2, 1 了.

FREQUENCY 示範: https://www.youtube.com/watch?v=n24vDAcxNv4
希望幫到你

1-5 3個 =COUNTIF(A1:A10,">0")-COUNTIF(A1:A10,">5")
6-10 4個 =COUNTIF(A1:A10,">5")-COUNTIF(A1:A10,">10")
11-15 2個 =COUNTIF(A1:A10,">10")-COUNTIF(A1:A10,">15")
16-20 1個 =COUNTIF(A1:A10,">15")-COUNTIF(A1:A10,">20")