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!
|