{"id":6775,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-trierpar\/"},"modified":"2021-02-26T08:13:54","modified_gmt":"2021-02-26T08:13:54","slug":"sortby","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/sortby\/","title":{"rendered":"TRIERPAR"},"content":{"rendered":"

Pr\u00e9sentation g\u00e9n\u00e9rale<\/h2>\n

La fonction TRIERPAR, disponible dans Microsoft Excel et Google Sheets, permet de trier un tableau ou une plage de cellules en fonction de la valeur d’une ou plusieurs plages de crit\u00e8res. Cette fonction est extr\u00eamement pratique pour organiser des donn\u00e9es de mani\u00e8re dynamique, tout en pr\u00e9servant les donn\u00e9es originales.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction TRIERPAR :<\/p>\n

TRIERPAR(plage, par_quoi, [tri_ascendant_1], [par_quoi2, tri_ascendant2],...)<\/code><\/pre>\n
    \n
  • plage<\/strong> : La plage de cellules \u00e0 trier.<\/li>\n
  • par_quoi<\/strong> : La plage qui d\u00e9termine l’ordre de tri.<\/li>\n
  • tri_ascendant_1<\/strong> : Facultatif. Un bool\u00e9en o\u00f9 TRUE (VRAI) indique un tri ascendant et FALSE (FAUX) un tri descendant. La valeur par d\u00e9faut est TRUE (VRAI).<\/li>\n
  • par_quoi2<\/strong>, tri_ascendant2<\/strong>, … : Facultatifs. Des param\u00e8tres additionnels permettent de sp\u00e9cifier des crit\u00e8res de tri suppl\u00e9mentaires.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Consid\u00e9rons un tableau avec les donn\u00e9es suivantes dans les colonnes A \u00e0 C, o\u00f9 A repr\u00e9sente des noms, B des \u00e2ges et C des scores :<\/p>\n\n\n\n\n\n
    Nom<\/th>\nAge<\/th>\nScore<\/th>\n<\/tr>\n
    Alice<\/td>\n24<\/td>\n85<\/td>\n<\/tr>\n
    Bob<\/td>\n22<\/td>\n90<\/td>\n<\/tr>\n
    Clara<\/td>\n28<\/td>\n88<\/td>\n<\/tr>\n<\/table>\n
    Pour trier ce tableau par \u00e2ge de mani\u00e8re ascendante, utilisez :<\/p>\n
    =TRIERPAR(A1:C3, B1:B3, VRAI)<\/code><\/pre>\n
    Pour trier d’abord par Score de fa\u00e7on descendante, puis par \u00c2ge en cas d’\u00e9galit\u00e9, utilisez :<\/p>\n
    =TRIERPAR(A1:C3, C1:C3, FAUX, B1:B3, VRAI)<\/code><\/pre>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Cas pratique 1 : Gestion de l’inventaire<\/h3>\n
    Un gestionnaire de stock souhaite classer son inventaire par cat\u00e9gorie de produit et ensuite par quantit\u00e9 en stock, de la plus faible \u00e0 la plus \u00e9lev\u00e9e, afin d’identifier les produits n\u00e9cessitant un r\u00e9approvisionnement imm\u00e9diat.<\/p>\n\n\n\n\n\n
    Produit<\/th>\nCat\u00e9gorie<\/th>\nQuantit\u00e9<\/th>\n<\/tr>\n
    Pommes<\/td>\nAlimentaire<\/td>\n30<\/td>\n<\/tr>\n
    Chaises<\/td>\nMobilier<\/td>\n15<\/td>\n<\/tr>\n
    Bananes<\/td>\nAlimentaire<\/td>\n45<\/td>\n<\/tr>\n<\/table>\n
    Pour trier ce tableau d’abord par cat\u00e9gorie de mani\u00e8re alphab\u00e9tique, puis par quantit\u00e9 de fa\u00e7on ascendante au sein de chaque cat\u00e9gorie, utilisez :<\/p>\n
    =TRIERPAR(A1:C4, B1:B4, VRAI, C1:C4, VRAI)<\/code><\/pre>\n
    Cas pratique 2 : Organisation des donn\u00e9es pour une conf\u00e9rence<\/h3>\n
    Un organisateur de conf\u00e9rence souhaite lister les participants, tri\u00e9s d’abord par pays puis par nom, dans l’ordre alphab\u00e9tique pour faciliter l’enregistrement.<\/p>\n\n\n\n\n\n
    Nom<\/th>\nPays<\/th>\n<\/tr>\n
    John Doe<\/td>\nUSA<\/td>\n<\/tr>\n
    Jane Smith<\/td>\nCanada<\/td>\n<\/tr>\n
    Albert Dupont<\/td>\nFrance<\/td>\n<\/tr>\n<\/table>\n
    Solution :<\/p>\n
    =TRIERPAR(A1:B4, B1:B4, VRAI, A1:A4, VRAI)<\/code><\/pre>\n
    Ce param\u00e9trage permet d’organiser les participants de mani\u00e8re efficace, facilitant ainsi la gestion des enregistrements.<\/p>\n","protected":false},"excerpt":{"rendered":"
    La fonction tri trie le contenu d\u2019une plage ou une matrice en fonction des valeurs dans une plage ou une matrice correspondante<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312],"tags":[],"class_list":["post-6775","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SORTBY (TRIERPAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/sortby\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SORTBY (TRIERPAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sortby\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:13:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sortby\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sortby\/\",\"name\":\"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:13:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SORTBY (TRIERPAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sortby\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sortby\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sortby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recherche et matrices\",\"item\":\"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TRIERPAR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SORTBY (TRIERPAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/sortby\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SORTBY (TRIERPAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sortby\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/sortby\/","url":"https:\/\/functiontranslator.com\/fr\/sortby\/","name":"Fonction SORTBY (TRIERPAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:13:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SORTBY (TRIERPAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sortby\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sortby\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sortby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Recherche et matrices","item":"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/"},{"@type":"ListItem","position":3,"name":"TRIERPAR"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6775"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6775\/revisions"}],"predecessor-version":[{"id":29784,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6775\/revisions\/29784"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}