Having difficulties using Sumproduct, SUMIFS and others trying to perform a multi criteria formula that includes a LEFT/FIND criteria and date/time criteria.
I am trying to find the last Finish (Referencing the End Time to the current row Start Time) entry with a matching name pre-fix only. I'll attach a summarized example.
Any suggestions?
Bookmarks