How do I calculate an average of the last 5 nonblank cells in a ro
the functon will not work if the total last value in the same column as the
data. I'm search for the last value in the row.
If you want the total to be at the end of the data then
change from:
LastRow = Cells(Rows.Count, MyCol).End(xlUp).Row
to:
LastRow = Cells(Rows.Count, MyCol).End(xlUp).Row - 1
" wrote:
I am trying to average only the last 5 nonblank values in a row of
cells. Is this possible?
|