Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a large mailing (23,000 pieces) and I have to know how many people I
am mailing to in a particular post code zone. For example I have postcodes with a prefix ranging from 2 to 4 characters followed by a further 3 characters (a standard UK postal format) L1 6TY L14 8GR CH42 7TR I need to count the number of occurrences of L1 (remembering that L14 also may get counted which should not happen), Then I would need a count for all L14 and CH42 and all the other Post codes. can anyone please help thank you in advance Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
M25 postcode | Excel Worksheet Functions | |||
Postcode Sort? | Excel Discussion (Misc queries) | |||
postcode | Excel Discussion (Misc queries) | |||
UK Postcode formula | Excel Worksheet Functions | |||
Sorting by PostCode | Excel Discussion (Misc queries) |