Morning everyone, hoping you can help.
I have the below example of data organized by entries of "U", "P" or "S" against a name and under a given date.
I need three separate formulas (for "U", "P" and "S") to count the occurrences of grouped letters arranged under consecutive dates, but counting only after the date entered. The desired outcomes are shown in the orange box in the below example.
I hope my need is clear, please just ask if not.
Excel.png
Bookmarks