Apr 19 2019 12:33 AM
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:
=MAXIFS(INDEX(TBLbenchpressSCORE,,$Q$9),TBLbenchpressSCORE[[Player]:[Player]],$C$2)
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):
=MAXIFS(INDEX(TBLbenchpressSCORE,,$Q$9),TBLbenchpressSCORE[[Player]:[Player]],$C$2,TBLbenchpressSCORE[Date],MAX(TBLbenchpressSCORE[Date]))
However, this didn't work. I've been playing around with is for some time, but I haven't had any success. Any suggestions?
Cheers
Apr 19 2019 01:17 AM
SolutionApr 19 2019 02:54 AM
That's great. Thanks for making a excel document to show your formula.
My performance profile sheet is now up and running!
Apr 19 2019 01:17 AM
Solution