{"id":54311,"date":"2019-06-18T22:03:38","date_gmt":"2019-06-18T21:03:38","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=54311"},"modified":"2019-06-18T22:03:38","modified_gmt":"2019-06-18T21:03:38","slug":"alarm-bij-filters-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/alarm-bij-filters-in-excel\/","title":{"rendered":"Alarm bij filters in Excel"},"content":{"rendered":"<p>V. Kan ik een alarm of notificatie laten verschijnen in Excel als er gegevens gefilterd zijn, dus als niet alle gegevens getoond worden?<\/p>\n<p>A. Ja: door Excel in \u00e9\u00e9n bepaalde kolom met gegevens (maak niet uit dewelke) te laten tellen hoeveel gegevens er zijn (met AANTALARG) en dat te vergelijken met hoeveel er getoond worden (met SUBTOTAAL). Als die twee waarden niet hetzelfde zijn, kan je iets laten verschijnen (bv. het woord <em>alarm<\/em>)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-54313\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-filteralarm1-300x112.png\" alt=\"\" width=\"300\" height=\"112\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-filteralarm1-300x112.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-filteralarm1.png 668w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<pre>=ALS(SUBTOTAAL(3;A:A)=AANTALARG(A:A);\"\";\"alarm\")<\/pre>\n<p>En dan kan je met voorwaardelijke opmaak de cel met die formule laten kleuren.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-54312\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-filteralarm2-300x197.png\" alt=\"\" width=\"300\" height=\"197\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-filteralarm2-300x197.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/06\/xl-filteralarm2.png 556w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>TIP: zet bij de voorwaarde het woord <em>alarm<\/em> (zonder &#8220;).<\/p>\n<p>Meer weten? Zie bv. <a href=\"https:\/\/www.excelandaccess.com\/formula-to-check-if-table-is-filtered\/\">Formula to check if a table is filtered<\/a> &#8211; met een complexere uitwerking..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik een alarm of notificatie laten verschijnen in Excel als er gegevens gefilterd zijn, dus als niet alle gegevens getoond worden? A. Ja: door Excel in \u00e9\u00e9n bepaalde kolom met gegevens (maak niet uit dewelke) te laten tellen hoeveel gegevens er zijn (met AANTALARG) en dat te vergelijken<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":7,"footnotes":""},"categories":[464,54,79,10,160],"tags":[],"class_list":["post-54311","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-odisee","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 01:06:38","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=54311"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54311\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=54311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=54311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=54311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}