{"id":10692,"date":"2022-12-16T06:57:52","date_gmt":"2022-12-16T05:57:52","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10692"},"modified":"2022-12-06T01:01:14","modified_gmt":"2022-12-06T00:01:14","slug":"excel-2021-les-fonctions-assemb-v-et-assemb-h","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10692","title":{"rendered":"Excel 2021 : les fonctions ASSEMB.V et ASSEMB.H"},"content":{"rendered":"<p style=\"text-align: justify;\">Excel 2021 a fait na\u00eetre toute une s\u00e9rie de nouvelles fonctions (dont <a href=\"https:\/\/www.auditsi.eu\/?p=10516\">FILTRE<\/a>,&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?p=10516\">TRIER<\/a>&nbsp;ou&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?p=10426\">TRANSPOSE<\/a> d\u00e9j\u00e0 pr\u00e9sent\u00e9es sur ce blog) ou fait \u00e9voluer d&#8217;autres (dont la&nbsp;fonction&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?p=4363\">SOMME.SI.ENS<\/a>). Les <strong>fonctions ASSEMB.V et ASSEMB.H<\/strong> font partie de ces nouvelles fonctions. Toutes ces fonctions pr\u00e9sentent l&#8217;int\u00e9r\u00eat d&#8217;\u00eatre dot\u00e9es de capacit\u00e9s de calcul matriciel dynamique.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10695\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V.png\" alt=\"Fonction ASSEMB.V\" width=\"485\" height=\"269\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V.png 485w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V-300x166.png 300w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/p>\n<p style=\"text-align: justify;\">Les&nbsp;<strong>formules matricielles dynamiques<\/strong>&nbsp;permettent \u00e0 des fonctions d\u2019<strong>interagir avec les cellules adjacentes<\/strong>&nbsp;pour y loger le r\u00e9sultat de calculs alors que traditionnellement une formule de calcul ne produit un r\u00e9sultat que dans la cellule o\u00f9 elle est log\u00e9e. Le nombre de cellules concern\u00e9es&nbsp;<strong>d\u00e9pend de la taille du r\u00e9sultat<\/strong>&nbsp;; d\u2019o\u00f9 la notion de formules matricielles dynamiques.<\/p>\n<p style=\"text-align: justify;\">La <strong>fonction ASSEMB.V<\/strong> retourne un tableau assemblant verticalement le contenu des diff\u00e9rentes plages de cellules renseign\u00e9es en param\u00e8tres. ASSEMB.H r\u00e9alise la m\u00eame op\u00e9ration mais horizontalement.<\/p>\n<p style=\"text-align: justify;\">Syntaxe fonction ASSEMB.V :<\/p>\n<p style=\"text-align: center;\">ASSEMB.V(Plage1;[Plage2];[Plage3];&#8230;)<\/p>\n<p>Exemple :<\/p>\n<p style=\"text-align: center;\">=ASSEMB.V(ENTITE1!A1:D5;ENTITE2!A2:D2;ENTITE3!A2:D2;ENTITE4!A2:D2)<\/p>\n<p style=\"text-align: justify;\">Dans cet exemple, des extraits de balances comptables (v\u00e9hicules immobilis\u00e9s) de diff\u00e9rentes soci\u00e9t\u00e9s sont stock\u00e9s dans des feuilles de travail distinctes (ENTITE1, ENTITE2&#8230;) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10696\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V-feuilles.png\" alt=\"Fonction ASSEMB.V feuilles\" width=\"467\" height=\"239\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V-feuilles.png 467w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V-feuilles-300x154.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/p>\n<p style=\"text-align: justify;\">La fonction ASSEMB.V r\u00e9unit ces balances dans un seul tableau :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10695\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V.png\" alt=\"Fonction ASSEMB.V\" width=\"485\" height=\"269\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V.png 485w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Fonction-ASSEMB.V-300x166.png 300w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/p>\n<p style=\"text-align: justify;\">Les fonction ASSEMB.V et ASSEMB.H peuvent \u00eatre associ\u00e9es avec <a href=\"https:\/\/www.auditsi.eu\/?p=10516\">FILTRE<\/a>,&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?p=10516\">TRIER<\/a> et <a href=\"https:\/\/www.auditsi.eu\/?p=10426\">TRANSPOSE<\/a>.<\/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\">Formation gratuite Analyse de donn\u00e9es et automatisation avec Excel et Access<\/a> \/&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 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%202021%20%3A%20les%20fonctions%20ASSEMB.V%20et%20ASSEMB.H\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Excel 2021 a fait na\u00eetre toute une s\u00e9rie de nouvelles fonctions (dont FILTRE,&nbsp;TRIER&nbsp;ou&nbsp;TRANSPOSE d\u00e9j\u00e0 pr\u00e9sent\u00e9es sur ce blog) ou fait \u00e9voluer d&#8217;autres (dont la&nbsp;fonction&nbsp;SOMME.SI.ENS). Les fonctions ASSEMB.V et ASSEMB.H font partie de ces nouvelles fonctions. Toutes ces fonctions pr\u00e9sentent l&#8217;int\u00e9r\u00eat d&#8217;\u00eatre dot\u00e9es de capacit\u00e9s de calcul matriciel dynamique. Les&nbsp;formules matricielles dynamiques&nbsp;permettent \u00e0 des fonctions d\u2019interagir &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10692\" class=\"more-link\">Continue reading &lsquo;Excel 2021 : les fonctions ASSEMB.V et ASSEMB.H&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%202021%20%3A%20les%20fonctions%20ASSEMB.V%20et%20ASSEMB.H\";<\/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":[166,2823,2822,1633,2820,2800],"class_list":["post-10692","post","type-post","status-publish","format-standard","hentry","category-excel","category-maitriser-excel","tag-analyse-de-donnees","tag-assemb-h","tag-assemb-v","tag-excel","tag-formule-matricielle-dynamique","tag-propagation"],"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\/10692","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=10692"}],"version-history":[{"count":2,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10692\/revisions"}],"predecessor-version":[{"id":10700,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10692\/revisions\/10700"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}