Posted to microsoft.public.excel.worksheet.functions

NBVC[_126_] NBVC[_126_] is offline

external usenet poster

Posts: 1

CountA function - Data Validation

Counta() doesn't count empty strings (nulls).. so should work as is.

If you mean blanks (as in space bar used in the cell) then try:

=COUNTA(G$5:G$7)-COUNTIF($G$5:$G$7," ")=1

--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122629

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
Excel Data Validation/Lookup function does function correcty	Kirkey	Excel Worksheet Functions	2	May 25th 09 09:22 PM
COUNTA Function	sgl	Excel Worksheet Functions	4	December 13th 08 04:01 PM
Counta function	Help	Excel Worksheet Functions	3	July 2nd 08 07:01 PM
Using the COUNTA function	JL1976	Excel Discussion (Misc queries)	1	October 26th 07 01:28 AM
COUNTA Function not working =COUNTA(C3:C69,"NH")	MikeinNH	Excel Worksheet Functions	2	November 8th 04 01:19 AM

All times are GMT +1. The time now is 05:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us