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...
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...
Extract Address into table
Convert US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into...
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...
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...
WorksheetName and WorksheetsNo UDFs
Once you open the sheet and enable macros, you can use function: =WorksheetsNo() To get total number of sheets in that workbook And use function:...