Hi Experts

I have a ss of 30,000 product lines from 15 suppliers. It also shows sales year to date.

I want to filter and delete so I eventually end up with the top 100 sellers from each supplier.

I switched on Autofilter for all columns, selected one supplier and then selected top 100 items in sales - expecting to get the top 100 sales for that supplier.

Instead, I got all the lines for that supplier that appear in the top 100 overall sales!

I checked that I definitely filtered suppliers before I filtered on sales.

What did I get wrong?

Thanks

Colin