Year: 2012

Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column...

This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is...

Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the...

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 US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into...

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...

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...