| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation list question
Hi,
Is it possible to show only values in a validation list. The validation show blanks at the bottom of the list due to the values being the result of a formula. Can the name created which is used in the source field be altered perhaps? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation list question
If you dont have blank cells in between try the below in Data validation
ListSource =OFFSET($J$1,,,COUNTIF($J:$J,"?*")) -- Jacob "Gotroots" wrote: Hi, Is it possible to show only values in a validation list. The validation show blanks at the bottom of the list due to the values being the result of a formula. Can the name created which is used in the source field be altered perhaps? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation list question
Didn't think you could just enter a formula into the source field.
Learned something new today. Thanks Jacob "Jacob Skaria" wrote: If you dont have blank cells in between try the below in Data validation ListSource =OFFSET($J$1,,,COUNTIF($J:$J,"?*")) -- Jacob "Gotroots" wrote: Hi, Is it possible to show only values in a validation list. The validation show blanks at the bottom of the list due to the values being the result of a formula. Can the name created which is used in the source field be altered perhaps? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation list question
Cheers. Thanks for the feedback
-- Jacob "Gotroots" wrote: Didn't think you could just enter a formula into the source field. Learned something new today. Thanks Jacob "Jacob Skaria" wrote: If you dont have blank cells in between try the below in Data validation ListSource =OFFSET($J$1,,,COUNTIF($J:$J,"?*")) -- Jacob "Gotroots" wrote: Hi, Is it possible to show only values in a validation list. The validation show blanks at the bottom of the list due to the values being the result of a formula. Can the name created which is used in the source field be altered perhaps? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about range in validation list | Excel Discussion (Misc queries) | |||
| validation drop down list question | Excel Worksheet Functions | |||
| Validation List/Formula Question | Excel Discussion (Misc queries) | |||
| Data Validation List Question | Excel Discussion (Misc queries) | |||
| Data Validation-List..Question? | Excel Discussion (Misc queries) | |||
Hybrid Mode
