Creating a rank sheet

New Contributor

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. 

3 Replies


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.


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.



I know I don't know anything (Socrates)


Was the answer useful? Mark them as helpful!

This will help all forum participants.


This does not help
as I have already recommended to you, read the link and act accordingly.