How to Filter For the Smallest or Largest Number in MS Excel XP

August 28, 2007 by · Leave a Comment
Filed under: Excel, How To 
  1. Select any cell in the list to be filtered.
  2. Go to Data menu, select the option Filter, and then click the option AutoFilter.
  3. Click the down arrow in the column that contains the list, and then select (Top 10) option.
  4. In the left box, select Top or Bottom options.
  5. In the middle box, enter a number or use the arrows for the number.
  6. In the right box, select Items option.
  7. Click the OK button.

Tags: ,