Results 1 to 7 of 7

Need the Maximum Output as Header

Threaded View

  1. 09-09-2014, 01:17 PM #2
    Speshul
    Speshul is offline
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Need the Maximum Output as Header

    Try this one:


    =OFFSET($D$2,0,MATCH(MAX(D3:G3),D3:G3,0)-1)
    Last edited by Speshul; 09-09-2014 at 01:26 PM.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find value in column with header and output variable in same row, different column
    By ggibs7 in forum Excel Programming / VBA / Macros
    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. How do you adjust the maximum characters in a excel header?
    By Brandon in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1