I have an excel wokrsheet containing all public companies in Thai stock exchange with their respective information like market cap, price, margin, etc., and they are sorted based on their industries...

what I want is to create a filter for each industry so that I can sort the companies from that industry, based on, say, revenues, without affecting the ordering of companies in other industries

for example: within agriculture, i want to sort companies from the largest to smallest revenues, but the order of companies in the other industries should not be affected...

i can't seem to do this with just a "filter" function, because even though I only block the companies from agriculture industry and click "filter", excel will automatically include all other rows and columns in the worksheet, thereby including the other industries that I don't want into the filter....

pls see attached file to get a better idea

thanks for your help!

filtering.jpg