vishan_rana
New Member
- Joined
- Feb 22, 2012
- Messages
- 20
Dear All,
i Have a data with branch and its TAT as follows,
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I want to take A and B's average of highest 20% and average of lowest 20%.
Pls suggest me a formula.
thanks in advance.
Regards
Vishan
i Have a data with branch and its TAT as follows,
Branch | TAT |
A | 4 |
A | 2 |
A | 3 |
A | 3 |
A | 4 |
B | 4 |
B | 2 |
B | 3 |
B | 3 |
B | 4 |
B | 8 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I want to take A and B's average of highest 20% and average of lowest 20%.
Pls suggest me a formula.
thanks in advance.
Regards
Vishan