I want to average the last 14 numbers in a column that is constantly growing. However, the column has many spaces in it that change amounts of spaces. So I cannot say =AVERAGE(C50:C63).
So for example my column might be
119
(blank)
(blank)
(blank)
100
(blank)
(blank)
147
(blank)
(blank)
(blank)
(blank)
75
So I can't even say 28 lines for 14 numbers, or any exact amount. The number of spaces changes daily. But I can have the last 14 (no more, no less) numbers, or it won't help me.
Any suggestions?
Bookmarks