I am designing a spreadsheet that is comparing values and doing percentages.
I copy the formula from row 3 all the way down the page and obviously the row
numbers change for each line. I need to know how to copy and keep certain
portions of the formula from changing and referencing cells in the 3rd row to
come up with growth or loss percentages.
Thanks.