Need Help with getting MAX Value in range and Match the column Title.
Hi,
I am trying to make a simple Spreadsheet, in which i want to get the maximum value of target column from the range for each person. and for the same i want to get the month which he/she got the maximum targets. same is the column title. Please see the attached spreadsheet.
Thanks for the Help
Regards.
PS. I am using MS Office 2007
Last edited by mudassardp; 12-20-2020 at 03:58 AM. Reason: The problem is Solved.
Please try at C8
=LOOKUP(2,1/(F8:N8=B8)/($F$7:$N$7=$F$7),$F$6:$N$6)
Non-arrray formula in B8:
=SUMPRODUCT(MAX(($F$7:$N$7=$F$7)*$F8:$N8))
Non-array formula in C8:
=INDEX($F$6:$O$6,MATCH(1,INDEX((($F$7:$O$7=$F$7)*($F8:$O8=B8)),0),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
Thank you so much Glenn. I have another complex database and i tried your solution into it, and its worked like a charm. you guys are awesome. Thanks again
Thanks for the quick reply and your solution Bo_Ry, this solution worked for me for the simple spreadsheet. the other solution by Mr.Glenn is also worked for me for more complex database. Thanks both of you.
B8 cell , array formula , drag down
C8 cell , array formula , drag downHTML Code:
HTML Code:
Thanks wk9128, for the reply. The problem has been Solved already by using Mr.Glenn Kennedy's Solution. Thanks anyway.
Last edited by AliGW; 12-20-2020 at 04:33 AM. Reason: PLEASE don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks