| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list with non blanks from different column
I have a spreadsheet containing a worksheet (Applications) that has a
reference number E1,E2,E3 etc in column A in cells A3:A102. Cells C3:1C102 will contain a name but may not. I want to create a Validation ldrop down list on another worksheet (Menu) that only contains the reference number A3:A102 if there is a value in the cell C3:C102. Is there anyway of doing this? At the moment my validation list contains blanks, as i have put an if formula in the A3:A103 range to put blank if the C3:C102 cell is blank. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List with blanks | Excel Discussion (Misc queries) | |||
| Blanks Data Validation List | Excel Discussion (Misc queries) | |||
| Validation list with blanks at the bottom | Excel Discussion (Misc queries) | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| validation list blanks | Excel Worksheet Functions | |||
Threaded Mode
