A different approach.
See table at cell H26.
I changed a date (cell E3) in the source data to cause overlaps (I know, it may never happen) so you can see what happens in the results (T28:V28).
If the source data changes, the table (a pivot table) will need refreshing (right-click it and choose Refresh).
[The whole thing is a Power Query on your source data, which loads to the Pivot Table, with the data added to the Data Model so that a measure (txt) can be added and used in the Values area of the Pivot table.]
Last edited by p45cal; 12-11-2023 at 07:02 PM.
Reason: corrected name of attached file
|