Extract rows from an array by highest value in Column A for a unique Column B

Hello good people,

I have an array created by some elaborate filtering in formulas, see below (this is a dynamic list, not an actual table that can be referenced as such).
My goal is to filter this array so that for each user I see the row containing the highest value in the first column.

Screen Shot 2022-12-09 at 3.58.45 PM.png

The expected output would look something like this:

Screen Shot 2022-12-09 at 3.53.07 PM.png

This must be done in a formula with no power queries and pivot tables etc because (1) Excel for Mac and (2) I got here with formulas so I might as well complete it with formulas.

I'm stuck! Tried all the INDEX / MATCH / MAXIF / XLOOKUP etc combinations I can think of.

Any advice?

Thank you!

Hi,

According to my interpretation from the picture..(I may be misinterpreting)

(Elaborated an array with dynamic array formulas in cell M3)

Formula:

Please Login or Register  to view this content.

Or

Formula:

Please Login or Register  to view this content.

Please read the yellow banner at the top of the page and attach a good sample.

Apologies Gregb11, I will do it next time.

52779 your first solution worked exactly as needed! Thank you. For some reason there is very little documentation out there to make this calculation based on an array and not a table or set values, so I hope this thread will come up in future searches.

Thank you!

@talazar

Glad to have helped.
Thanks the feedback.