Hello all,
Excel noob here.
I want to insert the adjacent text-in-a-cell of the largest value of a column. I know that it's a general problem and there's a number of solutions in the web addressing it. Although I've followed up on them specifically, my answer still returns #N/A.
For better clarification, I've attached the sample worksheet here.
Any help would be great, thanks in advance!
=INDEX(B:B,MATCH(MAX(C:C),C:C,0
Try the above formula
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Works like a charm! Thanks a lot Siva
or
=VLOOKUP(MAX(C:C),CHOOSE({1,2},C:C,B:B),2,0)Please Login or Register to view this content.
This worked too!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks