I have a list of: Name, Date Start, Date End, and Percent Allocated. One person may show up multiple times in the list with different start and end dates. My objective is to see if that person is ever allocated over 100%, and if so to flag that. For example, if John is allocated at 60% between 11/5 and 11/29 and 65% between 11/15 and 12/31, that should be flagged because between 11/15 and 11/29, he would be allocated at 125%. If Sally is allocated at 85% between 11/ and 12/31 and 10% between 12/1 and 1/31, that would not be flagged because she is only allocated at 95% between 12/1 and 12/31.
Solved by I. S. in 19 mins