Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting number of unknown numbers | Excel Worksheet Functions | |||
Counting an Unknown Range | Excel Discussion (Misc queries) | |||
How do I sum cells by refering to discrete values? | Excel Worksheet Functions | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Complete unknown values in series | Excel Discussion (Misc queries) |