• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Assign serial numbers to overlap dates

RSHA

New Member
Hi Team,

Can someone help me in solving the flagging of overlapping dates.

I have attached one excel file where overlapping is done with a formula. i left the formula as is for your reference. I want to assign serial numbers for every overlapping instances.

If there are overlapping dates then that should be marked with serial number, if no overlapping occurs between dates blank should be returned. I'm struggling to get the desired output.

The result i need is mentioned in column F manually.
Note. For better understanding I have inserted blank row in between data. Please ignore blank rows.
Thanks for you help..
 

Attachments

  • instances.xlsx
    16.7 KB · Views: 10
Last edited:
Back
Top