| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blanks Data Validation List
Good suggestion
-- Gary''s Student - gsnu200773 "Max" wrote: GS, I don't think my suggestion is any neater Just some thoughts on your suggestion Instead of: .. In A1 enter 1 Suggest in A1: =IF(B1="","",1) (as the 1st source cell B1 may be blank) Then to .. Use column C as the validation list rather than column B the OP could use this expression as the dynamic range for his DV: =OFFSET(Sheet1!$C$1,,,SUMPRODUCT(--(Sheet1!$C$1:$C$10<""))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| 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
