Creating Count Sequence in a column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ll98
9 - Comet
‎12-22-2020
05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Output
2 REPLIES 2
AngelosPachis
16 - Nebula
‎12-22-2020
05:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Emil_Kos
17 - Castor
‎12-22-2020
05:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!