MAX #, display name

Giganews Newsgroups
Subject: MAX #, display name
Posted by:  fastballfreddy (fastballfreddy.27gaxm_1147028100.846@excelforum-nospam.com)
Date: Sun, 7 May 2006

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?action=getinfo&userid=33986
View this thread:http://www.excelforum.com/showthread.php?threadid=539672

Replies