Report

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

Ask a question Mani - Last answered on Oct 9, 2016 at 12:03 AM by Mani
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
Helpful
+0
plus moins
=INDEX(A2:A21,MATCH(MAX(B2:B21),B2:B21,0))
Mani- Oct 9, 2016 at 12:03 AM
Thank you so much...I really appreciate your quick response...

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!