Offset Question
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
|