• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation [List Prediction]

B

bharath

Member
Hi Hui,

I want data validation list with prediction word like filter selection
if we type 'a' in drop down with 'a' started words will display
 
I don't know of a way to make data validation auto-suggest based on initial text input. you can use the dropdown menu to show the list contents- do you have too many list items for this to be practical.

I would add that the lack of response may have something to do with perceived attitude in your posts. I have received excellent help from people on this forum but still appreciate that my problems with excel are my own and that any help or work done by others on my behalf is voluntarily given.
 
This forum operates 24/7 with members in countries all around the world, a question may be answered by someone and then go quite, there are many reasons for this as members have many things to do outside of the Forum, eat, sleep, work, hobbies, family the list goes on and on. A reply and answer may be urgent and important to you but not to the members.
Your "helloooooooo......" will just put people of from helping


Please read:-

http://chandoo.org/forum/threads/new-users-please-read.294/


As for your question

Is it possible or not
Click to expand...

Yes it is.
 
In Data Validation List Option with prediction word like filter selection
Is it possible or not if possible please help me
 
You must log in or register to reply here.
Back
Top