Index of Max Cell
You were right. Some of my arrays weren't matching after I dragged the
formula across. Thanks!
"PhilosophersSage" wrote:
Nate,
check to ensure that the $EE$1:$HP$1 or $EE3:$HO3 are the exact for each
section, even if it is you may want to try removing one or both $ to check if
the absolute address is interfiering with formula. Excell is very finicky
about addressing in an index only have the $ that you need, if it could be
either way but it seems like it does not matter remove it, that seems to make
things work for me.
"Nate" wrote:
I'm trying to figure out how to return the cell location of the value that is
returned by my max value formula. My max value formula is
=MAX(EE3,EO3,EY3,FI3,FS3,GC3,GM3,GW3,HG3). I couldn't do an array, because I
only wanted the max value from January for each account, even though
Jan-Sept. is displayed on the spreadsheet. My Index formula is
=INDEX($EE$1:$HP$1,MATCH(MAX(EE3,EO3,EY3,FI3,FS3,G C3,GM3,GW3,HG3),$EE3:$HO3,0)),
which seems to work for January, but when I drag it to the other months it
doesn't seem to be functioning correctly. Any suggestions would be greatly
appreciated.
|