Help with Formula
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. |
Hi
and how do you want to define your trend? "Vinaya" wrote: 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. |
All times are GMT +1. The time now is 03:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com