Forum Discussion
How to use Unique and sort top 5 region and bottom 5 region sales performance
Hello everyone Please help me as I'm learning how to use Excel. I need to give the top 5 performing region and bottom 5 performing region yet when the info is being viewed they must just type 1 for ...
=TAKE(SORT(A1:B18,2),IF(G1=1,-5,IF(G1=2,5)))
If you have access to the TAKE function you can apply this formula. In cell G1 type 1 to show the top 5 regions or 2 to show the bottom 5 regions.
| Region 1 | 353 | Region 2 | 802 | 1 | |||
| Region 2 | 802 | Region 14 | 802 | ||||
| Region 3 | 129 | Region 15 | 841 | ||||
| Region 4 | 775 | Region 12 | 948 | ||||
| Region 5 | 537 | Region 7 | 984 | ||||
| Region 6 | 424 | ||||||
| Region 7 | 984 | ||||||
| Region 8 | 541 | ||||||
| Region 9 | 103 | ||||||
| Region 10 | 493 | ||||||
| Region 11 | 635 | ||||||
| Region 12 | 948 | ||||||
| Region 13 | 720 | ||||||
| Region 14 | 802 | ||||||
| Region 15 | 841 | ||||||
| Region 16 | 774 | ||||||
| Region 17 | 3 | ||||||
| Region 18 | 628 | ||||||