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

Hi Barb

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


--
Regards

Roger Govier


"Barb Reinhardt" wrote in
message ...
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