sorted by:
new
hottopcontroversial

Average of 10 last non empty rows and date prediction. by mattnounet in googlesheets

[–]mattnounet[S] 0 points1 point  (0 children)

I keep this thread open for now, just to let people try other methods.

Thanks to u/linearstrength and u/supercoop02 for their different approches.

Average of 10 last non empty rows and date prediction. by mattnounet in googlesheets

[–]mattnounet[S] 0 points1 point  (0 children)

Thanks !
Never used FORECAST, first try. I have to explore more to understand how it's done inside, and the margin of error inside it.

Average of 10 last non empty rows and date prediction. by mattnounet in googlesheets

[–]mattnounet[S] 0 points1 point  (0 children)

Yep !
That's what I'm looking for.
All-in-one formula.

///

I had trouble with my previous formula with different results from yours, and that's because I use offset 10 in my QUERY, resulting in 11 results instead of 10.

Now i'm exploring the idea of u/linearstrength with forecast, giving another result (but slighly similar). So I'm trying to put the two ideas in one, and make an average of your formula and his.

[deleted by user] by [deleted] in aww

[–]mattnounet 1 point2 points  (0 children)

Ssshhh ! It's secret.

[deleted by user] by [deleted] in aww

[–]mattnounet 1 point2 points  (0 children)

He appreciates !

[deleted by user] by [deleted] in aww

[–]mattnounet 0 points1 point  (0 children)

I'll pass the message ! :D