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!
Bookmarks