Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation, select from list: omit blanks?
I'm using <data - validation - allow "list". Which works fine, except
this particular list has blank cells interspersed within it. Is there a way to have the list ignore the blanks? TIA, George |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation, select from list: omit blanks?
You can create an equivalent list without the blanks.
Say the list is in column C from C1 thru C20. In B1 enter 1 In B2 enter: =IF(C2="",-1,1+MAX($B$1:B1)) and copy down In A1 enter: =VLOOKUP(LARGE(B:B,ROW()),B$1:C$20,2) and copy down Column A will have the same data as column C, but no blanks. Use column A -- Gary''s Student - gsnu200761 "George" wrote: I'm using <data - validation - allow "list". Which works fine, except this particular list has blank cells interspersed within it. Is there a way to have the list ignore the blanks? TIA, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Complete a select from a data validation list | 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 | |||
Using a 'Select' (Data Validation) List? | Excel Worksheet Functions | |||
Data Validation and Blanks in List | Excel Worksheet Functions |