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!”
Here are some problems that our users have asked and received explanations on
I made a spreadsheet to compile data for 2 different types of scenarios. The first is the Task, these are customers sent from CS Reps (Customer Service Reps) to my team (Sales Reps). You can see what I am looking to track. The second group of data are the HOUSE ACCT phone in orders transferred to Inside Sales. You also see what I am looking to track from this. I put together grids with data validation to more easily choose reps and outcomes but i know that you guys can do something much nicer and more efficient. On the side you will see October totals. These are the totals that to have incorporated for each month as they accumulate.
Solved by Z. Y. in 25 mins
I AM USING DATA VALIDATION FEATURE
I WANT TO AVOID DUPLICATE NUMBERS AND ALSO PLEASE SHOW ME HOW TO DELETE DUPLICATES IN EXCEL.
I WANT TO DISPLAY NUMBERS BETWEEN 100 TO 300 FROM A RANGE OF NUMBERS
=AND((COUNTIF(A:A,A1,<=1),(A1>="100",A1<="300"))
I HAVE USED THIS FORMULA BUT UNABLE TO SOLVE MY ISSUE
Solved by I. E. in 28 mins
n the worksheet “4000 dates,” in cells A2:A4000, apply data validation so that if and only if the date in that cell is earlier than (i.e., less than) the date in the one cell immediately above it, the command “Circle Invalid Data” will encircle such values.
Solved by X. U. in 30 mins
How do I apply data validation to include only 0,1, and 999 in a column?
Solved by K. U. in 23 mins
I have a spreadsheet that was given to me. Several cells have down lists (list contains 1,0,-1 as options). If you select 1, a green circle appears in the cell with a checkmark. If you select 0, just the empty circle appears. If you select -1, an orange circle appears with an exclamation point. I'm a little familiar with data validation but can't figure out how this is done.
Solved by X. J. in 21 mins
how to include multiple years in a data validation instead of one
Solved by B. J. in 14 mins
Not sure what method is best to use. I am trying to connect data across tabs. Could be data validation or some other means of a lookup.
Solved by S. L. in 11 mins
My data validation is only returning an error message when I type in a value that is specified in the data validation options
Solved by V. H. in 30 mins
When using Data Validation, errors are being shown on blank cells whether or not I have "Ignore Blank" checked
Solved by O. C. in 13 mins
Hello I'm trying to create a data validation for a particular column and i'm a bit stuck at a certain point. I have been reading your help section and it says to choose what we want allowed. I selected the option of date. but unfortunately the help section does not really describe what all the different data settings mean. I would just like for the person working on the document to be able to add any date they would like but i'm not sure what i'm supposed to select for data
Solved by I. F. in 22 mins