8 Replies Latest reply on Aug 16, 2012 9:18 AM by William Weaver

    How do I convert a table to a Top 10 list?

    William Weaver

      I have created a table that displays the total number of trips taken between local cities during the first half of 2012. Now, I need help converting the table into a top 10 city to city combinations. At first, I thought the task would be easy but, despite repeated attempts, the best that I can do is list the Top 10 destinations for each origination city or vice versa.

       

      I have attached a packaged workbook of my efforts if anyone wants to give this challenge a try.

       

      Thanks - William