Anbuselvam K
Member
Dear Excel Genius
I have two formulas in cells C3 and D3 and I want to drag the formulas across right up to cell CX.
C3 Formula =C5-SUM(Cost_Calcu[[#All],[Cost of RM01]])
D3 Formula =D5-SUM(Consumption[[#All],[Consumption RM01]])
C3 formula needs to drag alternate cells of E3, G3, I3......CW3.
D3 Formula needs to drag alternate cells of F3, H3, J3......CX3.
Attached is the sample sheet for your reference.
I have two formulas in cells C3 and D3 and I want to drag the formulas across right up to cell CX.
C3 Formula =C5-SUM(Cost_Calcu[[#All],[Cost of RM01]])
D3 Formula =D5-SUM(Consumption[[#All],[Consumption RM01]])
C3 formula needs to drag alternate cells of E3, G3, I3......CW3.
D3 Formula needs to drag alternate cells of F3, H3, J3......CX3.
Attached is the sample sheet for your reference.