Entering value from adjacent cell into Max arguement

[Cameron]

Hello,

I am trying to the MAX function such that it recgonizes
the value from an ajdacent field.

For example:

Cell A1: containes the info "J240" (using address
function).

cell A2: I want to have the fucntion =MAX(J1A1)) where
A1 is replaced by J240 and it finds the max value in
A1:J240.

Thanks,

Cameron

 

[Bob Phillips]

Hi Cameron,

You would use

=MAX(INDIRECT("A1:"&A2))

but be careful. If you use your example, J240, you will get a circular
reference as the range being MAXed includes the cel used to determine that
range.

 

[Peter Atherton]

-----Original Message-----
Hello,

I am trying to the MAX function such that it recgonizes
the value from an ajdacent field.

For example:

Cell A1: containes the info "J240" (using address
function).

cell A2: I want to have the fucntion =MAX(J1A1)) where
A1 is replaced by J240 and it finds the max value in
A1:J240.

Cameron

=MAX(J2:INDIRECT(a2))

Peteratherton

 

[Aladin Akyurek]

=MAX(J1:INDEX(J:J,A1))