Thread: Dynamic 2D Array
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_53_] ExcelMonkey[_53_] is offline
external usenet poster
  
Posts: 1
Default Dynamic 2D Array
Sorry I posted to the wrong group. But I answered my own question.

=OFFSET('$B$2,0,0,COUNTA('B$2:$B$65536),COUNTA('$B $2:$IV$2)

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote