+ Reply to Thread
Results 1 to 7 of 7

Need the Maximum Output as Header

Hybrid View

sriku Need the Maximum Output as... 09-09-2014, 01:04 PM
Speshul Re: Need the Maximum Output... 09-09-2014, 01:17 PM
oeldere Re: Need the Maximum Output... 09-09-2014, 01:22 PM
Speshul Re: Need the Maximum Output... 09-09-2014, 01:26 PM
MarvinP Re: Need the Maximum Output... 09-09-2014, 01:28 PM
sriku Re: Need the Maximum Output... 09-09-2014, 01:52 PM
AlKey Re: Need the Maximum Output... 09-09-2014, 01:30 PM
  1. #1
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,243

    Re: Need the Maximum Output as Header

    Hi Sriku,

    This might be simpler if you have your header range a Named Range and then use this formula:
    =INDEX(Header,MATCH(MAX(D3:G3),D3:G3,0))


    See the attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  2. #2
    Registered User
    Join Date
    04-27-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Need the Maximum Output as Header

    Thanks a Lot. It works

+ 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. Replies: 10
    Last Post: 08-01-2013, 06:25 AM
  2. [SOLVED] Copy a specific column data of filtered output without header
    By uvaidya in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-05-2012, 09:21 AM
  3. [SOLVED] Header of Maximum value formula
    By vij8y in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2012, 03:44 PM
  4. Header Name output
    By meetmhatre in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2012, 06:06 AM
  5. Replies: 1
    Last Post: 05-01-2006, 06:28 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