| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create conditional "List of Values" in Excell?
I have a set of data with two columns. The data can repeat itself in both
columns. Ex: A 1 A 2 A 3 B 3 B 4 B 5 I want to have the second column(1,2,3,4,5) as the source for a drop down list but I want to be able to limit the values by the data on the first column. Ex. I choose A and the list of possible values should be 1,2 and 3 whereas when I choose B the possible values should be 3, 4 and 5. Your advise is very much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create a short cut on my desktop for a excell file? | Excel Discussion (Misc queries) | |||
| How do i Use Excell to create a stem and leaf diargram? | Excel Discussion (Misc queries) | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| How do I create a daily spending spreadsheet in Excell? | Excel Worksheet Functions | |||
| how do I create a drop down menu in Excell? | Excel Worksheet Functions | |||
Threaded Mode
