Parsing and counting the name and email from a column

[sriniprad08]

Hi Team,

Hope you are well. I need help.

Please find attached the file with input and output.

Please let me know how to go to about it. thanks,

[atcodedog05]

Hi @sriniprad08 

1)The one marked in yellow is appearing in row 1 with twice "GGG" but the second one has to be 0 . Means if its appear more than one time in a row it should be marked as 0.

Yes that's the logic applied

2) Also currently the filter is only based on ggg is it possible to add more than one condition for filter like along with "GGG" also look for "AAA"? 

If you refer to my previous response you would need to add it in the formula to check and it will be looked up.

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you :). 

I am trying to make the modifications but i am not doing it properly. Can you please help me with adding the above conditions to the attached workflow ?

Thanks again :)