Zipcode-State search
Enter a zip code, and Excel will tell you in which state it is It also has a list of all zip codes for all...
Convert 2-column into wide (column-row) table
This Excel file will convert a table of two columns into a Column-Row table Using functions only and auto-updated once the Main table update In...
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...
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...
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...