Report

Get a value from Col A based on the max value found in Col B [Solved]

Ask a question Mani - Last answered on Oct 9, 2016 12:03AM
Hello,

Get a value from Column A based on the max value found in Column B display in Column C.
I need to get value Jill in Column C.

Name Amount
John $228.50
Mike $690.00
Peter $2.50
Steve $172.00
Karla $51.45
Jill $6,416.96
Scott $107.25
Tony $491.00
Marlene $427.00
Yelli $4,155.75
Mark $3,422.78
Marvin $1,665.20
Tom $494.75
White $311.25
Brown $946.10
Black $108.50
Nat $5.00
Will $4,369.90
Luke $9.00
Jordon $96.85

Thanks & Regards
Mani
See more 
Helpful
+0
moins plus
=INDEX(A2:A21,MATCH(MAX(B2:B21),B2:B21,0))
Mani- Oct 9, 2016 12:03AM
Thank you so much...I really appreciate your quick response...
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!