Offset Question

[Guest]

I have the following OFFSET formula in a named range

=OFFSET('Summary Data'!$D$2,0,0,LASTROW-30)

I want to modify it as follows

'Summary Data'!$D$2 ->

'Summary Data'!$D$ & lastrow - 30
If LASTROW - 30 >=2, LASTROW-30, 2

I'll need other similar things for the rows up or down, etc. I'll get to
those as I need them.

Thanks

 

[Roger Govier]

Hi Barb

Maybe
=OFFSET('Summary Data'!$D$2,0,0,MAX(2,LASTROW-30))

 

[Roger Govier]

Hi Barb

Maybe
=OFFSET('Summary Data'!$D$2,0,0,MAX(2,LASTROW-30))