i'm trying to return the highest number from one column and match it to the corresponding name(text) from another column. i know the max function will return the highest number but i can't figure out how to match it to the corresponding text, example
john 45
john 50
john 65
mary 14
mary 75
i'm trying to write a formula to bring back the highest number from john's range without going into mary's range..john 65, mary 75, and i need to do this for the whole column
thanks hb
I did what you asked in the attachment file.
The formula in range E9 is an array formula.
If you want to edit, remember to press ctrl + shift + enter to do excel understand that is an array formula
Regards,
Antonio
Holy,
You can also use INDEX_MATCH combination:
=INDEX(A1:B5,MATCH(MAX(B1:B5),B1:B5,0),1)
will produce the corresponding name in Col A with Maximum value in Col B.
HTH
Myles
...constantly looking for the smoother pebble while the whole ocean of truth lies before me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks