LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell reference problem Jim Olsen Excel Worksheet Functions 4 October 31st 05 05:47 AM
how to include a cell reference that is contained in a cell withi. dutchinny Excel Worksheet Functions 5 October 24th 05 01:07 AM
How do I leave formula cell blank if 2nd reference cell is empty? Liana S Excel Discussion (Misc queries) 2 October 21st 05 04:38 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Flexible Cell Reference Brandt Excel Discussion (Misc queries) 5 June 2nd 05 10:23 PM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"