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

Ask a question Mani - Latest answer on Oct 9, 2016 12:03AM
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
See more 
moins plus
Mani- Oct 9, 2016 12:03AM
Thank you so much...I really appreciate your quick response...
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!