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”, …

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 …

Sort list dynamically (functions)

Sorting a list automatically using formulas, with no need to press the sort command Also if the source table is changed, the destination table will do also. What you need …