Absolute Structured Referencing - A Nifty Little Trick

Hi Everyone, One of our MVPs brought a tutorial on ExcelCampus (http://www.excelcampus.com/tips/absolute-formula-references-excel-structured-table/) to my attention, and I thought it was so cool we should probably share it with everyone. When you select a column of data in a table to create a reference in your formulas, it automatically creates a structured reference for you – say…

3