Hi Everyone,

I'm trying to develop a VBA Function that can calculate the mean absolute error of a range of values. the way the funtion would need to do is the following:

1. There are two columns of data; Column A and Column B. Both Columns have the same number of rows of data.

2. For every row of data the function would need to do Column A - Column B, take the absolute value of the result, and store it in an Array

3. The function would then calculate the average of all the values in the Array, and return a result.

Would anyone know how to do this?

Thanks.