Hey all - been looking for a couple hours and can't come together with an answer. don't know how to ask exact enough, so here we are.
I have a list of players to find an average score. the first score starts in k, l, m, etc... i'll add more to the right infinitely.
i need to average the 3 right most scores. if 0, exclude.
for example:
Where john's average would be of 25,40,15
and steve's average would be of 20,30,8.
THEN... when i add another number to the right - it will automatically update the average.
Hopefully that makes sense? i'm sure it's simple for someone much smarter. I think i have to use offset function, but i haven't figured out how to put it into my data.
Thanks!
I have a list of players to find an average score. the first score starts in k, l, m, etc... i'll add more to the right infinitely.
i need to average the 3 right most scores. if 0, exclude.
for example:
john smith | "average" | 15 | 0 | 25 | 40 | 0 | 15 | ||
steve smith | "average" | 20 | 20 | 30 | 0 | 0 | 8 |
Where john's average would be of 25,40,15
and steve's average would be of 20,30,8.
THEN... when i add another number to the right - it will automatically update the average.
Hopefully that makes sense? i'm sure it's simple for someone much smarter. I think i have to use offset function, but i haven't figured out how to put it into my data.
Thanks!