display and count the number of times a value appears
Nel post
*dbath* ha scritto:
I am trying to count the number of times each zip code appears in an
address list and have it display each zip code with the count beside
it
ie
11456 6
20457 5
74653 12
Use the COUNTIF function:
if your zip codes are in column A starting from A2, in B2 put:
=COUNTIF(A:A;A2)
then copy down
--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|