LinkBack URL
About LinkBacks
Hi,
Could any one suggest me with a formula to get maximum number output as Header and example attached.
Thanks,
Hi,
Could any one suggest me with a formula to get maximum number output as Header and example attached.
Thanks,
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
Click the * below on any post that helped you.Originally Posted by Jacc
I3and drag down
=indirect(char(67+match(max(d3:g3),d3:g3,0))&2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I always forget when I add rows/columns in sample files. I updated my formula.
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.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks a Lot. It works
In b3:
=index($d$2:$g$2,match(max(d3:g3),d3:g3,0))
a b c d d b a c
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks