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

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.


Leave a Reply

You must be logged in to post a comment.