Validation list

E

EH003268

I have 2 cells with drop down list in validation cells (VC) . I want the
first (VC) to have a default value of the second from bottom value from
it'slist, and the second (VC) to have a default of the last value from
it's list. Is it possible?
Thanks
 
M

mangesh_yadav

I guess you could simply choose the respective values and save th
file.

Manges
 
M

Mangesh Yadav

One way ofcourse, is to use 2 queries, one for the list and the other to get
only one value which you want to set as default.

Mangesh
 
Top