Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A user-defined function inputs several variable-length arrays.
It's task is to sum positive changes between all cells in some of its input arrays; while also summing negative changes in other input arrays. Example one, sum positive changes only in cells A1:An (offset by n cells). Ignore negative changes. And sum negative changes in cells B1:Bn (offset by n cells). Ignore positive changes. Example two, sum positive changes only in cells A50:A-n (offset by -n cells). Ignore negative changes. And sum negative changes in cells B70:B-n (offset by -n cells). Ignore positive changes. For clarity, this example resolves to A50:A20 and B70:B10. How would one best specify to the function that the second example requires a start at A50 and B70 and descending; while the first example requires a start at A1 and B1 and ascending? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What would be the most effective way to do this? | Excel Worksheet Functions | |||
Macro that will detemine date and then check off a box | Excel Worksheet Functions | |||
Effective method to paste array formula | Excel Worksheet Functions | |||
Can we Pass String to FieldInfo Array to OpenText Method. | Excel Programming | |||
Sheets(array) method for printing grouped worksheets | Excel Programming |