Absolute Structured References in Excel Table Formulas

Bottom line: This post will explain a trick for creating absolute structured references in Excel Table formulas.  Also known as locking or anchoring the column references. Skill level: Beginner Intro Structured Reference Tables are great for creating clean, easy to read formulas.  But creating absolute references to the columns (aka anchoring the columns) in the … Continue reading Absolute Structured References in Excel Table Formulas