Account Id | Name | Count Order | Count Order - Expected Result |
45 | Orka | 1 | 1 |
45 | Orka | 2 | 1 |
45 | Balwing | 3 | 2 |
45 | Balwing | 4 | 2 |
45 | Cropsey | 5 | 3 |
45 | Alabama | 6 | 4 |
45 | Jersey | 7 | 5 |
45 | Jersey | 8 | 5 |
I created a multiple row sequence formula -- but its counting every row --If the name is the same - I just want to be counted once -- similar to what I'm looking in Column d.
Hi @ll98 ,
You can achieve that by configuring the multi-row formula tool as shown below
Hope that helps let me know if you have any questions
Regards,
Angelos
Hi @ll98,
I have created a solution for you.
I wasn't sure what the logic should be so I am checking both Account ID and Name. If they are exactly the same as the previous row then I identify them as the same group.
Please mark my post a solution if this is helpful!