Creating a rank sheet

[Adam_Hanna]

Hello, I host esports tournaments and have been using excel to manage my scores however I want to take the stream to the next level by having real time scores show after each match but I can't seem to find the right set up or formula to replicate the leading team without the name following the number. 

[#2]

@Adam_Hanna 

a small example inserted in the photo.

With your permission, next time or if that's not what you are looking for,

I recommend that you read this link carefully, it will help everyone, especially you.

Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

Please include your Excel version, sample file, and a bit of context to help others answer your question

I would be happy to know if I could help.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.

[#3]

This does not help

[#4]

as I have already recommended to you, read the link and act accordingly.