Thread: Named Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KC Excel Qns KC Excel Qns is offline
external usenet poster
 
Posts: 4
Default Named Array

Can someone please help me out.

I would like to use a Name to contain 12 values, either 0s or 1s.

If I want to compute YTD June 2009, this name will contain
1,1,1,1,1,1,0,0,0,0,0,0 and multiplied by a row of 12 months data. I
am thinking of using array.

Likewise, if I want to compute Rest of Year 2009, this name will
contain 0,0,0,0,0,0,1,1,1,1,1,1 multiplied by a row of 12 months
data.

Regards,