Hi

In each column I have:-
98% - 888 - meaning no data required
1% - 999 - meaning missing data
1% - contains valid data such as 3.4, 2, etc.

I wish to calculate the average of all the valid numbers ONLY (i.e. excluding 888s and 999s)

Thank you

Bob M