| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about validation lists
The reason for using such a formula is that the range contains values that
are the result of a formula. No blanks occur until the end of the list, however any empty cells thereafter will contain a formula. "Jim Thomlinson" wrote: What is your reason for using COUNTIF(Sheet3!$F:$F,"?*") instead of COUNTA(Sheet3!$F:$F) In column F do you have any cell that just conatin blank characters / empty spaces... -- HTH... Jim Thomlinson "Gotroots" wrote: 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,"?*") ) |
| Reply |
| 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 | |||
Hybrid Mode
