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

[echuong1]

I would use a summarize to get a total count of all values, and then append it to another column. From there, you can use a multi-row formula or running total and formula to find the "rolling count."

Are you able to upload a copy of your sample data? I can try to mock a workflow for you. Thanks!

[kumaranvr1984]

HI Pangersand,

By using tile tool you can achieve the expected output.

Hope the attached output helps.

Regards,

Kumaran

[kumaranvr1984]

Workflow and output screenshots

[pangersandmash]

Thank you, few questions,

what is the formula 'rowno=1'? 

what configuration should the 'tile' tool have?

Thanks,

[pangersandmash]

scratch that, i have just seen your workflow attached. Thank you!

[pangersandmash]

Hi,

See attached

[pangersandmash]

THank you for your help. I want to replicate the countif 2 column in column V

[echuong1]

See attached - I believe it's what you're looking for. I essentially created a running total and then subtracted the total count of the column. I added the record ID and sort to keep the same order.

Hope this helps!

[kumaranvr1984]

Hi Pangersandmash,

I have replicated the same excel formula countif 2 column in column V.

My workflow gives you the same expected output.

Regards,

Kumaran