Compare range with previous ranges,display elapsed row match

[sans]

Hello,

What I am looking to achieve is a little complicated to explain, though I think is not hard to achieve by the experts here on the forum. I am uploading an attachment which hopefully is adequately clear to convey what I am trying to do.

I have been trying for days on how to solve this with no success. Hopefully someone is able to help.

Thank you

[sans]

If anyone has a partial solution for the above I am still interested

[nilem]

Hi Sans
maybe it will come across you on the correct idea (see green cells)

[sans]

Hi nilem,

Thank you very much for the reply!

I am uploading another attachment where I took your formula and created a more "clean" illustration in sheet2. I think it will be much better for showing to everyone what I am trying to achieve.

I don't know if anyone is trying for a solution and I appreciate any help I can get, but if only a vba solution is possible a UDF would be much more flexible especially for manipulating this type of data. However as I mentioned above any other help or partial solution is more than welcome

Thank you

[sans]

Just bumping this in case anybody is able to help...

[sans]

Getting this to the top...