Active Leaderboard in Google Sheets (Score)

I need help creating a leader board where H1-3 Is The first,second,third place in score from b1-9 and I1-3 is the name of the person from a1-9. can anyone help

7

1 Answer

try:

=QUERY(A1:B9, "select B,A order by B desc limit 3", 0)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Elena Rostova

Elena Rostova

Lead Health, Wellness & Medical Journalist

Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.

Share this article
Twitter Facebook Pinterest