Hi!
I have a dropdown list with a lot of items, however I want to hide some items it should not shown in the dropdown list, let's say all items that start with a "R" should be hidden, is it possible to do this?
Hi!
I have a dropdown list with a lot of items, however I want to hide some items it should not shown in the dropdown list, let's say all items that start with a "R" should be hidden, is it possible to do this?
All cells what you want it should not be in the dropdown, add the letter "z" to the beginning, and sort the column Ascending, so all with the "z" will be at the bottom, now add this formula in the define name,and then add the name in the data validation,and all cells that starts with a "z" will not appear in the dropdown
=OFFSET(Sheet1!$A$3,0,0,COUNTA($A$3:A200)-COUNTIF($A$3:A200,"Z*"),1)
You can make the drop-down list point to a range that has formulas referencing the original range of values and then make it so those formulas return a blank value as desired. The values then won't appear in your list.
Also you can sort the results so the blank values appear at the bottom of the drop-down list.
These methods aren't perfect but they are easy to execute.
Try this file