I have 10 cells w/ various amounts of numbers. I want a formula to find
the max number and instead of showing that amount, have it show the name
that goes w/ that amount. Do I use the IF and MAX function?
names in A1, A2, A3 and so on
numbers in B1,B2,B3 and so on
thanks,
--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:
http://www.excelforum.com/member.php...o&userid=33986
View this thread:
http://www.excelforum.com/showthread...hreadid=539672