Google Sheets Tutorial for Sports Science: Interactive Leaderboards

Adam: How could I seperate males and female in a click of a button without making a new leaderboard

copy and past doesnt work. The reverse sort doesnt work. rank numbers are not in ascending or descending order. I changed the data ranges. used true or false or nothing. only my first set of metrics works.

can you show us how to simulate games and seasons through google sheets?

This is really awesome, thank you!

Please, before begin with the process, start by showing the results, in this way is easier to follow you

Hey Adam thanks for the amazing content this is fantastic! Did you ever make the part 2 for this?

I want to be able to rank the athletes on a specific date (so I don’t have my fastest athlete take up the top 10 spots for example).

Thanks in advance!!

NICE!

Adam, these tutorials are awesome. Keep up the great work. Question for you: What if the column you are pulling data from contains text? Is there a way to modify SORTN() to ignore cells with text values? Thanks

Hi Adam,

Love your stuff! I just had two questions regarding the leaderboards that I've run into:

1.) Is it possible to do a tie? Where instead of having athletes that have the same testing value pop up as 9 & 10, they pop up as T-9, T-9?
2.) When recording broad jumps into the chart, I have had issues with the double digit inches values not sorting accurately. Seems to prioritize the 1st number ( 6'2" would be greater than 6'11" because 2 is greater than 1). Have you ever run into this? Is there a solution?


Thanks!

Does this not work if the data is calculated from a formula as well?

For example, I have 3 jump columns with another column taking the MAX, but when I reference the MAX column, it pulls the names and dates but not the value.

Awesome Adam, thanks so much! Wouldn't it be better to format the data sheet as a tabel so it takes in everything you enter later, reflecting itself in the leaderboard?

Thanks for this great tutorial.
I will definitely use these tips in my google sheets.
Thanks again Adam ;)