Categories
Excel Training

Using number filters in Excel

I can filter data in my Excel worksheet, using the number filters.  This is another time-saving feature that helps me to get the data I need, quickly and easily.

list-of-students-course-on-excel-2010-training-course
The list of students

You can access the number filters, by selecting the down arrow next to the filter in the column you want to review.

number-filters-in-excel-2010-training-courses
Number filter options – so you can get the information you need in one click.

The filters offer you the apply number filters including:

  • Equals
  • Does not equal
  • Greater than
  • Greater than Or Equal to
  • Less than
  • Less than or equal to
  • Between
  • Top 10
  • Above average
  • Below average

If you click on a number filter, a dialogue box will open and you can type in the figures to complete your task.

For example, I want to sort my list by those students with results between 55 and 70.

number-filter-greater-than-or-equal-to-excel-2010-training-courses
Filter options appear when you click, to figure out results between 55 and 70. I’m going to use “Greater than Or Equal to”

Excel now gives me a dialogue box and I can add the range I want to find, and use the additional options in this box to customise my search.

add-values-to-filter-excel-2010-training-courses
Setting up the range using number filters

Once I press ok, Excel gives me the results.

results-from-filter-excel-2010-training-course
The results using the filter.

Using filters is included in our Excel 2010 training courses.  Take a look at what you can learn https://www.stl-training.co.uk/syl/26/excel-formulas-functions.html

 

 

 

 

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.