State Abbr with Index+Match+Validation
Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the name of the state based …
Category: Data Validation
Multiple Dual-Validations
It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each other. Checking out sheet “Data”, …
Multiple-Validations (connected to each other)
Here is the free file for a special request by a client He wanted to have multiple cells having Data – Validation to same list but minus the selected one …
Validation based on another Validation
Creating a Data Validation based on another Data Validation Meaning that when you select from a drop down from the first the second will be filled with the list that …
Excel Dynamic Drop-Downs that grow with you
This will help you do a dynamic name to use on a drop down, a Form Listbox or Form Combobox. The screenshot almost says it all. You need 4 steps: …