Excel Question: Rank maximum based on multiple criteria - Aussie Stock Forums

Results 1 to 1 of 1
  1. #1

    Default Excel Question: Rank maximum based on multiple criteria

    I have a spreadsheet that lists per line products that have been purchased from a particular source and country.

    I have ranked the sources and the countries separately based on the total number of products purchased.

    I would now like to have a table that lists the Top sources and the the Top 2 countries for that source. I've got the top sources part but for the the life of me I can't figure out how to list the top 2 countries for those sources.

    Hoping someone can help or point me in the right direction.

    I've attached my test spreadsheet below.

    Attached Files

Similar Threads

  1. Excel Question
    By Smack in forum Software and Data
    Replies: 15
    Last Post: 4th-February-2012, 10:07 AM
  2. Value based fundamental investing question
    By Helliune in forum Medium/Long Term Investing
    Replies: 2
    Last Post: 8th-April-2010, 08:53 PM
  3. Stock selection criteria
    By wto23 in forum Trading Strategies/Systems
    Replies: 8
    Last Post: 1st-August-2007, 12:06 AM
  4. Trading and investing primers for rank beginners
    By doctorj in forum Trading/Investing Resources
    Replies: 9
    Last Post: 16th-July-2007, 08:09 PM
  5. Posting Rank (You)!
    By Bobby in forum General Chat
    Replies: 27
    Last Post: 30th-March-2006, 01:47 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Aussie Stock Forums