# Show where max value came from

1. ## 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. ## 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.

2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
6) Click on "Close this window"

3. ## 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. ## 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))

5. ## 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

6. ## Re: Show where max value came from

Try this in AH2:

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

7. ## Re: Show where max value came from

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

8. ## Re: Show where max value came from

Happy to help. Thanks for the rep!

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

#### 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