Hi DDF,
You may want to use Advanced Filter (menu DataFilterAdvanced Filter) to
create a list of unique values and then the function COUNTIF().
Regards,
KL
"DDF" wrote in message
...
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?
|