Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have an RxC array which contains formulas in each cell. The formula has a
variable that varies vertically & horizontally, and a variable that varies horizontally by row: E.g: =E2-$O$2, =F2-$O$2, ... =E3-$O$3, =F3-$O$3, ... .... I would like to find a better way to populate the array as I add rows. I would greatly appreciate a shortcut or macro or ?? that will help me do this. The first variable works properly when I fill right and down, but the second one ($O$2) varies by row, but then stays the same across the width of the array. Thanks much! dmn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill down array to last available row | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How to use array formula for three variables? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |