ExcelBanter - View Single Post - Value of cell to determine range in MAX Function

Biff, not Bill.

(I'm here to help <vbg.)

wrote:

Thanks Bill, but I actually want the range to be from the cell directly
above, to the row indicated by the value in the Q column.

For example if Q21=5 and Q30=22, then

K21 range needs to be from K20:K5 and
K30 range needs to be from K29:K22.

I can't seem to get this to work.

Regards,

Geoff.

--

Dave Peterson