Good morning,
I am looking for a formula that will identify which column has the maximum value and then it will return the name of that title.
See attached for an example.
Thank you!
Good morning,
I am looking for a formula that will identify which column has the maximum value and then it will return the name of that title.
See attached for an example.
Thank you!
Last edited by PaddyP; 12-03-2020 at 09:01 AM.
In H3, copied down:
=INDEX($D$2:$G$2,MATCH(MAX(D3:G3),D3:G3,0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
This is fantastic. Thank you Glenn!
You're welcome & thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks