Category: OFFSET

I think if there is a single function that would be a huge threat to VBA and macros from user perspective, it would be INDIRECT()...

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

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

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