Forum Discussion
Solved
List least recent date from table with dynamic array
I have a table listing employees and the dates they have worked on a specific team, which I use to generate a roster of who should be selected next for that team. I'm trying to conve...
=SORT(HSTACK(UNIQUE(TOCOL(D4:L9,3,1)),BYROW(UNIQUE(TOCOL(D4:L9,3,1)),LAMBDA(x,MAX(INDEX((x=D4:L9)*D3:L3,))))),2,1)
With Office 365 or Excel for the web you can try this formula which uses your MAX(INDEX(... solution.
=SORT(HSTACK(UNIQUE(TOCOL(D4:L9,3,1)),BYROW(UNIQUE(TOCOL(D4:L9,3,1)),LAMBDA(x,MAX(INDEX((x=D4:L9)*D3:L3,))))),2,1)
With Office 365 or Excel for the web you can try this formula which uses your MAX(INDEX(... solution.
It works! You just saved me probably 2 weeks of banging my head against the wall, using 5 formulas I wasn't familiar with.