Moving counter of content present in two columns

[andreassh]

I have a challenge that i would like to calculate a moving counter where i count in the content of two columns. (see attached picture)

In excel, it is pretty easy as i can just use the countif function to see how many instances a given value has been present in all rows above in both column column BID1 and BID2.

I have tried using the tile block but it does not seem to work with two columns.

[Raj]

@andreassh 
find the workflow attached
mark done if solved.

[andreassh]

Thanks so much for the effort @Raj ! The code does not work at all times however.. If just it was as easy as in excel.. See the excel sheet and/or picture attached:

[Raj · Accepted solution]

@andreassh 
this is updated and now this work perfectly
the reason of 8 F records is row A539 null and as per logic the workflow works fine now

mark solutions done if solved