| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about validation lists
What causes the validation list to change the range to add one or more empty
cells to the end of the list. When playing round with the defined Name formula I notice it can change the range to include empty cells. Anyone got any thought on this? =OFFSET(Sheet3!$F$1,0,0,COUNTIF(Sheet3!$F:$F,"?*") ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation lists | Excel Worksheet Functions | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Validation lists | Excel Discussion (Misc queries) | |||
| lists and validation | Excel Worksheet Functions | |||
Threaded Mode
