Forum Discussion

Copper Contributor

Jun 25, 2024

Solved

INDEX MATCH with MAXIFS?

Hey all. I'm working on some waiting lists, I'm a bit stuck on a formula that indentifies the longest waiter in a table who is still waiting. I've got the first bit working, identifying the longe...

excel

Formulas and Functions

HansVogelaar
Jun 25, 2024
Kirk-Anderson

Try

=INDEX(Apr24Apr25[Forename], XMATCH(1, (Apr24Apr25[PW]=MAXIFS(Apr24Apr25[PW], Apr24Apr25[Status], "Waiting"))*(Apr24Apr25[Status]="Waiting")))