View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jerry Jerry is offline
external usenet poster
 
Posts: 142
Default counting values in a column

I have a column with values ranging from 1 to 85. I need to count
occurrences of the values and put them in another spreadsheet. For instance
column c has the values 1,4,25,2,35,65,1,35,70,25,25 and I want to put in the
other spreadsheet the values as Column A Column B
1 2
2 1
4 1
25 3
35 2
65 1
70 1
Your assistance is greatly appreciated.