Macro not identifying all overlaps between dates

Challenge is to identify all the "overlaps" between the policies in Col E taken out against the same loan in Col B.

Attached Macro works perfectly where there is an overlap between consecutive rows, but I can't work out how to make it "see" the overlaps that may be on a non-consecutive row, and map that overlap.

E.g. Rows 10 - 12 show loan 193672 has been covered by Policies 9, 10 and 11. The Macro identifies the overlap between Policies 9 and 10, and between 10 and 11, but "misses" that there is still an overlap between Policies 9 and 11 after Policy 10 expires.

Please Login or Register  to view this content.

Cols M - AB demonstrate the overlaps that should be captured.

Hope it's clear, and all suggestions, pointers and solutions welcome as ever.

Ochimus

CAntosh,

Spot On!

Does exactly what it needs to on the sample. Will try shuffling dates around, and adding something with five rows and four links, but can't see it not working.

Happy to mark this as "Solved"

Ochimus