cell difference + or –

Hi – I have created an excel ss and I have numerical values in column g at 1,14,23,29,34 etc etc throughout the whole ss of 1889 rows. I would like to get a formula that will do the following:

Take the value of cell g1 away from the value of g14 and put the result into h1.

Then take the value of g14 away from g23 and put the result into h14

I would like to be able to repeat this all the way to the bottom.

Please could anyone help?

 

Thank you

 

 

 

By: iain macalister

Leave a Reply

Your email address will not be published. Required fields are marked *