Get instant live Excel expert help to learn how to add data validation in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

learning excel so i want to do some thing with my excel i want to create multiple lists and data validation which i know preety well but what i want is i want it to be dependent in another list and it will be four lists dependent on each other.
Solved by C. W. in 30 mins
I have data validation linking two columns - when you enter a name (only specific listed names allowed) then tab to the next column it is supposed to automatically enter the matching data (doctor name - doctor speciality are the validation lists). Recently it became corrupted for some unknown reason and no longer links, so now you can free type in the speciality column. Any hints?
Solved by O. E. in 15 mins
Hello, I need some spreadsheet help (name manager/data validation issue).
Solved by X. Q. in 17 mins
i have exceeded the number of characters allowed in the data validation "list" option. Is there an alternative for a lengthy set of options?
Solved by C. A. in 26 mins
In tab Data, in A1 to B50, I have a named range called Providers. In another tab, Template, I have a dropdown in col A where the data validation points to A1 to A50. I would like another dropdown in col B that finds the corresponding choices for Col A. Here are a few rows from Providers: PR01 01 PR01 02 PR02 01 PR03 01 PR03 02 PR03 03 In Template!A1 I select PR01 from dropdown. I want to go to B1, click the dropdown and have it show 01 and 02. I think it has something to do with adding the INDEX command in the Data Validation source, but can't quite figure it out. Thank you!
Solved by V. E. in 12 mins
Data validation question. With a formula that is not working properly.
Solved by Z. J. in 20 mins
Count the number of As, Bs, Cs, Ds and Fs using the appropriate function. Then add a data validation to the regions column using the list of regions in A25:A28. Include an input message and an error alert to stop the user from inputting anything other than what is on the drop down list. With a table total row, show the total funds raised, the total quota, and the average years of experience.
Solved by E. Y. in 21 mins
Is there a way to launch a "comment box" whenever within an excel cell (with data validation) the "other" option is selected? Thank you .
Solved by S. U. in 14 mins
Hi, I'm trying to get a Data validation formula to work. the cell I will be doing this on is A1 So the Data validation for cell A1 would look something like this: Custom: =IF(A1=0,B1/208,A1) I'm wanting to add a value into cell B1, so if cell A1 is left blank, I can reverse engineer an answer IF cell B1 has a value in it and cell A1 does not. BUT If cell A1 has a value, It will just display that value and ignore the rest of the formula. IF A1 AND B1 are both 0, then both cells will just show 0. I tested this formula on a cell and it works great, It's just not working from Data validation. Maybe because it's referencing itself?
Solved by G. L. in 24 mins
Hi I have an excel table with customer details (Name, Address etc) as well as a column called "Active" with Value of "Yes" or "No". In another worksheet I have data validation and I only wish to select and display the name column that has Active = "Yes"
Solved by X. C. in 28 mins