I need to divide multiple cells by a single control cell in order.

[LRM]

I have cell c6 that needs to be divided by c8/c6, c9/c6, c10/c6 and so on.
How can I come up with a formula without having to manually enter it each
time. I have hundreds of rows of data to do this with.
Thanks
LRM

 

[Fred Smith]

Let's say you want to have these formulas in column D. In D8, enter:
=c8/$c$6

Now fill this down the column. The $ tells Excel not to change the cell
reference.

Regards,
Fred.

 

[Jacob Skaria]

Just to add on to what Fred Smith has posted ..

Use absolute referencing for cell C6. Below are the different reference
styles.
A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

Alternative solution without using formulas is
--Copy cell C6
--Keeping the copy; select the range C8,c9,c10... etc;
--Right click>PasteSpecial>Divide>OK.


If this post helps click Yes