D
Duncan
Hi all,
a really picky question, why does the data validation allow a space
after the list value?
for instance, I have data validation to allow "yes" or "no" and I have
some other sumproducts looking to these cells to give me figures, but
it will allow you to put "yes " or "no " which the sumproduct wont pick
up with the blank space in.
can this be prevented? and why does it allow the blank space?
Duncan
a really picky question, why does the data validation allow a space
after the list value?
for instance, I have data validation to allow "yes" or "no" and I have
some other sumproducts looking to these cells to give me figures, but
it will allow you to put "yes " or "no " which the sumproduct wont pick
up with the blank space in.
can this be prevented? and why does it allow the blank space?
Duncan