View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Formula question

OK, here is the problem:
I have a worksheet, a very large worksheet that looks like this:

Column a
1
1
1
2
2
2
2
2
3
3
3

I need a formula that tells me how many ones, how many 2s, and how many 3s
are in the column. I have about 1 million numbers and need to apply the
formula to the entire column.

Thanks