| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Ranges in Array Formulas | Excel Worksheet Functions | |||
| Vlookup - using a cell to reference a named array | Excel Worksheet Functions | |||
| Use named ranges in array formula | Excel Worksheet Functions | |||
| Named range into an array | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
Threaded Mode
