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

I want to prevent overwriting by copy pasting into the cells containing Data Validation, which is rendering it useless. I dont know how to use VBA in excel Please help stepwise thanks
Solved by C. E. in 26 mins
I created 5 tables from one and reference them using data validation: "=IF(H4="Paving",PDescList,IF(H4="Iowa",IDescList,IF(H4="Nebraska",NDescList,IF(H4="NonDOT",NonDescList,IF(H4="Rebar",RDescList,"der")))))" i select the table from a list, now i want to reference the tables selected and get information for the item selected in the referenced lists.
Solved by G. Q. in 12 mins
Hi I want to create drop down list (data validation) and when I pick from this list I want my selection to have a corresponding number somewhere else on the spreadsheet. Please help!
Solved by K. E. in 20 mins
I have a sheet with a data validation column, how do I use this data to create a pie chart? In this case, the sheet is a list of people and the drop down data validation lists where they are from - how can I create a pie chart to show all the locations where everyone is from so we can get an at-a-glance view of how many people are in each region. Thank you!!
Solved by S. H. in 24 mins
I have created a spreadsheet with a dependent data validation drop down list, is there a way that I can copy the validation drop down as I want to use this for each row. If I select Airframe in the 1st row, the dependent drop down will show Fin, Tail, Elevators etc. I might have the row below with Prop which would have a dependent data validation drop down of Blades, Spinner. I want to carry out this task for multiple rows therefore currently I'd use this formula in cell E1 =INDIRECT($B$1) to get the value Airframe from the 1st drop down which will display Fin, Tail, Elevators. For the next row down, I'd need to use =INDIRECT($B$2) and so on for the next row. Is there a way to copy this subtle difference down the rows as it is in the data validation cell?
Solved by O. B. in 27 mins
Can we create Dynamic dependent list while using data validation in excel. Can anyone help me?
Solved by B. J. in 17 mins
I need to incorporate data validation into the following formula: =IF(C2="Credit Contract Agreement Unsigned",INDEX($D$2:$D$934,MATCH(CONCATENATE(B2,"Credit Contract Agreement Signed"),$E$2:$E$934,0)),"") Column F has a date 14 days after the loaded date, and I need to ensure that whatever result date for a signed is pulled falls within those two dates.
Solved by K. L. in 28 mins
make cell x = cell y when data validation in cell z is one of two options
Solved by X. L. in 16 mins
I have a column with data validation on it for the =NOW() formula. I need a formula that can count the number of times listed within a time range. The output i am looking for is excel count number of cells between "3:00PM and 3:30PM."
Solved by O. F. in 20 mins
Hi, in my Excel attached I would like to use a combined data validation. On Sheet 1 Column C, Cell C2 I validated 3 main categories which you can find on the Sheet 2. My problem what I would like to solve is that, if I choose a category in Column C, Cell C2 (eg.: Reviewer issue), after in Column D, Cell D2 to have in the dropdown only the elements which are coresponding to this Subcategory, and no matter which Category I am choosing in C2, in D2 I will get only the elements which is corresponding to that specific Category. Thank you in advance for your help!
Solved by S. B. in 11 mins