Forum Discussion
Sequentially number duplicates
I am trying to figure out how to create a calculated column to sequentially count any duplicate values. In my case, I need to check for duplicates in the "Shipping Order" column and sequentially num...
Hi,
I think this Forum Post answers your question.
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)
Look at the last row I added. I put 3 in the duplicate count. Is that your expected result?
| Shipping Order | Shipping Line | Shipping Date | Duplicate Count |
| 123456 | 5 | 09/15/2019 | 1 |
| 123456 | 6 | 9/16/2019 | 2 |
| 78910 | 1 | 9/16/2019 | 1 |
| 78910 | 3 | 9/17/2019 | 2 |
| 987654 | 1 | 9/18/2019 | 1 |
| 654321 | 2 | 9/19/2019 | 1 |
| 123456 | any | 9/21/2019 | 3 |