Hello,
I want excel to find me the last 5 values so then I can do Average, Min, Max...
I found this formula
=AVERAGE(OFFSET(C3,COUNT(C:C),0,-5))
from site
https://exceljet.net/formula/average-last-5-values
</pre>
but the problem is my column is full of numbers and I want it to ignore the...