structured reference Articles: Excel and Google Sheets

Structured Reference is a special feature of Excel that references tables.  It makes our formulas easier to understand and automatically adjusts whenever there are changes in our data.   Figure 1.  Final result:  Structured Reference How to create a structured reference A structured reference uses table names instead of the...