Drop Down Lists
Hi,
It is:
Allow: List
Source: = $A$1:$A$10
Thanks,
"Toppers" wrote:
What is your formula?
DV should be:
Allow: List
Source: = A1:A10
Or
Source: =MyList where MyList is a named range
"sam" wrote:
Hi
I'm trying to create a dropdown list using the data validate keys. The
reference data is in the same worksheet, and the formula begins with an =.
However I get nothing once I've created this. Any suggestions?
Thanks in advance (again) for your help
|