Dear, Thanks for your comment! The ideas described here can be considered a basic leaderboard algorithm. It uses a formula (ROW()) and sorting to rank participants. Algorithm: 1. Making a Base Excel Dataset to Create a Leaderboard 2. Inserting ROW Function 3. Modifying ROW Formula 4. Sorting Performance Values in Excel to Create a Leaderboard However, you can easily make it dynamic with the help of the Excel VBA event procedure. Please check the following: www.exceldemy.com/wp-content/uploads/2024/05/Dynamic-Leaderboard-in-Excel.gif You can download the improved file: www.exceldemy.com/wp-content/uploads/2024/05/Dynamic-Leaderboard-in-Excel.xlsm
why you make a small thing to much complicated, there is a very simple way, what you want to show in that, using the function Row and this can be done very simple all this what you explained......
Dear, Thanks for your feedback! You are right. There might be other ways to create simple leaderboards. It would be great if you share your ideas. All viewers will find it helpful.
For algorithm
Dear, Thanks for your comment! The ideas described here can be considered a basic leaderboard algorithm. It uses a formula (ROW()) and sorting to rank participants.
Algorithm:
1. Making a Base Excel Dataset to Create a Leaderboard
2. Inserting ROW Function
3. Modifying ROW Formula
4. Sorting Performance Values in Excel to Create a Leaderboard
However, you can easily make it dynamic with the help of the Excel VBA event procedure. Please check the following: www.exceldemy.com/wp-content/uploads/2024/05/Dynamic-Leaderboard-in-Excel.gif
You can download the improved file: www.exceldemy.com/wp-content/uploads/2024/05/Dynamic-Leaderboard-in-Excel.xlsm
why you make a small thing to much complicated, there is a very simple way, what you want to show in that, using the function Row and this can be done very simple all this what you explained......
Dear, Thanks for your feedback! You are right. There might be other ways to create simple leaderboards. It would be great if you share your ideas. All viewers will find it helpful.