count if

[pangersandmash]

Hello,

I am trying to replicate an excel count if formula. The difference with this is I want to count all items down a list, but nothing above. See below attachment for illustration

In this example, the count on 2135658HFA is 3 (in total). but by the second one, the count excludes the one above. so there are only 2 to count. Then on the last it becomes 1, as it excludes the 2 above.

Essentially, i want to allocate a "1" next to the LAST unique concat 2. 

Please help!!!

Thanks

[kumaranvr1984]

Here is the workflow with your input data file.

Regards,

Kumaran