Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have a problem I can't seem to solve. Columns B through G contain data. Row 4 contains a name. Other rows contain numerical data. I'm trying to figure out how to create a formula in Row H that shows the value in Row 4 for the maximum of the row. For example, if B4 = Fred, C4 = Joe, D4 = Sally, and if B5 = 1, C5 = 8, and D5 = 36, then H5 would be "Sally". Any ideas? Submitted via EggHeadCafe - Software Developer Portal of Choice How to Annotate Images from a database in a web page http://www.eggheadcafe.com/tutorials...images-fr.aspx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Question | Excel Discussion (Misc queries) | |||
array question | Excel Worksheet Functions | |||
another array question | Excel Worksheet Functions | |||
Array Question | Excel Discussion (Misc queries) | |||
Array Question | Excel Worksheet Functions |