+ Reply to Thread
Results 1 to 3 of 3

Find three highest values on column A and print column B

  1. #1
    Registered User
    Join Date
    02-18-2013
    Location
    Rio
    MS-Off Ver
    Excel 2010
    Posts
    2

    Find three highest values on column A and print column B

    Hi,

    I am having an issue.
    I need to create a (or 3) function to find the top three values, in order, and return values from ther columns. For example:

    A B C
    pa 1 rj
    re 8 sp
    te 9 pr
    be 2 nn
    yu 3 pq

    The function would need to find the top 3 highest values on column B and return values from columns A and C of that row.
    So, the function would return:

    te 9 pr
    re 8 sp
    yu 3 pq



    Alreaqdy thinking about a possible problem, how to deal with ties?

    Many thanks!

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Find three highest values on column A and print column B

    See attached. Highlighted in yellow
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    02-18-2013
    Location
    Rio
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Find three highest values on column A and print column B

    Worked like a charm! Many thanks!

+ 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