Tie-Breaking Question (Using Index/Match/Large)

[FiggyDad]

I am trying to rank the top 5 incident categories for calls to our help desk for each school in our district. I've trying to figure out how to list the other incident categories when a school has a tie. For example, on line 4, School B has Call Issue listed for #1, #2 and #3 because there was a three-way tie for 15 incidents each. It should have listed Call Issue, Chromebook-Broken and Information Provided.

The formulas I am currently using are as follows:

Cell B4: =INDEX($M$1:$GF$1,MATCH(LARGE(M4:GF4,1),M4:GF4,0))
Cell C4: =INDEX(M4:GF4,MATCH(LARGE(M4:GF4,1),M4:GF4,0))
Cell D4: =INDEX($M$1:$GF$1,MATCH(LARGE(M4:GF4,2),M4:GF4,0))
Cell E4: =INDEX(M4:GF4,MATCH(LARGE(M4:GF4,2),M4:GF4,0))

Etc... There are 172 different categories (which in the example begin on column M) currently so the spreadsheet goes on and on.

Thank you and I hope I can get this resolved as I'm bashing my head against the wall to figure this one out.

 

[Fluff]

How about for B4

=INDEX(SORTBY($M$1:$GF$1,M4:GF4,-1),,1)

and just change the final 1 to 2 for col D etc.
And then for C4

=INDEX(SORT(M4:GF4,,-1,1),,1)

 

[FiggyDad]

That is exactly what I was looking for, so simple too! Thank you for your expertise, that was fantastic.

 

[Fluff]

You're welcome & thanks for the feedback.