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
Data Validation to restrict user input in column Transaction Unique Code, the transaction code couldn't have repetition on letter or number, for example: restrict user input 9A567A since A is repeated. NO letter or number repeated in a single cell.
Solved by B. Y. in 22 mins
Please help me again, i want to add some other conditions to the unique code data validation.
Solved by C. C. in 19 mins
i have run out of credit, hope this time helped me. Excel data validation formula to restrict user input for: 1. any space in the text. 2. repeated letter or number in text.(restric aABCD, A and a is same) 3. text length must between 5-10
Solved by M. A. in 30 mins
please , this is my last credit. i have 5 people helped me without solutions. the 1st seems good but need some modification. i want data validation to restrict repetition of any character letter,number, and symbols. but the letter is same small and capital for example aA$123# is not allowed for user input
Solved by E. E. in 29 mins
data validation to restrict user input of transaction code, restrict: 1.repetition on character i.e. letter, symbol, number, marks. (example UA2#5T#, # is repeated). 2. any space 3. text longer than 10
Solved by S. A. in 22 mins
please help me only if you can do data validation formula, without macro if possible. user input in transaction code column are excel restricted values:
1. restrict repeated character ie letter, symbol, marks, number
2. restric space
3. restrict text length more than 10
Solved by K. H. in 21 mins
my databar should become relative to total, and suggest the best data validation to show if total is too high, high, good, low, too low than target.
Solved by G. W. in 13 mins
Please see the SSE – All Jobs Tracker - Column AD formula from Row 5 onwards – I”ve put the formula incorrectly so please can you correct it in Row AD5 so I can see it:
I’ve put:
=IF(AC5="","",IF(AC5="Retro Fit-Non-Jointing""FPIs-Non-Jointing""Defects""Other","N","Y"))
but all Cells in Column AD are coming up blank or with Y in it so it’s not working:
What I want the formula to say is this…..
If the Value in Column AC is blank or ‘Other’, leave it blank BUT if the value is ‘Defects,’ ‘Retro Fit-Non-Jointing’ or ‘FPI’s-Non-Jointing’, then put “N”, for all other options put “Y”.
The options are on a drop down list inserted via data validation on the Drop Down Options Tab – Row F8-16.
Solved by A. E. in 28 mins
I am new to excel and I am trying to create a workbook for a training ramp. There will be 10 classes. So I have created a summary page and 10 tabs, 1 for each class. On the summary page I need a begginning head count, total # termed, final head count and the attrition. I do not know what formulas I need to get this. On each sheet I have a termed column Yes/No with a data validation dropdown to select. Any help would be appreciated as to what formulas I would need to make this work.
Solved by V. S. in 24 mins
How do i create list in excel to list from another sheet from inside the same workbook?
Solved by A. A. in 19 mins