Create a dynamic dashboard to show rank, team, and score by month

[jholiday78]

Hi there,

I'd like to try something new in a dashboard and have the ability to select from a drop down the month to show me the ranks in order, teams, and scores. Having a bit of trouble figuring out data validation and how to display what I want it to on my dashboard.

Can anyone help with the formulas I would use? My information is pulling into the "Formulas" tab and i'd like to display on the "dashboard" tab.

Thanks for the help in advance. I have watched several You tubes but nothing covers what I am trying to do.