LinkBack URL
About LinkBacks
Hi,
I need formula in "I4" which calculate score number mentioned ( C3 to H3) as per the value % figure available in column C4 to H4.
So in attached excel 92% included against 2(E3) so I need 2 in column I4.
Thanks,
Rahul
Hi,
I need formula in "I4" which calculate score number mentioned ( C3 to H3) as per the value % figure available in column C4 to H4.
So in attached excel 92% included against 2(E3) so I need 2 in column I4.
Thanks,
Rahul
Last edited by rchure; 04-17-2019 at 07:21 AM.
will there only be 1 percent in the row -
=INDEX(C3:I3,MATCH(MAX(C4:H4),C4:H4,FALSE))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank You!!
Its work perfectly..
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks