View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Count the frequency for every change in numbers

Dear Expert,
Would like to count the frequency each time it shows up .
Below is the example ....

4 shows up 3 times ...
5 shows up 1 time
......... etc etc 7 shows up 3 times, 1 shows up 2 times at the bottom....
Is there any function that can capture this coutning on each movement?

Numbers Times
4
4
4 3
5 1
4
4 2
5
5 2
4
4
4 3
3 1
6
6
6 3
7
7
7 3
1
1 2