View Single Post
  #1   Report Post  
DDF
 
Posts: n/a
Default What is the correct function to use, please?

I need to get the number of times each of these appear.

77777
77777
77778
77778
77778
77779

So for 77777 I would want it to display 2, and for 77778 I would want to get
a 3, for 77779 a 1, and etc. Unfortunately the list of zip codes is several
thousand long so I cannot do a COUNT function for each individual zip code (I
want excel to do it all for me). Any suggestions?