row number within a formula
 

I am trying to use the row number within a formula.

For example, instead of
=MIN(A2:A25)

I would need to incorporate ROW(A25) into the formula.

Something like this:
=MIN(A2:A"ROW(A25)")
although this syntax is incorrect.

Thanks!

row number within a formula
 

On Mon, 15 Jan 2007 07:43:00 -0800, Charles
wrote:

I am trying to use the row number within a formula.

For example, instead of
=MIN(A2:A25)

I would need to incorporate ROW(A25) into the formula.

Something like this:
=MIN(A2:A"ROW(A25)")
although this syntax is incorrect.

Thanks!


Here's one way:

=MIN(OFFSET(A2,0,0,24))
--ron

row number within a formula
 

This would be a two step process:

1. Somewhere in the worksheet (e.g. B1) enter ="A2:A" & Row(A25)

2. Where you want the result returned enter =MIN(INDIRECT(B1))

Regards

Paul


Charles wrote:
I am trying to use the row number within a formula.

For example, instead of
=MIN(A2:A25)

I would need to incorporate ROW(A25) into the formula.

Something like this:
=MIN(A2:A"ROW(A25)")
although this syntax is incorrect.

Thanks!