How to display tie winners?

In H21:H25, you have (an unlikely??) scenario - 5 tied results. On what basis do you want three winners to be selected?

The first 3, in order of appearance? Something else?

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks

There was rather a lot going on in your sheet.... and (unless I am mistaken!!) this is a bit more complicated than you think.

You need to decide how many people can share the prize. Ideally it will be 3, but can be more (many more), depending on ties. If 2 tie for 1st place and 1 for 3rd, the two share $1000 and the 3rd gets $300.

I may have overcomplicated this, but the attached sheet (built from scratch, not your sheet) might do what you want. It covers all the scenarios. I am not sure if it is possible (or desirable) to do this in one neat formula. My suggestion is that the intermediate steps (rows 9-16) could be hidden, or on another sheet.

Firstly, though. see if this sheet covers all of you possible scenarios.

Thats not a row. That's a diagonal. Is that really what you meant???

You said: "do you know an easier way to display tie players' names?"

Well, obviously - NO - otherwise I would have done so!! I wouldn't have given you an hour of my life to do it that way if I had seen a way to do it in a minute.

I am certainly NOT going to give you more of my time to look at providing an alternative layout until you actually look at it and tell me if it is providing the expected results. You can not have looked at it in any detail (if at all) as there was a mistake in the formula (now corrected) which led it to give the wrong result!

Additionally, in your original data you have 3 columns available per place. How would you fit 5 ties for 1st place into that space (a scenario which you said could happen and which I modelled into my answer)?

thank you Glenn
I did read your first book1 file, it was showing the same tie names. I've tried to learn and mimic your instructions, but am not at that level yet, so don't know how to use it to adapt to my sheet.
this new book1 works well, it does display "next" ties players names.
I will reorganize my sheet in a way to adopt your solution. It will only take more spaces or will need to create another sheets
because i'll have 6 games total, and each game will have around 140 players

i was trying with if fucntion (see formula in F34) and then if there is way to just display the next ties players in a cell next to another. If there are more than three #1, then no need to display No#2 or No#3, just display the No#1 ties players names. etc
I assume that will be complicated formula...

many thanks and regards
txt007