Hello everyone,

I am facing problem in excluding outlier value from excel. I have set of data say about 200. From these set of data I need to take average. The problem is the values which are outside 50 to 150 % of average values needs to be excluded subsequently in consideration of average. (like circular reference). I need to exclude the most deviant value first then recalculate the average, again exclude the value outside limit and so on till all accepted values are within 50 to 150%. Can anyone help on this query? Excel formula or macro shall also be acceptable.