Variable range addresses for use in array functions
- From: "NickCory" <nick.cory@xxxxxx>
- Date: 11 Sep 2006 10:32:12 -0700
Hi,
I want to perform operations on address ranges, such as
MAXA(Value1:Value2), in which the range addresses themselves are
variables, the results of other operations.
There is no problem returning the range addresses using functions such
as CELL or ADDRESS(...) but the returned values don't seem to want to
plug into the next function.
For example, I use the formula
=ADDRESS(VLOOKUP(Pos_MinRear;Synopsis!$D$103:$G$108;4);3;;;"Synopsis!")
to return the string
'Synopsis!'$C$103
and a similar formula to return
'Synopsis!'$C$105
from which range I want to then find
MAXA('Synopsis!'$C$103:'Synopsis!'$C$105)
I'm sure there is a simple solution I have overlooked. Who can give me
a leg up with this?
regards
NC
.
- Follow-Ups:
- Re: Variable range addresses for use in array functions
- From: Jim Cone
- Re: Variable range addresses for use in array functions
- Prev by Date: Re: How can I sort a column by the last positions of each cell
- Next by Date: Re: CompareValues
- Previous by thread: Re: How can I sort a column by the last positions of each cell
- Next by thread: Re: Variable range addresses for use in array functions
- Index(es):
Relevant Pages
|
