SOLVED
Home

Extracting the most recent score from a multiple criteria maxifs formula

%3CLINGO-SUB%20id%3D%22lingo-sub-474344%22%20slang%3D%22en-US%22%3EExtracting%20the%20most%20recent%20score%20from%20a%20multiple%20criteria%20maxifs%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-474344%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20to%20extract%20a%20players%20most%20recent%20score%20from%20a%20table%20(TBLbenchpress).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20first%20section%20of%20the%20formula%20that%20returns%20the%20players%20max%20score%20in%20the%20table%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DMAXIFS(INDEX(TBLbenchpressSCORE%2C%2C%24Q%249)%2CTBLbenchpressSCORE%5B%5BPlayer%5D%3A%5BPlayer%5D%5D%2C%24C%242)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20the%20table%20contains%20multiple%20players%20past%20scores%2C%20I%20then%20tried%20to%20add%20on%20a%20max%20date%20criteria%20to%20the%20end%20of%20the%20formula%20(to%20return%20that%20players%20most%20recent%20score)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DMAXIFS(INDEX(TBLbenchpressSCORE%2C%2C%24Q%249)%2CTBLbenchpressSCORE%5B%5BPlayer%5D%3A%5BPlayer%5D%5D%2C%24C%242%2CTBLbenchpressSCORE%5BDate%5D%2CMAX(TBLbenchpressSCORE%5BDate%5D))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20this%20didn't%20work.%20I've%20been%20playing%20around%20with%20is%20for%20some%20time%2C%20but%20I%20haven't%20had%20any%20success.%20Any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-474344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-474410%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20the%20most%20recent%20score%20from%20a%20multiple%20criteria%20maxifs%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-474410%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323806%22%20target%3D%22_blank%22%3E%40BenEssenhigh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20PQ%20solution%20and%20a%20formula%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-474535%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20the%20most%20recent%20score%20from%20a%20multiple%20criteria%20maxifs%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-474535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20great.%20Thanks%20for%20making%20a%20excel%20document%20to%20show%20your%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20performance%20profile%20sheet%20is%20now%20up%20and%20running!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
BenEssenhigh
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

@Detlef Lewin 

 

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

 

My performance profile sheet is now up and running!

 

Related Conversations