Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 12:51 PM 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))))

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


  #2   Report Post  
Old November 25th 05, 01:34 PM posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default can I reference a cell as someting like: cell(1, 1) ?

Try using the match function to get the row number you need:

=MATCH(MAX(D),D,0)

Be aware that match gives the relative position in the array.

I'm not sure what you want to do with it however. I'm thinking that the
INDIRECT function might get you where you want to go.

If this isn't what you want, come back and clarify.

"dukof" wrote in message
...

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))))

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



  #3   Report Post  
Old November 25th 05, 03:25 PM 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; 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



Reply
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 06: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 12:33 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017