Yes, Thanks!
That's was a good start.
Actually, I now found the offset function, which combined with this
will give what I was looking for:
=OFFSET(A1; MATCH(MAX(D:D);D:D; 0) - 1;0)
This will give me the value at column A, at the row specified with the
max value of column D.
If anyone know some alternative ways to code this function I would be
interested to know about them too.
Thanks a lot! :)
--
dukof
------------------------------------------------------------------------
dukof's Profile:
http://www.excelforum.com/member.php...o&userid=29084
View this thread:
http://www.excelforum.com/showthread...hreadid=488127