Excel Data Organization: Array Formulas? Tables? Named Range?
- by Joe Arasin
I'm trying to make a huge Excel sheet reasonably maintainable, but it's huge in the "hundred-table-db" direction, rather than the "hundred-thousand-row-table" direction.
I want to have a baseline data table that looks something like this:
| Indicator | Units | 2010 | 2015 | 2020 | 2025 | Source |
| GDP …