This is that post - 100% plagiarized from the original when it makes sense to do so. The kicker is that I wrote that post before I’d discovered the awesomeness of Excel tables, and before Excel 2010 had really gone mainstream. I’ve been meaning to redo the original post with an example that uses tables, because it simplifies things a bit.
Apparently, through sheer volume of content on the page and some dumb luck with the post title, I consistently do well for searches for “Excel dynamic named ranges” (long live the long tail of SEO!). The single post on this blog that has, for several years now, consistently driven the most traffic to this site, is this one that I wrote almost three years ago.
Originally written by Analytics Demystified on June 8, 2013
