Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountA function - Data Validation
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
COUNTA Function | Excel Worksheet Functions | |||
Counta function | Excel Worksheet Functions | |||
Using the COUNTA function | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |