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?
View best response
A PQ solution and a formula solution.
That's great. Thanks for making a excel document to show your formula.
My performance profile sheet is now up and running!