{"id":10515,"date":"2022-11-20T16:42:07","date_gmt":"2022-11-20T15:42:07","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10515"},"modified":"2022-11-20T16:42:07","modified_gmt":"2022-11-20T15:42:07","slug":"excel-effectuer-des-recherches-multicriteres-avec-la-fonction-recherchex","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10515","title":{"rendered":"Excel : effectuer des recherches multicrit\u00e8res avec la fonction RECHERCHEX"},"content":{"rendered":"<p style=\"text-align: justify;\">Par d\u00e9faut, la fonction <a href=\"https:\/\/www.auditsi.eu\/?p=10382\">RECHERCHEX<\/a> n&#8217;accepte qu&#8217;un seul crit\u00e8re de recherche.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10541\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-Donnees.png\" alt=\"RECHERCHEX Multicrit\u00e8res Donn\u00e9es\" width=\"493\" height=\"391\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-Donnees.png 493w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-Donnees-300x238.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/p>\n<p style=\"text-align: justify;\">A l\u2019aide de l\u2019<a href=\"https:\/\/www.auditsi.eu\/?p=10532\">arithm\u00e9tique bool\u00e9enne<\/a>, RECHERCHEX est en capacit\u00e9 d\u2019ex\u00e9cuter des recherches multicrit\u00e8res.<\/p>\n<p style=\"text-align: justify;\">La syntaxe d\u2019une recherche multicrit\u00e8res est la suivante : RECHERCHEX(1;crit\u00e8res;plage_r\u00e9sultat;\u2026). Multicrit\u00e8res ou non, RECHERCHEX renvoie la premi\u00e8re ligne correspondant aux crit\u00e8res d\u00e9finis.<\/p>\n<p style=\"text-align: justify;\">Exemples de crit\u00e8res :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Deux crit\u00e8res avec op\u00e9rateur bool\u00e9en * (ET) :<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10542\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET.png\" alt=\"RECHERCHEX Multicrit\u00e8res ET\" width=\"504\" height=\"122\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET.png 673w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET-300x73.png 300w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Crit\u00e8res avec op\u00e9rateurs bool\u00e9ens * (ET) et + (OU) et parenth\u00e8ses :<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10543\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET-OU.png\" alt=\"RECHERCHEX Multicrit\u00e8res ET OU\" width=\"753\" height=\"120\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET-OU.png 753w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET-OU-300x48.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/RECHERCHEX-Multicriteres-ET-OU-730x116.png 730w\" sizes=\"auto, (max-width: 753px) 100vw, 753px\" \/><\/p>\n<p style=\"text-align: justify;\">Les autres param\u00e8tres de RECHERCHEX restent fonctionnels.<\/p>\n<p style=\"text-align: justify;\">Un classeur exemple est t\u00e9l\u00e9chargeable ci-apr\u00e8s.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Analyse de donn\u00e9es et automatisation<\/a>&nbsp;\/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20effectuer%20des%20recherches%20multicrit%C3%A8res%20avec%20la%20fonction%20RECHERCHEX\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Par d\u00e9faut, la fonction RECHERCHEX n&#8217;accepte qu&#8217;un seul crit\u00e8re de recherche. A l\u2019aide de l\u2019arithm\u00e9tique bool\u00e9enne, RECHERCHEX est en capacit\u00e9 d\u2019ex\u00e9cuter des recherches multicrit\u00e8res. La syntaxe d\u2019une recherche multicrit\u00e8res est la suivante : RECHERCHEX(1;crit\u00e8res;plage_r\u00e9sultat;\u2026). Multicrit\u00e8res ou non, RECHERCHEX renvoie la premi\u00e8re ligne correspondant aux crit\u00e8res d\u00e9finis. Exemples de crit\u00e8res : Deux crit\u00e8res avec op\u00e9rateur bool\u00e9en &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10515\" class=\"more-link\">Continue reading &lsquo;Excel : effectuer des recherches multicrit\u00e8res avec la fonction RECHERCHEX&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20effectuer%20des%20recherches%20multicrit%C3%A8res%20avec%20la%20fonction%20RECHERCHEX\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,1326],"tags":[1831,2796,1138,1310,1821,2774,222],"class_list":["post-10515","post","type-post","status-publish","format-standard","hentry","category-excel","category-maitriser-excel","tag-algebre-de-boole","tag-arithmetique-booleenne","tag-criteres","tag-multicritere","tag-operateurs-booleens","tag-recherchex","tag-tests-conditionnels"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10515"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10515\/revisions"}],"predecessor-version":[{"id":10546,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10515\/revisions\/10546"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}