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
10 answers
Hi William,
I've reattached your workbook with what I think is what you're after (I hope anyways!) and instructions.
Hope this helps!
-Tracy