special specifier

  1. S

    Formula: Table1[[#This Row],[Column1]] BUT need Previous Row

    I'm creating formula's for some rows in an excel table (eg: Table1) & in the formula, I need to be able to reference the previous row but cant figure out the syntax. There's a [#This Row] special item specifier but there's nothing like [#Previous Row]. Eg: a formula in Column5 may need to...

Some videos you may like

This Week's Hot Topics