{"id":1018,"date":"2017-01-03T09:39:26","date_gmt":"2017-01-03T15:39:26","guid":{"rendered":"http:\/\/blog.ls-al.com\/?p=1018"},"modified":"2017-01-03T09:39:26","modified_gmt":"2017-01-03T15:39:26","slug":"excel-advanced-filter","status":"publish","type":"post","link":"https:\/\/blog.ls-al.com\/excel-advanced-filter\/","title":{"rendered":"Excel Advanced Filter"},"content":{"rendered":"<p>Filtering systematically through a lot of data you may need to slowly exclude rows one by one based on your findings or root cause process. I used advanced filters to accomplish this.<\/p>\n<p>Examples here:<br \/>\nhttps:\/\/support.office.com\/en-us\/article\/Filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b#bmexample5<\/p>\n<p>After applying a filter with:<\/p>\n<ul>\n<li>excluding 192.168.38.103 and<\/li>\n<li>excluding Destination Ports 215 and 217 and<\/li>\n<li>showing only rows with bytes &gt; 500 000<\/li>\n<\/ul>\n<p>Use Data -&gt; Advanced Filter and Select the correct ranges<\/p>\n<p><a href=\"http:\/\/blog.ls-al.com\/wp-content\/uploads\/2017\/01\/advanced_filter_and_showing_selection.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1023 alignleft\" src=\"http:\/\/blog.ls-al.com\/wp-content\/uploads\/2017\/01\/advanced_filter_and_showing_selection.png\" alt=\"\" width=\"563\" height=\"476\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Filtering systematically through a lot of data you may need to slowly exclude rows one by one based on your<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[],"class_list":["post-1018","post","type-post","status-publish","format-standard","hentry","category-msexcel"],"_links":{"self":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts\/1018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/comments?post=1018"}],"version-history":[{"count":0,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts\/1018\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/media?parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/categories?post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/tags?post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}