Hi All,
I’m wanting to copy a formula down a column but keep the total number all the way down the row.
Eg row A has a series of numbers and at the bottom “ A10” is a total.
I want row B to have row A/A10.
So B1 is A1/A10 then B2 is A2/A10 and so on.
If I copy B1 formula and paste in whole row it doesn’t retain A10.
Bookmarks