Excel formula for variable number of columns

[pjindent]

I am looking to place a formula which will look like this:

=min("A2:?2"), where ? depends on "number of columns". If number of columns is 4, then it should be D, E or Z. Number of columns is specified as an integer in range("B2").

I do not want to do it in a macro, want to do it in the formula.

I have done this before, but can't quite remember. I have tried:

=min(range(cells(1,2),cells(1,2+B2))), but does not work.

Help would be appreciated.

 

[gsistek]

Try
=MIN(OFFSET(A2,0,0,1,B2))

If number of columns is 4, then it should be D, E or Z.

Why is it D, E or Z? Wouldn't it be D?
Also, B2 is in the range A2:D2, etc. Is this intentional?

 

[pjindent]

that works.
Thanks for bearing with multiple mistakes in my question.

I am rewording the question so others can benefit. Answer to this question is in the previous message.

I am looking to place a formula which will look like this:

=min("A2:?2"), where ? depends on "number of columns". If number of columns is 4, then it should be D. Number of columns is specified as an integer in range("A3").

I do not want to do it in a macro, want to do it in the formula.

I have done this before, but can't quite remember. I have tried:

=min(range(cells(2,1),cells(2,1+A3))), but does not work.