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

[Denise_Fisher1204]

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 the top 5 and 2 for the bottom 5.

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.

Regards

Denise

[#2]

@Denise_Fisher1204 

 =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