Hi
I have used the countA function in data validation in order that, from
a range of cells only one option can be slected using "x". If they try
to select more than one option an error meeasge is displayed. This works
fine, however I now need to use this same formula on a subsequent range
which contains empty string "". Obviously CountA counts this therefore
no option can be selected.
Is there a way for the formula to ignore ""?
The formula I have used in Data, Validation, Custom is:
=COUNTA(G$5:G$7)=1
Please help!
Many thanks
Laura;)
--
lauraroebuck
------------------------------------------------------------------------
lauraroebuck's Profile:
http://www.thecodecage.com/forumz/member.php?userid=289
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=122629