Rather than filtering, You should use conditional formatting for making the top or bottom quantities stand out clearly in the facts. One example is: a column that contains names might be filtered by All those that contains “A” or “B”, which means Andrew and Bob would both equally show up. https://autofilter09630.idblogmaker.com/33228142/5-simple-statements-about-auto-filter-explained