Results 1 to 4 of 4

Return Column Headers based on row rank with duplicate values in row

Threaded View

carlwin Return Column Headers based... 01-30-2013, 06:29 PM
micope21 Re: Return Column Headers... 01-30-2013, 08:25 PM
benishiryo Re: Return Column Headers... 01-30-2013, 10:49 PM
carlwin Re: Return Column Headers... 01-31-2013, 12:24 AM
  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    29

    Return Column Headers based on row rank with duplicate values in row

    Hi,

    I need a means of ranking the highest 10 numbers in a row with duplicates where the value returned is not a rank order but rather a rank of the column titles corresponding to the rank of the row value.

    Index match formulas like: =INDEX($B$1:$T2,1,MATCH(LARGE($B2:$T2,1),$B2:T2,0)) don't do the job because they return the first column title for each duplicate value, rather than the actual column title of each duplicate value.

    Please find an example spreadsheet attached.

    Many thanks,
    Carl.
    Attached Files Attached Files
    Last edited by carlwin; 01-31-2013 at 12:24 AM.

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