{"id":6774,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-tri\/"},"modified":"2021-02-26T08:13:53","modified_gmt":"2021-02-26T08:13:53","slug":"sort","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/sort\/","title":{"rendered":"TRI"},"content":{"rendered":"<p>La fonction TRI (SORT en anglais) de MS Excel et Google Sheets est essentielle pour organiser les donn\u00e9es au sein d&rsquo;une plage de cellules. Cette fonction permet de trier automatiquement les donn\u00e9es en fonction de crit\u00e8res d\u00e9finis, ce qui est particuli\u00e8rement utile lors du traitement de grandes quantit\u00e9s de donn\u00e9es et pour en simplifier l&rsquo;analyse.<\/p>\n<h2>Description du fonctionnement<\/h2>\n<p>La fonction TRI n\u00e9cessite plusieurs param\u00e8tres pour d\u00e9terminer l&rsquo;ordre de tri des donn\u00e9es:<\/p>\n<ul>\n<li><strong>plage:<\/strong> d\u00e9signe la plage de cellules \u00e0 trier.<\/li>\n<li><strong>tri_index:<\/strong> indique la colonne de r\u00e9f\u00e9rence pour le tri, par exemple, 1 pour la premi\u00e8re colonne de la plage.<\/li>\n<li><strong>tri_ordre:<\/strong> pr\u00e9cise l&rsquo;ordre de tri, o\u00f9 1 correspond \u00e0 un ordre ascendant et -1 \u00e0 un ordre descendant.<\/li>\n<li><strong>[tri2_index], [tri2_ordre], &#8230;:<\/strong> permettent d&rsquo;ajouter des crit\u00e8res de tri suppl\u00e9mentaires.<\/li>\n<\/ul>\n<pre><code>=TRI(A2:B9, 1, 1)<\/code><\/pre>\n<p>Dans l&rsquo;exemple ci-dessus, la fonction TRI ordonne les donn\u00e9es de la plage A2 \u00e0 B9 en fonction de la premi\u00e8re colonne en ordre ascendant.<\/p>\n<h2>Exemples d&rsquo;utilisation<\/h2>\n<p>Voici quelques exemples pratiques illustrant l&rsquo;utilisation de cette fonction.<\/p>\n<h2>Trier une liste de noms<\/h2>\n<p>Supposons que vous disposiez d&rsquo;une liste comprenant pr\u00e9noms et noms de famille que vous souhaitez trier par nom de famille.<\/p>\n<pre><code>Pr\u00e9nom Nom John Doe Jane Smith Alice Johnson Bob Loxley<\/code><\/pre>\n<p>Vous pouvez utiliser la fonction TRI pour organiser cette liste par nom de famille en ordre ascendant :<\/p>\n<pre><code>=TRI(A1:B5, 2, 1)<\/code><\/pre>\n<p>Cette formule trie les donn\u00e9es de la plage A1:B5 en se basant sur la deuxi\u00e8me colonne (Nom) en ordre ascendant.<\/p>\n<h2>Analyse des donn\u00e9es de ventes<\/h2>\n<p>Imaginez que vous ayez une table de donn\u00e9es de ventes mensuelles que vous voulez trier par montant des ventes en ordre d\u00e9croissant, puis par nom du vendeur en ordre ascendant pour les montants \u00e9quivalents.<\/p>\n<table>\n<tr>\n<th>Mois<\/th>\n<th>Vendeur<\/th>\n<th>Vente<\/th>\n<\/tr>\n<tr>\n<td>Janvier<\/td>\n<td>Alice<\/td>\n<td>500<\/td>\n<\/tr>\n<tr>\n<td>F\u00e9vrier<\/td>\n<td>Bob<\/td>\n<td>450<\/td>\n<\/tr>\n<tr>\n<td>Mars<\/td>\n<td>John<\/td>\n<td>700<\/td>\n<\/tr>\n<tr>\n<td>Avril<\/td>\n<td>Jane<\/td>\n<td>650<\/td>\n<\/tr>\n<\/table>\n<pre><code>=TRI(A1:C5, 3, -1, 2, 1)<\/code><\/pre>\n<p>Cette formule trie d&rsquo;abord la plage A1:C5 par la troisi\u00e8me colonne (Vente) en ordre descendant, puis par la deuxi\u00e8me colonne (Vendeur) en ordre ascendant si des montants sont identiques.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trie le contenu d\u2019une plage ou d\u2019un tableau<\/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-6774","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction SORT (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SORT (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/sort\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SORT (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SORT (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sort\/\" \/>\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:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SORT (TRI) 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\/sort\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sort\/\",\"name\":\"Fonction SORT (TRI) 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:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SORT (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sort\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sort\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sort\/#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\":\"TRI\"}]},{\"@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 SORT (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SORT (TRI) 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\/sort\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SORT (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SORT (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sort\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SORT (TRI) 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\/sort\/","url":"https:\/\/functiontranslator.com\/fr\/sort\/","name":"Fonction SORT (TRI) 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:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SORT (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sort\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sort\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sort\/#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":"TRI"}]},{"@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\/6774","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=6774"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6774\/revisions"}],"predecessor-version":[{"id":22583,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6774\/revisions\/22583"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}