Excel Tablesprovide a special kind of formula syntax called astructured reference.
For example this formula entered in G5:
will change to:
when the formula is copied to H5.
How can we look a column reference to stop it from changing?
Instead, you must duplicate the column name in another pair of square brackets ([]).
This allows the formula in G5 to be copied to H5 and I5 and keep working correctly.
