I want to do formula for an average of L12W Sales without any outliers or peaks or bottom. What would the formula be?
For example, here is last 12 weeks sales.
I want it to average the sales in between 45-75 not taking 2,3,150,250 into the average.
<tbody>
</tbody>
thank you,
For example, here is last 12 weeks sales.
I want it to average the sales in between 45-75 not taking 2,3,150,250 into the average.
50 | 2 | 150 | 75 | 45 | 48 | 65 | 52 | 250 | 55 | 3 | 60 |
<tbody>
</tbody>
thank you,