+ Reply to Thread
Results 1 to 2 of 2

Return Top Ten values when condition is met?

  1. #1
    Registered User
    Join Date
    01-26-2005
    Posts
    18

    Return Top Ten values when condition is met?

    hi,

    im sure ive done this before but sometimes i just cant get my brain to work

    ive got a list of data say 10 columns by 500 rows.

    in column E i have the country name i.e "USA".

    in column H i have a value i.e "$10,000".

    I want to return the 10 highest values in Column H where Column E = "USA".

    Ive got the data in one worksheet "RawData" and i will have multiple worksheets one for each country, i.e "USA".

    Thanks for any help.

  2. #2
    Forum Contributor
    Join Date
    04-30-2004
    Posts
    122
    You can try this equation (entered as an aray by pressing shift/control/enter)

    =LARGE(IF("USA"=$E$1:$E$100,$H$1:$H$100),ROWS($A$1:A1))

    Then copy and paste down to row 10

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1