Excel Rows Formula

[mzimmerman]

I'm wanting to translate an Excel formula to Alteryx and I don't know how to reference "the cell above" another cell.  The Excel formula is: 

=IF(ROW()=1,1,IF(D2=D1,F1+1,1)). It's the IF(D2=D1...part, and the reference to F1 that I don't know how to do.  

The result would look like this. 

Column D     Column F

1234                1

1234                2 (1+1) 

1234                3 (2+1) 

12345              Reset to 1

I'm not a "power user" so is there a way to do this with basic tools? 

Thanks

[binuacs]

@mzimmerman 

[mzimmerman]

Thank you for the help.  That worked for me.  

[atcodedog05]

@mzimmerman 

Solution authors are Happy to help : ) 

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day!