sorting by sector and find largest 3 number each macro help needed

there are 3 columns
1: name of the company
2: the sector it belongs (food,beverage...)
3: net sales


i want to find out the largest or smallest (doesnt matter) 3 (or 5 whatever) net sales of each sector ( and hide all other rows) (in ascending or descending format)

is it be so difficult to write a macro like that)