I'm trying for a solution where multiple columns has datetime as below table, I've tried using multirow formula "IF ID = Row-1:ID And End = Row-1:Start and applied rank formula but I'm not getting expected output.
ID | Start | End |
1 | 12/29/2021 8:07 | 12/29/2021 8:30 |
1 | 12/29/2021 8:30 | 12/29/2021 9:00 |
1 | 12/29/2021 9:00 | 12/29/2021 9:30 |
1 | 12/29/2021 9:30 | 12/29/2021 10:00 |
1 | 12/29/2021 10:00 | 12/29/2021 10:30 |
1 | 12/29/2021 13:00 | 12/29/2021 13:30 |
1 | 12/29/2021 13:30 | 12/29/2021 14:00 |
1 | 12/29/2021 14:00 | 12/29/2021 14:30 |
1 | 12/29/2021 14:30 | 12/29/2021 15:00 |
1 | 12/29/2021 15:00 | 12/29/2021 15:30 |
1 | 12/29/2021 15:30 | 12/29/2021 16:00 |
1 | 12/29/2021 16:00 | 12/29/2021 16:30 |
1 | 12/29/2021 16:30 | 12/29/2021 17:00 |
1 | 12/30/2021 7:00 | 12/30/2021 7:30 |
1 | 12/30/2021 7:30 | 12/30/2021 8:00 |
1 | 12/30/2021 8:00 | 12/30/2021 8:30 |
1 | 12/30/2021 9:51 | 12/30/2021 10:00 |
1 | 12/30/2021 10:00 | 12/30/2021 10:30 |
1 | 12/30/2021 13:00 | 12/30/2021 13:30 |
1 | 12/30/2021 13:30 | 12/30/2021 14:00 |
1 | 12/30/2021 14:00 | 12/30/2021 14:30 |
1 | 12/30/2021 14:30 | 12/30/2021 15:00 |
1 | 12/30/2021 15:00 | 12/30/2021 15:30 |
1 | 12/30/2021 15:30 | 12/30/2021 16:00 |
1 | 12/30/2021 16:00 | 12/30/2021 16:30 |
1 | 12/30/2021 16:30 | 12/30/2021 17:00 |
1 | 12/25/2021 7:00 | 12/26/2021 16:00 |
1 | 12/26/2021 7:00 | 12/27/2021 17:00 |
And I'm trying to find a solution where to get an output as below
ID | Start | End |
1 | 12/29/2021 8:07 | 12/29/2021 10:30 |
1 | 12/29/2021 13:00 | 12/29/2021 17:00 |
1 | 12/30/2021 7:00 | 12/30/2021 10:30 |
1 | 12/30/2021 13:00 | 12/30/2021 17:00 |
1 | 12/25/2021 7:00 | 12/26/2021 16:00 |
1 | 12/26/2021 7:00 | 12/27/2021 17:00 |
Thanks for the help in advance.
Solved! Go to Solution.
I'm not understanding the actual logic you're looking for, but it sounds like the Multi Row Tool is what you want along with a conditional statement.
I'm not sure by your example how 12/29/2021 8:07 is pairing up with 12/29/2021 10:30 (same with the rest of the examples).
Ah....the grouping aspect wasn't clicking in my head. @atcodedog05 has the proper solution!
Happy to help : ) @PNC97
Cheers and have a nice day!
@atcodedog05 @mbarone Thanks for you help 😀