nathangwynmorris
New Member
- Joined
- Feb 23, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- MacOS
Hi All,
Been scratching my head on this for a while... I have a spreadsheet with the following:-
Column A = UserID [this varies on the number of entries based on the number of requests]
Column B = StartDate
Column C = EndDate
What I am trying to do is group up on the userID and then check column B and C to see if any of the dates above or below for that user overlap? So ideally in D2 would be my first formula. Ideally the data doesn't need to be sorted by ID or start date. And perhaps I could just have a simple overlap when the dates overlap and OK if there is no overlap
Any help would be amazing!!
Nathan
Been scratching my head on this for a while... I have a spreadsheet with the following:-
Column A = UserID [this varies on the number of entries based on the number of requests]
Column B = StartDate
Column C = EndDate
What I am trying to do is group up on the userID and then check column B and C to see if any of the dates above or below for that user overlap? So ideally in D2 would be my first formula. Ideally the data doesn't need to be sorted by ID or start date. And perhaps I could just have a simple overlap when the dates overlap and OK if there is no overlap
Any help would be amazing!!
Nathan