Hi folks,
I have a list of numbers in a single column and I want to know how many of each number is in the list. I have a list of numbers ranging from 1-200
Example
Time Data
0.........5
1.........2
2.........4
3.........2
4.........6
5.........5
6.........5
I need a function that will calculate the quantity of each number in the 'Data' column.
Output would be something like
Number Quantity
0.................0
1.................0
2.................2
3.................0
4.................1
5.................3
6.................1
If you have any ideas I would much appreciate them
Thanks
Bookmarks