Easy one..?

[Gromit]

Hi,

What I was trying to do was to come up with a way of changing th
reference range for a MIN function in any column given a variabl
number of rows given by a named range "NoProjects".

I slept on it and came up with a much cleaner solution that didn't nee
the column ref.

MIN(A1:OFFSET(A1,NoProjects-1,0))

Thanks for the ideas,

Gromi

 

[Ron Rosenfeld]

Hi,

What I was trying to do was to come up with a way of changing the
reference range for a MIN function in any column given a variable
number of rows given by a named range "NoProjects".

I slept on it and came up with a much cleaner solution that didn't need
the column ref.

MIN(A1:OFFSET(A1,NoProjects-1,0))

Thanks for the ideas,

Gromit

Sometimes it pays to take a step back and look at the problem again. Glad you
found a simpler solution.


--ron