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
|