As a worksheet formula?

I put n in A1.

I put my numeric data in D1:D30
In E30, I put this formula:
=MAX(OFFSET(D30,-A1,0,A1,1))
It evaluated the same way as:
=max(d20:d29)

If I wanted the equivalent of:
=max(d21:d30)
Then I'd use a formula like:
=MAX(OFFSET(D30,-A1+1,0,A1,1))







wrote:

I've been trying to figure out how to get dynamic range selections.

I have a list of numbers in one column and in the adjecent column I
want it to give me the largest number in the previous n rows, where n
is a number in another cell. anyone know how this is or can be done?

--

Dave Peterson