{"id":900,"date":"2012-10-24T11:36:08","date_gmt":"2012-10-24T11:36:08","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=900"},"modified":"2023-12-30T23:12:48","modified_gmt":"2023-12-30T23:12:48","slug":"using-number-filters-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/using-number-filters-in-excel\/","title":{"rendered":"Using number filters in Excel"},"content":{"rendered":"<p>I can filter data in my Excel worksheet, using the <strong>number filters<\/strong>. \u00a0This is another time-saving feature that helps me to get the data I need, quickly and easily.<\/p>\n<figure id=\"attachment_903\" aria-describedby=\"caption-attachment-903\" style=\"width: 224px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/list-of-students-course-on-excel2.png\"><img decoding=\"async\" class=\"size-medium wp-image-903\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/list-of-students-course-on-excel2-224x300.png\" alt=\"list-of-students-course-on-excel-2010-training-course\" width=\"224\" height=\"300\" \/><\/a><figcaption id=\"caption-attachment-903\" class=\"wp-caption-text\">The list of students<\/figcaption><\/figure>\n<p>You can access the number filters, by selecting the down arrow next to the filter in the column you want to review.<\/p>\n<figure id=\"attachment_905\" aria-describedby=\"caption-attachment-905\" style=\"width: 211px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/number-filters-in-excel-2010-training-courses.png\"><img decoding=\"async\" class=\"size-full wp-image-905\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/number-filters-in-excel-2010-training-courses.png\" alt=\"number-filters-in-excel-2010-training-courses\" width=\"211\" height=\"180\" \/><\/a><figcaption id=\"caption-attachment-905\" class=\"wp-caption-text\">Number filter options &#8211; so you can get the information you need in one click.<\/figcaption><\/figure>\n<p>The filters offer you the apply number filters including:<\/p>\n<ul>\n<li>Equals<\/li>\n<li>Does not equal<\/li>\n<li>Greater than<\/li>\n<li>Greater than Or Equal to<\/li>\n<li>Less than<\/li>\n<li>Less than or equal to<\/li>\n<li>Between<\/li>\n<li>Top 10<\/li>\n<li>Above average<\/li>\n<li>Below average<\/li>\n<\/ul>\n<p>If you click on a number filter, a dialogue box will open and you can type in the figures to complete your task.<\/p>\n<p>For example, I want to sort my list by those students with results between 55 and 70.<\/p>\n<figure id=\"attachment_906\" aria-describedby=\"caption-attachment-906\" style=\"width: 211px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/number-filter-greater-than-or-equal-to-excel-2010-training-courses.png\"><img decoding=\"async\" class=\"size-full wp-image-906\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/number-filter-greater-than-or-equal-to-excel-2010-training-courses.png\" alt=\"number-filter-greater-than-or-equal-to-excel-2010-training-courses\" width=\"211\" height=\"174\" \/><\/a><figcaption id=\"caption-attachment-906\" class=\"wp-caption-text\">Filter options appear when you click, to figure out results between 55 and 70. I&#8217;m going to use &#8220;Greater than Or Equal to&#8221;<\/figcaption><\/figure>\n<p>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.<\/p>\n<figure id=\"attachment_907\" aria-describedby=\"caption-attachment-907\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Setting-up-the-range-I-want-to-find-using-number-filters.png\"><img decoding=\"async\" class=\"size-medium wp-image-907\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Setting-up-the-range-I-want-to-find-using-number-filters-300x96.png\" alt=\"add-values-to-filter-excel-2010-training-courses\" width=\"300\" height=\"96\" \/><\/a><figcaption id=\"caption-attachment-907\" class=\"wp-caption-text\">Setting up the range using number filters<\/figcaption><\/figure>\n<p>Once I press ok, Excel gives me the results.<\/p>\n<figure id=\"attachment_908\" aria-describedby=\"caption-attachment-908\" style=\"width: 270px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/results-from-filter-excel-2010-training-course.png\"><img decoding=\"async\" class=\"size-full wp-image-908\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/results-from-filter-excel-2010-training-course.png\" alt=\"results-from-filter-excel-2010-training-course\" width=\"270\" height=\"197\" \/><\/a><figcaption id=\"caption-attachment-908\" class=\"wp-caption-text\">The results using the filter.<\/figcaption><\/figure>\n<p>Using filters is included in our Excel 2010 training courses. \u00a0Take a look at what you can learn\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/syl\/26\/excel-formulas-functions.html\">https:\/\/www.stl-training.co.uk\/syl\/26\/excel-formulas-functions.html<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I can filter data in my Excel worksheet, using the number filters. \u00a0This is another time-saving feature that helps me to get the data I need, quickly and easily. You can access the number filters, by selecting the down arrow next to the filter in the column you want to review. The filters offer you [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[176,388],"class_list":["post-900","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-2010-training-courses","tag-numerical-filters-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=900"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/900\/revisions"}],"predecessor-version":[{"id":6745,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/900\/revisions\/6745"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}