Formulas for Dynamic Named Ranges

My latest article, "Formulas for Dynamic Named Ranges", explains how to use the OFFSET function to create a named range that can expand to the last Numeric value, Text value, or Non-Blank cell within a column or row. Although there are many possible applications of this technique, I recently used it to create a meal planner where the cells within the planner reference a dynamic named range to populate a drop-down list within the cells. The formulas used for the dynamic named range allow the list to contain blanks and the user doesn't need to do anything except insert, delete, or modify the items within the list.