I can't figure this out. My data looks like this
Lew Bill Bob
$14,875.00 $6,975.00 $750.00
$19,550.00 $0.00 $7,750.00
$14,350.00 $0.00 $27,425.00
$48,775.00 $6,975.00 $35,925.00

I want a function to find the MAX value of ALL those numbers ($48,775)
and return the name in row 1. (Lew in this case).
The function I see most in this new group seems to only work for
numbers in single rows or single columns.
=INDEX(1:1,MATCH(MAX(A2:K2),A2:K2,FALSE))
Where as my max number could be in any one of different rows or
different columns. I suspect I need an array formula but not sure how
to do it.
Thanks for the help