View Single Post
  #1   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) ?


What I want to do is to link to a value in column A, with the row
specified by the cell of highest value in column "D".

I want to do this by a single cell function. I'm thinking someting like


=Cell(1, row(Address(High(D:D))))

Obviously, this is just my thought up function... But is this possible
to do, and how would I code it?


--
dukof
------------------------------------------------------------------------
dukof's Profile: http://www.excelforum.com/member.php...o&userid=29084
View this thread: http://www.excelforum.com/showthread...hreadid=488127