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”, you can tell that Validations on column B is for the heads (Main categories), and on column D is for the sub category of the […]

Dynamic selection list

Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read from a large table in another sheet   After creating two names, one is “Months” having: =OFFSET(Sheet1!$B$5,0,0,COUNTA(Sheet1!$B:$B)-2,1) And the other one is “Month_All” having: =OFFSET(Sheet1!$B$5,0,0,COUNTA(Sheet1!$B:$B)-2,3) Draw a listbox using “Developer […]

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 is corresponding to it. You need to create two names (Formula > Name Manager), one has this formula =OFFSET(Sheet1!$A$2,0,1,1,COUNTA(Sheet1!$2:$2)) The other one has this