data-validation Archives

Excel – Using a drop-down list to populate other drop-down lists

By JamesPosted on March 3, 2023

QUESTION : I have a sheet consisting of about 10 drop down lists (among other fields). I want to create […]

By JamesPosted on February 28, 2023

QUESTION : I’m adding some validations to a form in excel. The rule is displayed when the cell is selected, […]

By JamesPosted on January 1, 2023

QUESTION : Cell A23 get’s its value from cells A19:A22. Cell A23 cannot be higher than the number already in […]

By JamesPosted on December 28, 2022

QUESTION : We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation […]

By JamesPosted on November 16, 2022

QUESTION : I want to use the Data Validation in Excel to prevent users from entering a non-decimal value, but […]

By JamesPosted on October 4, 2022

QUESTION : After an extensive search, all I seem to find are cascading drop down list topics. My situation is: […]

By JamesPosted on October 2, 2022

QUESTION : I’ve two columns in a sheet that are interdependent and I want to use validation, drop-down lists, on […]

By JamesPosted on September 18, 2022

QUESTION : I want apply data validation list to a whole column in excel 2010. How can I do that […]

By JamesPosted on September 13, 2022

QUESTION : I’m using Excel to enter data for an event where people register. A high percentage of the registrants […]

By JamesPosted on September 6, 2022

QUESTION : TL;WR Why does =if(column()=16, list1, list2) give an error when being used as a List-type Data Validation function? […]