Unique intervals

[MindaugasBacius]

Hello,

I have data like this (see the attachment):

I need to have unique intervals without overlapping intervals.

The outcome should be like this:

There are few ways to get the correct result. But unfortunately I cannot come up with the correct logic here.

Thank you in advance!

[Gysbert_Wassenaar]

I'm afraid I don't understand the result you want. The first two rows in your outcome screenshot show two intervals that overlap.

[MindaugasBacius]

E and F columns shows rows that should be deleted or kept in the result.

There are two ways to make it correct but it depends on how you manage the issue. Both outputs suit me.

[Gysbert_Wassenaar]

It's still not clear to me. But have a look at page 17 and 18 of the pdf file attached to this document: IntervalMatch and Slowly Changing Dimensions

[raajaswin]

I think this is what you want..  It gives column F value

[maxgro · Accepted solution]

my attempt in the attachment

[MindaugasBacius]

Could you please take a look at this issue:

Overlapping intervals