Extracting the most recent score from a multiple criteria maxifs formula

New Contributor

Hi all.


I'm looking to extract a players most recent score from a table (TBLbenchpress).


This is the first section of the formula that returns the players max score in the table:




Because the table contains multiple players past scores, I then tried to add on a max date criteria to the end of the formula (to return that players most recent score):




However, this didn't work. I've been playing around with is for some time, but I haven't had any success. Any suggestions?






2 Replies
Best Response confirmed by BenEssenhigh (New Contributor)


A PQ solution and a formula solution.



@Detlef Lewin 


That's great. Thanks for making a excel document to show your formula.


My performance profile sheet is now up and running!