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 am not able to access the Data Validation tool from "edit in the browser" within Excel online. Could you help me work through this, or maybe show me another way to create an excel drop down list?
Solved by V. S. in 28 mins
I'm trying to create a spreadsheet that will let me populate a cell with training sessions and it will automatically sum up the hours and minutes. I'm using data validation to filter out the modules by subject in the adjacent column, and I've added a macro to allow that cell to be populated with a number of modules. I need to somehow link the modules to the times on the next sheet, and sum the total hours and minutes.
Solved by F. F. in 23 mins
I'm looking to create a form where drop-downs change depending on what was chosen in the previous cell. I'd like to be able to somehow do a VLOOKUP in a Data Validation, if possible.
Solved by A. F. in 23 mins
need a sum offset formula to add any three PRECEDING months profit and loss line items where the months are going across the spreadsheet. The adding of which three months depends on the data validation I have used. I put the months starting from March in the source. So if I picked May from the data validation cell, formula should add March,April,and May's line items amounts.
Solved by X. Q. in 19 mins
need a formula in highlighted cell to add any three PREVIOUS months for that line item based on month I select in cell D2 in the "Report P&L" tab. My first month in the source section of the data validation is March.
Solved by M. C. in 29 mins
Hello! I have two columns where only one cell per row can contain a number. I tried to solve it with data validation, but I can't seem to get it work. Could you please help? Thanks in advance!
Solved by D. F. in 21 mins
How do I delete Duplicate rows in Excel using data validation in MSExcel 2016. I would like to prevent the user from data entering a code more than once in three row ranges
Solved by B. D. in 26 mins
I'm looking to use data validation to solve a problem, but it simply may not be the best route. Here's is what I'm trying to accomplish. I have multiple customers all who have different services we provide. Within each customer's list of services is a list of different allocation methods we use. What I'd like to do is pre-populate the service list and allocation methods in drop-down list by just knowing the specific customer. I have approximately 50 customers, and there's more detail for each of which I'd like to do the same prepopulating method. Can you guide me?
Solved by E. J. in 14 mins
I need some help building a conditional data validation google spreadsheet input sheet.
Solved by M. A. in 27 mins
Excel drop down data validation arrows don't work when I emailed the file.
Solved by E. J. in 16 mins