I am supporting CandidateX

CandidateX is a startup that focuses on creating inclusion-focused hiring solutions, designed to increase access to job opportunities for underestimated talent. Check them out if you have a few minutes to spare. They need visibility!

Organizing ranges for reuse – minimizing maintenance of data ranges

You’ll find that I use named ranges rather than cell references pretty much throughout. This is because I want to separate the usage of some of these functions from where the data is. I’m not saying that you have to use named ranges all the time, but I hope you’ll see the value of creating them for data that may change or be referred to from multiple places. In any case, working through the examples should give you enough familiarity to make the right choices.

For help and more information join our forum, follow the blog or follow me on Twitter