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...