| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MAX #, display name
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If..display "0", if greater than... display actual | Excel Discussion (Misc queries) | |||
| how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box | New Users to Excel | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Threaded Mode
