| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I make array position A(12) into a variable A(12*n) ?
I am constantly adding data to my array and want formulas that can expand
with the data. Data is added by weeks. The first number is at A1 how can I put in a formula that it needs to sum A1, A12,A24,depending on the week? Such as A(1*n) where n is the week number. Thanks....Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable column to fixed array | Excel Worksheet Functions | |||
| Make array formulay to round a number then subtract 10 from it | New Users to Excel | |||
| How to make array of noncontig cells for SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| use a variable array in a formula | Excel Discussion (Misc queries) | |||
| Array | Excel Worksheet Functions | |||
Threaded Mode
