Count iterations of a duplicate

[Richie059]

Hey guys, So I'm trying to design a workflow that will count each time a duplicate piece of data appears. As it appears in this text input tool, Thank you! 

[Jonathan-Sherman · Accepted solution]

Hi @Richie059,

You could achieve this with a mutli-row formula, ensuring you're grouping on the Fruit column:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

This will change the order of your records but you could simply add a Record ID tool prior to the multi-row formula and sort after the multi-row formula to keep them in the original order.