{"id":901,"date":"2020-11-30T11:29:14","date_gmt":"2020-11-30T10:29:14","guid":{"rendered":"https:\/\/perso.atilf.fr\/sollinge\/?p=901"},"modified":"2020-11-30T11:30:12","modified_gmt":"2020-11-30T10:30:12","slug":"comparaison-sous-excel","status":"publish","type":"post","link":"https:\/\/perso.atilf.fr\/sollinge\/blog\/2020\/11\/30\/comparaison-sous-excel\/","title":{"rendered":"Comparaison sous Excel"},"content":{"rendered":"<p>J\u2019avais deux listes de lemmes, j\u2019avais besoin de r\u00e9cup\u00e9rer rapidement ceux qui \u00e9taient absents de la premi\u00e8re liste, mais pr\u00e9sents dans la deuxi\u00e8me. \u00c7a a \u00e9t\u00e9 fait en un rien de temps en m\u2019inspirant de cet <a href=\"https:\/\/www.excel-exercice.com\/comparer-2-colonnes\/\">exercice<\/a>.<\/p>\n<p>J\u2019ai mis la liste la plus courte dans la colonne A de mon fichier, la liste la plus longue dans la colonne B, j\u2019ai \u00e9crit la formule suivante dans la premi\u00e8re cellule de la colonne C de mon fichier et je l\u2019ai recopi\u00e9 dans toutes les cellules de la colonne C.<\/p>\n<p><code>=SI(ESTNA(RECHERCHEV(B1;A$1:A$411;1;0));B1;\"\")<\/code><\/p>\n<p>Je n\u2019avais plus qu\u2019\u00e0 r\u00e9cup\u00e9rer les lemmes apparus dans la colonne C.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>J\u2019avais deux listes de lemmes, j\u2019avais besoin de r\u00e9cup\u00e9rer rapidement ceux qui \u00e9taient absents de la premi\u00e8re liste, mais pr\u00e9sents dans la deuxi\u00e8me. \u00c7a a \u00e9t\u00e9 fait en un rien de temps en m\u2019inspirant de cet exercice. J\u2019ai mis la liste la plus courte dans la colonne A de mon fichier, la liste la plus [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[46],"tags":[49,48],"class_list":["post-901","post","type-post","status-publish","format-aside","hentry","category-astuces","tag-astuce","tag-excel","post_format-post-format-aside"],"_links":{"self":[{"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/posts\/901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/comments?post=901"}],"version-history":[{"count":3,"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/posts\/901\/revisions"}],"predecessor-version":[{"id":904,"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/posts\/901\/revisions\/904"}],"wp:attachment":[{"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/media?parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/categories?post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/perso.atilf.fr\/sollinge\/wp-json\/wp\/v2\/tags?post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}