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 have a list of unique and fist occurance items that I want to make an excel data validation list with. The list I have has a formula in it that allowed me to make it in the first place and now the data validation list only reads nothing. Do you have a formula I can use to show the items in the list I have?
Solved by K. C. in 26 mins
Cells E16546:E16557 in tab "AutoCAD Data validation" equals export QTY in column B with look up ref to column A for STANDOFF in tab "AutoCAD Export". QTY to go in one of the cells of E16546:E16557 based off excel selection box of G5
Solved by A. A. in 27 mins
Hi there, I created a data validation drop down list with classes [year7, year8, year9] in one sheet. My source sheet has fields like regno, name, gender, nationality, religion, subjects and so on. Im unable to extract data from my source file if I click on the drop down menu. Sometimes, year 7 is only working and fetching the data. but if i click on year8 nothing happens. Could you help me on this. I used count, countif, vlookup, index, if.
Solved by K. L. in 17 mins
I need help with a data validation problem for my financial modeling class
Solved by S. Q. in 27 mins
I've already created a Data validation dropdown in Cell A2. I want contingent on what you select, only specific cells in the row are open for you to edit.
Solved by K. L. in 13 mins
I created a drop down menu using data validation. added menus to it and scrolling id working using IF statement. extracts the data from other sheet and displays if i scroll. but How average calculation could be merged in IF fucntion in the same statemnt. how percentage and mean should be calculated in same statement.
Solved by B. U. in 25 mins
I need to create a formula that adds numbers together if 2 correlating cells are selected from a data validation drop down menu.
Solved by I. J. in 14 mins
I have 3 columns in excel. The first column is service type and it has a background table (data validation) with Parts replacement & Preventative maintenance in it. The next column is parts replacement and the third column is preventative maintenance. (each of those columns also has a background list). How can I make it so that when parts replacement is picked in the service type column there are no choices in the preventative maintenance column, but there are choices in the parts replacement column. (and vice versa ie. when preventative maintenance is chosen there are no options in the parts replacement column)
Solved by E. H. in 16 mins
Hello, I want to know how to create drop down list in excel 2010 with Data Validation in one sheet, and I don't know how to transfer this drop down list to other sheets in same excel file. I have applied a few tips on the internet, but it not transferring the information from drop down list, is all blank in the rest of the sheets... Can somebody help me with this? Many thanks in advance!
Solved by M. C. in 13 mins
I need a Data Validation Cell to create a sort of array of data from another Sheet. Meaning that if i Choose ''Option A'' in A Data validation cell a column combined of 28 other cells will be filled with data specified in a different sheet.
Solved by V. E. in 28 mins