SOLVED

Extracting the most recent score from a multiple criteria maxifs formula

Highlighted
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:

 

=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

 

 

 

2 Replies
Highlighted
Best Response confirmed by BenEssenhigh (New Contributor)
Solution

@BenEssenhigh 

A PQ solution and a formula solution.

 

Highlighted

@Detlef Lewin 

 

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

 

My performance profile sheet is now up and running!