Moving counter of content present in two columns

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.

test.png

Book1.xlsx

Workflow

Developer

Best Practices

Accepted answers

Raj

@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

3159.yxmd

All comments

Raj

@andreassh
find the workflow attached
mark done if solved.

3159.yxmd

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:

Book1.xlsx

Picture3.png

Raj

@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

3159.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703