Filtering top 20

[Shabeer]

I have data consisting on 3 columns , 1) Material Group (eg - Soap, Shampoo, Haircream etc) 2) Part No (each product under the material group have about 200 part nos) and 3) Annual Qty of each part no.


A filter need to created that gives only the top 20 products (by annual qty) for each material group. Note that part no volumes under material group "soap" are over 10,000 units while "shampoo" are under 1,000 units. Looking forward to your comments


Regards


shabeer

 

[Hui]

Shabeer


Have you looked at Using an Advanced Filter


I'd have a read of Debra Dalgleish posts at Contextures.com

http://www.contextures.com/xladvfilter01.html

 

[vinodhraj]

Use data filter... select the column row and hit Alt+d,f,f. Then select the material from "Material" column (first select Soap). Then in quantity column select "Sort Largest to Smallest". This will sort the product with maximum quantity from highest to lowest. You can select top 20 from it. Repeat it for other materials as well.

 

[Shabeer]

Thanks Hui for the read, it seems easy when you know the way out!