Skip to content

{ Tag Archives } named ranges

Creating Dynamic Named Ranges in Excel® using OFFSET & COUNTA

Following on from Creating Named Ranges in Excel®, this blog post describes how to create dynamic named ranges. If you’re not familar with named ranges, I’d really suggest google searching “named ranges in excel” or read the post linked to above. As mentioned many times on this site, named ranges are really useful, however there […]

Share
Also tagged , ,
2010 05 04 Ryan Kirgan Excel Tips Comments (13)

Creating Named Ranges in Excel®

Named ranges are great. They allow the user to define a cell range with a single text-descriptor. For example, you could define the cell range of $A$1:$G$1 as the string “headings” and every time you wanted to refer to that cell range (in, say, a formula) you use the string “headings” instead. I’ve alluded to […]

Share
Also tagged
2010 05 04 Ryan Kirgan Excel Tips Comments (3)