Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Thanks for the feedback although it doesn't completely work as my list
with the values for the drop down is linked to another spreadsheet, so values from say F51 to F60 are zeros. These zeros appear in the drop down list as well and even when I alter the formula to hide zero values, the drop down list shows them a blank options in the drop down list. I am using Excel 97 by the way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |