+ Reply to Thread
Results 1 to 2 of 2

Obtaining the header of a table according to the Max value in last row of a table

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Obtaining the header of a table according to the Max value in last row of a table

    Hi
    Was just wondering whether there the was a function in excel that enables one to check what the biggest value at the last row of a table and return the table header.
    Also, for my data, it is possible that the maximum value appears more than once, in which case i would like to return the headings of each of these values.

    thanks in advance!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Obtaining the header of a table according to the Max value in last row of a table

    Maybe something like this...


    Data Range
    A
    B
    C
    D
    E
    F
    1
    This
    That
    Other
    -----
    Max
    Headers
    2
    58
    43
    51
    73
    This
    3
    73
    50
    73
    Other
    4


    This formula entered in E2:

    =MAX(A3:C3)

    This array formula** entered in F2:

    =IFERROR(INDEX($1:$1,SMALL(IF(A$3:C$3=E$2,COLUMN(A3:C3)),ROWS(F$2:F2))),"")

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.

    Copy down until you get blanks.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  2. [SOLVED] Extract the column header given the row header and highest value in a subset of a table
    By pguarino in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2013, 02:05 AM
  3. Obtaining values from a multi-leveled table.
    By Eliat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-04-2013, 08:11 AM
  4. Vlookup return the header name of table (Table of 4 column x 55 rows)
    By sanpat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2013, 11:23 PM
  5. Replies: 0
    Last Post: 09-25-2012, 03:04 PM

Tags for this Thread

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