{"id":52664,"date":"2025-03-12T14:00:00","date_gmt":"2025-03-12T13:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=52664"},"modified":"2025-06-03T22:05:07","modified_gmt":"2025-06-03T20:05:07","slug":"filtrer-les-valeurs-qui-ne-se-trouvent-pas-dans-une-autre-colonne","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-formulas\/filter-values-not-in-another-column\/","title":{"rendered":"Filtrer les valeurs d'une colonne qui ne figurent pas dans une autre colonne"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ theme_builder_area=”post_content” _builder_version=”4.27.2″ _module_preset=”default”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column _builder_version=”4.27.2″ _module_preset=”default” type=”4_4″ theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]
\n

Note:<\/strong> This post was originally published in our community forum.<\/p>\n<\/blockquote>\n

Hey everyone! \ud83d\udc4b Check out this handy formula for filtering values from one column that aren\u2019t present in another column.<\/p>\n

Here\u2019s the formula:<\/a><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″ module_class=”spreadsheet-function”]

=UNIQUE(FILTER(Submissions!A2:A, ISNA(MATCH(Submissions!A2:A, Status!A2:A, 0))))<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]

<\/blockquote>\n

This formula works by filtering data in the\u00a0<\/span>Submissions<\/strong>\u00a0<\/span>column that doesn\u2019t appear in the\u00a0<\/span>Status<\/strong>\u00a0<\/span>column. The\u00a0<\/span>UNIQUE<\/strong>\u00a0<\/span>function ensures that only unique values are returned.<\/p>\n

If you\u2019re dealing with spreadsheet data and need to identify differences between two columns, give this formula a try!<\/p>\n

Feel free to discuss or share your own approaches below. I am also sharing the \ud83d\udcca\ud83d\udcac\u00a0<\/span>Original Stack Overflow post<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

Note: This post was originally published in our community forum. Hey everyone! \ud83d\udc4b Check out this handy formula for filtering values from one column that aren\u2019t present in another column. Here\u2019s the formula:=UNIQUE(FILTER(Submissions!A2:A, ISNA(MATCH(Submissions!A2:A, Status!A2:A, 0)))) This formula works by filtering data in the\u00a0Submissions\u00a0column that doesn\u2019t appear in the\u00a0Status\u00a0column. The\u00a0UNIQUE\u00a0function ensures that only unique values […]<\/p>\n","protected":false},"author":46,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[],"class_list":["post-52664","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=52664"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=52664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=52664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=52664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}