Good evening, I would like to ask you a question:
do you know if there is a formula to insert in data validation
that shows you a drop-down menu without empty lines?
Of course without having another service column
Thanks
Good evening, I would like to ask you a question:
do you know if there is a formula to insert in data validation
that shows you a drop-down menu without empty lines?
Of course without having another service column
Thanks
Not that I'm aware of... but who knows, someone else might.
As far as I know, you will need a helper column (somewhere) to create a blank-free list.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I thank you,
I wait to see if another idea comes up.
Cannot be done without creating a new "helper" column (as per Glenn's reply).
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks