+ Reply to Thread
Results 1 to 8 of 8

Show where max value came from

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 2010
    Posts
    103

    Show where max value came from

    Hello all good morning here,
    Looking for some help to show where a max value came from if its possible.
    For example
    1: I have a header row in A1:A10 with a bunch of different names
    2: A2:A10 contains a bunch of different dollar values
    3: in A11 I run a formula =max(A2:A10) and is tell me A6 is the highest value at 5 dollars

    I want to be able to show what that value matches to so in A12 i want it to say the header name to match where it got the max formula value. how can i do this?

    Did i explain this correctly?

    Thanks for you help

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: Show where max value came from

    I have a header row in A1:A10
    Rows go horizontally. A1:A10 is a column (column A) which is vertical.

    Also, you say that you have data in A2:A10 and you want to find the header of the highest value. Since there's only one column, the header of the highest value would be in A1.

    Did i explain this correctly?
    Unfortunately not. I recommend creating a small representative sample workbook along with the desired results (which you can enter manually) based on that sample data.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: Show where max value came from

    You know what your right... i really was not thinking it through when i was typing. I see my horrible errors... not sure what i was thinking Ill send attachment

  4. #4
    Registered User
    Join Date
    06-28-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    19

    Re: Show where max value came from

    I'm assuming you meant you have A1:A10 with names and B1:B10 with dollar values and A11 has the max value. The formula below should work.

    =INDEX(A1:A10,MATCH(A11,B1:B10,0))

    If I'm assuming wrong please follow falcondude's advice of uploading an example for us to help you

  5. #5
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: Show where max value came from

    Ok i have attached an example.
    You can see in AG where my max formula is
    i want to show in AH what header is associated with that value. How would i do that whit a formula

    Thanks
    Attached Files Attached Files

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: Show where max value came from

    Try this in AH2:

    =INDEX(A$1:AF$1,MATCH(AG2,A2:AF2,0))

  7. #7
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: Show where max value came from

    It works. Greatly appreciated. Thanks for your patience in my ignorance

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: Show where max value came from

    Happy to help. Thanks for the rep!

+ 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: 2
    Last Post: 05-29-2017, 11:03 AM
  2. Replies: 2
    Last Post: 08-14-2014, 06:03 AM
  3. [SOLVED] One TextBox Show Column and the other show Cell address Solved by : ragulduy
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-26-2014, 05:17 AM
  4. [SOLVED] how to add counter in msgbox to show remain times the message will show vba code
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2013, 06:46 AM
  5. Replies: 0
    Last Post: 06-15-2011, 10:36 AM
  6. Show Data Lables show Amount & Persentage at the same time
    By ComcoDG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2008, 04:54 AM
  7. Replies: 1
    Last Post: 04-11-2008, 02:02 AM

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