Hi,

I built a spreadsheet with sales information for retailers in different regions. I am able to see actual sales and sales plan by month by selecting the month from a dropdown list. What I need is that every time I change the month, all the retailers are automatically sorted from highest to lowest sales volume. I tried with the Rank formula, but it doesn't do what I need.

Can someone help with this?