Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello. I have this small problem concerning the validation of the values the
users can enter in a table: the source list contains several cells than aren't usually filled wiith values, therefore the validation treats them as 0. They come as a formula with reference to another sheet, so that's why I believe the option "Skip blanks" does not work. The problem is some operations in my table involve the COUNTA formula, and everytime a user mistakenly enters 0 (from the drop down list created by the validation), this 0 value is counted and messes up my things there. How do I get rid of these 0 values? Thanks, Devlin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |