Hi
i would create a separate list. e.g. enter the following in B1
=OFFSET($A$1,(ROW()-1)*2,0)
and copy this down
Now use column B as source for your data validation list
--
Regards
Frank Kabel
Frankfurt, Germany
"AndrewB" schrieb im Newsbeitrag
...
how to I limit the data in a drop down list?
ie.
column A has a list of site names, interspersed with month names.
eg. a1 = "Agnew Bros", a2= "Jan", a3="Feb",a4= "Opunake", etc
I've been using a data validation list to pick from, but get all the
month
names listed in the pick list.
How do list only the site names in the pick list?
|