View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F[_2_] F[_2_] is offline
external usenet poster
 
Posts: 46
Default Counting (unknown at present) discrete values

I have a column that will hold postcodes from responses to a questionnaire.

I do not know which postcodes will appear in the list, but I would like
to count how many instances there are of each discrete postcode that
appears.

For example, the following are entered:
postcode1
postcode2
postcode1
postcode3
postcode2
postcode1

and I would want to the list translated into the form:
postcode1 - 3
postcode2 - 2
postcode3 - 1

Is there a (relatively) simple way to achieve this?

TIA

--
F