Posted to microsoft.public.excel.misc

Ken

external usenet poster

Posts: 590

Dates & Text?

Excel2003 ... My Range contains "Date" values & various "Text" values ... I
wish a formula to count the "Text" values only.

01/01/09
01/02/09
H
01/04/09
V
01/06/09
01/07/09
01/08/09
O/S
01/10/09

Formula should return ... 3

Thanks ... Kha

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
How do I convert dates stored as dates to text?	diamunds	Excel Discussion (Misc queries)	5	September 7th 07 05:38 PM
Format text 'dates' to real dates	Jacy	Excel Worksheet Functions	4	July 24th 06 02:10 AM
dates and text	karene	Excel Discussion (Misc queries)	1	November 18th 05 04:21 PM
dates and text	Sloth	Excel Discussion (Misc queries)	0	November 18th 05 04:16 PM
Text with Dates	littlegreenmen1	Excel Discussion (Misc queries)	3	June 15th 05 05:13 PM

All times are GMT +1. The time now is 07:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us