Index and Match - Can I have 2 or 3 results show in one cell?

[Mel Smith]

Hello folks,

I use this formula: =INDEX(B4:B63,MATCH(MAX(H4:H63),H4:H63,0),1) to show the "top" performer and it works well but my question is, can it be adapted to show, say 2 or even 3 names who are equal "top"? When there are 2 equal, it always shows the first in the list and I would like to be able to show both names.

Thanks for your help, as always.

Mel

 

[Mel Smith]

Once again, Fluff, perfect!

Many thanks.

Mel

 

[Fluff]

You're welcome & thanks for the feedback.