| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks Data Validation List
Cells A1:A10 show a result from a formula. A5 is containing no formula and A8
reflects "" as a formula result. Now when I select the range A1:A10 in DataValidationList source being A1:A10 I want only the results which are neither Blank nor "" but the drop down list still reflects blank spaces of A5 & A8, although the "Ignore Blanks" have been checked. All expertise and guidance shall be obliged. Thanx in advance! -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation, select from list: omit blanks? | Excel Discussion (Misc queries) | |||
| Why is * valid if Excel data validation list has no blanks or *? | Excel Worksheet Functions | |||
| blanks in data validation list dropdown | Excel Worksheet Functions | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| validation list blanks | Excel Worksheet Functions | |||
Threaded Mode
