| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
blanks in data validation list dropdown
Hi,
I am uing data validation on cell A1 and choosing to allow from a list. In the source box, I am clicking on column L (source =$L:$L). I have selected the 'ignore blank' checkbox. column L has 13 names. If there is something in columns A, B, C....etc in rows 14 or greater then the dropdown list in cell A1 shows blanks along with the names from column L. does anyone know how I stop this happening? Thanks for any help you cangive |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - using a list from another workbook | Excel Discussion (Misc queries) | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| size of data validation dropdown list | Excel Worksheet Functions | |||
| Data Validation - ignore blanks | Excel Discussion (Misc queries) | |||
| Data Validation List Length | Excel Worksheet Functions | |||
Threaded Mode
