Closed Thread
Results 1 to 2 of 2

Looking to return column title of second largest value

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Collegeville, PA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Looking to return column title of second largest value

    I cannot seem to write the formula that would return the column header of the second largest value.

    here is my data:

    ETF-A ETF-B ETF-C ETF-D ETF-E ETF-F ETF-G ETF-H ETF-I ETF-J
    10 10 11 11 27 35 26 27 27 36

    I figured out how to get the max value's header using the formula =INDEX($C$2:$L$2,0,MATCH(MAX(C3:L3),C3:L3,0)) (which returns ETF-J) but I cannot seem to create a new formula that would return ETF-F, the second largest value.

    Any advice would be much help thanks !!!!!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,671

    Re: Looking to return column title of second largest value

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Returning column title of the second largest value
    By JoJenkins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2014, 06:06 PM
  2. Return the Title of a column if the column is the highest column with data
    By williamspage in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-22-2013, 10:05 AM
  3. Return name with largest value in multiple column array
    By saslotteroy in forum Excel General
    Replies: 4
    Last Post: 01-24-2012, 06:15 PM
  4. Replies: 4
    Last Post: 10-14-2011, 12:34 AM
  5. Find Largest and Return Column Name
    By Tom321 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2006, 01:15 PM

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