Referencing same line item of prev row
I am facing issue in trying to reference the same item of prev row. For example,
This is the Excel formula for a line item ‘Calendar Month’ :
IF Calendar month of prev row = 12 THEN 1 ELSE Calendar month of prev row + 1
Has anyone faced similar issue? The Else part of the formula gives circular reference.