i am trying to make a 6 value moving average.
the only problem is the list sometimes has non numeric data eg "" meaning a blank.
the data analysis tool doesn't calculate a moving average if there is non numeric data, and using a zero instead will alter the average.
any ideas?
the only problem is the list sometimes has non numeric data eg "" meaning a blank.
the data analysis tool doesn't calculate a moving average if there is non numeric data, and using a zero instead will alter the average.
any ideas?