Dynamic FormulaR1C1 Use with Column and Row Number Change.

I am trying to fill the selected Range (Column and row values) with a formula that goes from a starting point to a specified column, counter2, and row, counter1, but I can't seem to figure this one out. What I want is for the formula to have "r1c1"? or in this case "B1" starting point to change to C1, D1, E1, etc... to whenever counter2 ends. Also, at the same time have the first Decon_Display!RC to go from B2 to B3, B4, etc... to whenever Counter1 ends. The second Decon_Display!RC value to go from C2 to C3, C4, C5, C6, etc.. also to whenever Counter1 ends.

So, in other words... Decon_Config!B1, C1, D1, E1, etc... >= Decon_Display!B2, B3, B4, B5, B6, etc..., Decon_Config!B1, C1, D1, E1, etc... <= Decon_Display!C2, C3, C4, C5, etc...),1,0)

I understand that r1c1 causes B1 to be locked in all the formulas in each cell... And if you use brackets [] it does not lock it. Maybe my brain is just fried from trying to figure this out... Please help. Or maybe it is just easier to use A1 format??? I don know...

Please Login or Register  to view this content.

perhaps you can record a macro while inputting the formulas you want into a few cells. I have no clue what formula you want in each cell partly because you seem to be checking if a cell is both greater than or equal to and less than or equal to one other cell (which is just a test to see if the two cells are equal)

I reckon you mean

Please Login or Register  to view this content.