View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dukof
 
Posts: n/a
Default can I reference a cell as someting like: cell(1, 1) ?


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