| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List
Thanks JE,
"JE McGimpsey" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Hybrid Mode
