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 access the current row in Column1 AND the previous row in Column1...
Current row:
Previous row: wrong syntax - FAILS
Any ideas please? ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
& 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 access the current row in Column1 AND the previous row in Column1...
Current row:
Code:
=Table1[[#This Row],[Column1]]
Code:
=Table1[[#This Row]-1,[Column1]]
=Table1[[#This Row],[Column1]-1]