Use named ranges for maintainability; change the name once to update all formulas that use it. Its easy to create ... in most spreadsheet software, including Microsoft Excel.

An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.

An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.