Help with Formula

[Vinaya]

Hi,

I need to calculate average of 3 months. However, if any particular
month is defying the normal trend, that month should be ignored while
calculating the average.

For Eg:

Jan Feb Mar Average
2 2 2 2
4 4 6 4
2 1 2 2


Is this possible?

Regards,
Vinaya.

 

[Frank Kabel]

Hi
and how do you want to define your trend?