MAX #, display name

Giganews Newsgroups
Subject: MAX #, display name
Posted by:  fastballfreddy (
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


fastballfreddy's Profile:
View this thread: