View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga
 
Posts: n/a
Default 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