Thread: Dynamic range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
pelachrum pelachrum is offline
external usenet poster
 
Posts: 1
Default Dynamic range


actually one followup question...

is there a way to make the
"=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B:$B), 1)" formula work when the
field that calculates the rest actually sits in the same column, on top,
in field B1 to be specific?


--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile: http://www.excelforum.com/member.php...o&userid=35962
View this thread: http://www.excelforum.com/showthread...hreadid=557594