How to use Unique and sort top 5 region and bottom 5 region sales performance

Question

Hello everyonePlease 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 the top 5 and 2 for the bottom 5.&nbsp;I'm struggling with the formula i should be using to do the above. Please help me cause you tube videos are not helping at all.&nbsp;RegardsDenise

oliverscheurich · Answer

Denise_Fisher1204&nbsp;&nbsp; =TAKE(SORT(A1:B18,2),IF(G1=1,-5,IF(G1=2,5)))&nbsp;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 1353&nbsp;Region 2802&nbsp;1&nbsp;Region 2802&nbsp;Region 14802&nbsp;&nbsp;&nbsp;Region 3129&nbsp;Region 15841&nbsp;&nbsp;&nbsp;Region 4775&nbsp;Region 12948&nbsp;&nbsp;&nbsp;Region 5537&nbsp;Region 7984&nbsp;&nbsp;&nbsp;Region 6424&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 7984&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 8541&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 9103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 10493&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 11635&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 12948&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 13720&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 14802&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 15841&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 16774&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 173&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Region 18628&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

How to use Unique and sort top 5 region and bottom 5 region sales performance

Share

Resources

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