1

I'm searching for the exact same thing as Google Spreadsheet: How to fill in missing values (inbetween filled values) automatically

I made a spreadsheet for tracking weight, where each row is one day, and one column is weight. Although I've had Google Spreadsheet create a row for every date in the year, I only measure my weight a few times a week. What I would like is a formula to tell Google Docs to use "the last manually filled entry higher in the column", or something along these lines.

Ideally, the last filled row though, will be a manual entry (i.e., hopefully I could paste the formula into all cells in the column, and blank rows between manually-entered rows are filled, but nothing after the last manual entry).

Even more ideally, between two manually filled rows (i.e., row 10 and row 15), the formula would be able to interpolate between the two, but I realize that is asking a bit much.

I have no experience in making these formulas though, can anyone point me to somewhere to start to solve this problem?

But the solution provided doesn't seem to work for me.

Can someone help me?

New contributor
elti69 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Can you provide some sample data ? You might be looking for =TREND or =GROWTH (hopefully not Growth if it's about weight :) ) – pjmg Sep 11 at 9:25
  • Hello, here is the data I have. docs.google.com/spreadsheets/d/… – elti69 Sep 11 at 12:57
1

There's multiples ways to do this :

I used =Trend but =Growth works too.

=TREND(C2:C11,A2:A11,A12:A24)

=Forecast is an amazing function too.

=FORECAST(A3,$B$2:$B$11,$A$2:$A$11)

You can use Arrayformula for extra lazyness :

=ARRAYFORMULA(FORECAST(A3:A24,$B$2:$B$11,$A$2:$A$11))

Theses formulas will be accurate the more data you feed them.
I updated your sheet. Similar question on stackoverflow.

  • Thank you very much – elti69 Sep 12 at 12:47

Your Answer

elti69 is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.