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 states and a technique (INDEX …

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 table Now, say you have …

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 …