Using data validation controls to pick from a list
In the dashboard example, you are going to pick sequential numbers from a list to order countries by medal rankings. In this exercise, you will be sorting the countries by total number of medals, but country rank in the Olympics is typically determined by the number of Gold medals per country. Ties are broken using silver medals, and then bronze medals.
This exercise is part of the course
Data Visualization in Google Sheets
Exercise instructions
- Change the rank using the drop-down menu so that the ranks are displayed in order for countries 1 through 5.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
