I think my formula may require MAX INDEX and MATCHsomehow, but I’m stumped.
I need to look at the earliest date and the latest date against memberslisted below (dates in between should be ignored). Ineed to then compare the Total Score against the earliest and latest date andif the Total...