Hi guys,
i'm trying to get a formula done where i can get a sequential numbering inside each cluster (example in the table below).
Basically, inside each cluster the first date and the earliest hour will be numbered 1 and so on.
When the next cluster starts the sequential numbering restarts from 1 and so on.
As an example to explain a little better what i'm trying to accomplish:
Cluster one (which is sorted by date and time) shows a sequential numbering of 1-9.
On Cluster 2, that's not sorted, the sequential will be 1,2,5,6,3,7...
And cluster 3 and so on will be numbered accordingly
any suggestions on how to do it? i'm struggling with the date and time part of it.
thx in advance
i'm trying to get a formula done where i can get a sequential numbering inside each cluster (example in the table below).
Basically, inside each cluster the first date and the earliest hour will be numbered 1 and so on.
When the next cluster starts the sequential numbering restarts from 1 and so on.
As an example to explain a little better what i'm trying to accomplish:
Cluster one (which is sorted by date and time) shows a sequential numbering of 1-9.
On Cluster 2, that's not sorted, the sequential will be 1,2,5,6,3,7...
And cluster 3 and so on will be numbered accordingly
Date | Hour | Cluster | Sequential Numbering |
01/01/2021 | 08:00 | 1 | 1 |
02/01/2021 | 08:00 | 1 | 2 |
02/01/2021 | 12:00 | 1 | 3 |
02/01/2021 | 15:00 | 1 | 4 |
03/01/2021 | 08:00 | 1 | 5 |
03/01/2021 | 10:00 | 1 | 6 |
03/01/2021 | 12:00 | 1 | 7 |
03/01/2021 | 16:00 | 1 | 8 |
03/01/2021 | 18:00 | 1 | 9 |
02/02/2021 | 08:00 | 2 | 1 |
02/02/2021 | 08:00 | 2 | 2 |
04/02/2021 | 08:00 | 2 | 5 |
05/02/2001 | 10:00 | 2 | 6 |
03/02/2021 | 12:00 | 2 | 3 |
05/02/2001 | 12:00 | 2 | 7 |
03/02/2021 | 15:00 | 2 | 4 |
05/02/2001 | 16:00 | 2 | 8 |
05/02/2001 | 18:00 | 2 | 9 |
any suggestions on how to do it? i'm struggling with the date and time part of it.
thx in advance