Need a column formula to pull balance from last row

BSReid24

I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but nothing I found worked.

Is there a formula that would allow me to pull the [Ending Balance] from the previous row into the [Starting Balance] on the current row, and not cause an error?

Matt Johnson

Hi @BSReid24

Have you tried not making it a column formula? For what you are describing, you could do it like this.

=[Ending Balance]1 goes into the highlighted cell below and then copied down. No formula in the top cell above that.

I hope that helps. -Matt

BSReid24

@Matt Johnson yes I had that as an option and working perfectly. My goal was to automate as much as possible to prevent team members from having to copy formulas if possible, to limit the chances of messing something up on the sheet.