Hello all,
I am looking to get count of rows as shown below in the output. I know this can be done using multi row formula, Can anyone assist with the formula or workflow to get the desired output.
Input-
| SNO | Date1 | Date2 |
| 1 | 7/18/2023 | 7/18/2023 |
| 2 | 7/18/2023 | 7/19/2023 |
| 3 | 7/18/2023 | 7/20/2023 |
| 4 | 7/18/2023 | 7/21/2023 |
| 5 | 5/11/2024 | 5/11/2024 |
| 6 | 5/11/2024 | 5/12/2024 |
| 7 | 5/11/2024 | 5/13/2024 |
| 8 | 5/11/2024 | 5/14/2024 |
| 9 | 10/11/2020 | 10/11/2020 |
| 10 | 10/11/2020 | 10/12/2020 |
| 11 | 10/11/2020 | 10/13/2020 |
| 12 | 10/11/2020 | 10/14/2020 |
| 13 | 10/11/2020 | 10/15/2020 |
| 14 | 10/11/2020 | 10/16/2020 |
| 15 | 10/11/2020 | 10/17/2020 |
Output-.
| SNO | Date1 | Date2 | Seq |
| 1 | 7/18/2023 | 7/18/2023 | 1 |
| 2 | 7/18/2023 | 7/19/2023 | 2 |
| 3 | 7/18/2023 | 7/20/2023 | 3 |
| 4 | 7/18/2023 | 7/21/2023 | 4 |
| 5 | 5/11/2024 | 5/11/2024 | 1 |
| 6 | 5/11/2024 | 5/12/2024 | 2 |
| 7 | 5/11/2024 | 5/13/2024 | 3 |
| 8 | 5/11/2024 | 5/14/2024 | 4 |
| 9 | 10/11/2020 | 10/11/2020 | 1 |
| 10 | 10/11/2020 | 10/12/2020 | 2 |
| 11 | 10/11/2020 | 10/13/2020 | 3 |
| 12 | 10/11/2020 | 10/14/2020 | 4 |
| 13 | 10/11/2020 | 10/15/2020 | 5 |
| 14 | 10/11/2020 | 10/16/2020 | 6 |
| 15 | 10/11/2020 | 10/17/2020 | 7 |
