Posted to microsoft.public.excel.worksheet.functions
|
|
List
See
http://contextures.com/xlDataVal03.html
In article ,
LaDdIe wrote:
Respected members,
I.E. I wish to create a a validation list in A1, A2 & A3, the source data is
held in
cells A10:A12 as follows
"Hello"
"Goodbye"
"No thanks"
If "hello" is selected from the drop down list in A1, then the drop down for
A2 & A3 should only show options "Goodbye" and "No thanks", in other words
the lists should only show values that have'nt been used elsewhere in A1:A3.
Any idea's?
|