Posted to microsoft.public.excel.worksheet.functions

Adam

external usenet poster

Posts: 287

Post Code

I have a column that contains lots of post codes.

E.g

EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW

I'd like to count how many post codes I have that contain "EH48" in the
cell. Could someone tell me how I do this?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Post code lookup	Paul Williams	Excel Worksheet Functions	5	November 23rd 06 08:25 PM
post code & suburb concatenate	varun	Excel Discussion (Misc queries)	3	December 14th 05 09:18 AM
Post Code search	Porirua	New Users to Excel	6	June 23rd 05 12:27 AM
Post code & Suburbs	varun	Excel Discussion (Misc queries)	1	June 2nd 05 04:21 AM
Code Post: Extract Trendline coefficients	who	Excel Discussion (Misc queries)	2	January 10th 05 11:36 PM

All times are GMT +1. The time now is 01:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us