MAX function + condition
Hi again my friends!
I have a problem using MAX function combined with VLOOKUP... i attached the file here
I want the result to be "B" because 7 is the max from the numbers... and another result i want to be "C" cause those both letters go in 7...
hope you understand what i mean :D
Try
for column
Formula:
Please Login or Register to view this content.
For row
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
1.
=INDEX($B$1:$E$1,MAX(IF($B$2:$E$5=MAX($B$2:$E$5),COLUMN($B$2:$E$5)))-1)
2.
=INDEX($A$2:$A$5,MAX(IF($B$2:$E$5=MAX($B$2:$E$5),ROW($B$2:$E$5)))-1)
Enter with Ctrl+Shift+Enter.
Thanks a lot guys! From both worked!
Have a nice day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks