Offset + Median Function

[matman]

I have a list of numbers from cell A1 to DD1, each cell representing a month.

I need to be able to calculate the median of any number of these cells by the use of a variable cell e.g B1, but always starting at A1

For example if B1 was 10 the result would be =median(A1:J1).

I'm sure that OFFSET can be used but I just can't it to work.

Many thanks

 

[tactps]

=MEDIAN(A1:OFFSET(a1,0,B1-1))

 

[just_jon]

Would that be --

=MEDIAN(A1:INDEX(A1:DD1,0,B1))

 

[matman]

Thanks guys,

I've now also used

=median(offset(A1,0,0,1,B1))