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
Bookmarks