Time between period for each ID

[Tommy23]

Hello I would like to have column that tell me if there is one period that are combine for each ID. (Juxtapose period)

Here a example of sample data ( this just an example , how to do it o it can work for various case)

ID	Begin Date	End date
1	28/01/2022	01/02/2022
1	01/01/2022	10/01/2022
2	05/01/2022	18/01/2022
3	19/02/2022	20/02/2022
4	18/01/2022	19/01/2022
4	06/01.2022	07/01/2022
4	02/03/2022	03/03/2022
1	25/01/2022	18/03/2022
2	06/01/2022	07/01/2022
3	14/01/2022	15/01/2022

For example here the ID 1 and 2 have period that are combine 

I hope I was clear thanks

Thanks :)

[IraWatt]

Hey @Tommy23,

What would you expect in the new column, would all rows with ID 1 and ID 2 have "yes" in them for example?

[Tommy23]

Yes this will be great @IraWatt 

[Tommy23]

Thanks again :) @IraWatt 

[binuacs]

@Tommy23 can you provide the expected result as well?

[FreeRangeDingo]

Curious what others think, but my thought is that you would need to build a macro that takes one row and then compares it to all other rows. Also, I would make sure that your ID field is actually an ID and doesn't have duplicates.

[IraWatt]

Hey @Tommy23,

Is this the output your looking for?

Its yes if it covers or is being covered by another ID. I can change it to only look for ID's which are covered.

Any questions or issues please ask :)
HTH!
Ira

[Tommy23]

Hello I would like to have a column where "Yes" is wrote on the two or multiple row that have a period combine. @binuacs   

ID	Begin Date	End date	Results
1	28/01/2022	01/02/2022	YES
1	01/01/2022	10/01/2022
2	05/01/2022	18/01/2022	YES
3	19/02/2022	20/02/2022
4	18/01/2022	19/01/2022
4	06/01.2022	07/01/2022
4	02/03/2022	03/03/2022
1	25/01/2022	18/03/2022	YES
2	06/01/2022	07/01/2022	YES
3	14/01/2022	15/01/2022

@FreeRangeDingo   ID is not an ID it is like a name or something it is not unique sorry for this misunderstand

[Tommy23]

Hello thanks for this,

I would like to be Yes if it is covered only by a period on the same ID, is what you did?

or you did "Its yes if it covers or is being covered by another ID"

@IraWatt 

[Tommy23]

ID is just not unique it is like a name or something @IraWatt