Previous Topic Next Topic

Top 10 in descending order

Closed
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Updated on Apr 14, 2018 at 08:02 AM
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Apr 17, 2018 at 01:38 AM
Hi guys,

I'm struggling to find a solution for this. There is a list that contains, time-frame as Q12016 up until Q42018, then cities as London, Paris etc and finally figures ranging from 1 to whatever next to each time-frame and city. In a separate tab I would like to be able to choose the city and the time frame from a drop down and have the top 10 highest figures listed in a descending order. I am able to create a drop down however not sure how to have the rest done. Any ideas perhaps? Thanks so much!

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 16, 2018 at 11:48 AM
Hi DG83,

The easiest thing to do would be to apply an autofilter found under the Data ribbon.
Using the drop down lists on the header you can select a (or more) city, a (or more) time-frames and for the third column you can select to sort in descending order.

Will that work for you?

Best regards,
Trowa
0
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018
Apr 17, 2018 at 01:38 AM
Thanks Trowa, will try this. In the meantime I have found a bit more manual workaround that did this but will try your best advice as well! Thank you a lot
0