Tag Archives: Named ranges

Dynamic named ranges

Huge power can result from combining the OFFSET function with Named Ranges in Excel. Here's how. OFFSET itself is phenomenally powerful. It allows you to refer to a range of a chosen height and width that is a chosen number … Continue reading