QUESTION : I have a sheet consisting of about 10 drop down lists (among other fields). I want to create […]
Adding multiple validations to a cell
QUESTION : I’m adding some validations to a form in excel. The rule is displayed when the cell is selected, […]
How to have a sum of cells not exceed another cell?
QUESTION : Cell A23 get’s its value from cells A19:A22. Cell A23 cannot be higher than the number already in […]
Excel 2010 data validation warning (compatibility mode)
QUESTION : We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation […]
Excel data validation for decimals, but without a range?
QUESTION : I want to use the Data Validation in Excel to prevent users from entering a non-decimal value, but […]
IF/THEN drop down list
QUESTION : After an extensive search, all I seem to find are cascading drop down list topics. My situation is: […]
Custom Validation – Dependent Drop Down Lists
QUESTION : I’ve two columns in a sheet that are interdependent and I want to use validation, drop-down lists, on […]
Excel data validation to whole column
QUESTION : I want apply data validation list to a whole column in excel 2010. How can I do that […]
Using Excel Lookup Function and Handling Case Where No Matches Exist
QUESTION : I’m using Excel to enter data for an event where people register. A high percentage of the registrants […]
What are the limitations of the “Data Validation” custom formula in Excel 2010?
QUESTION : TL;WR Why does =if(column()=16, list1, list2) give an error when being used as a List-type Data Validation function? […]