{"id":6638,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/grande-valeur\/"},"modified":"2021-02-26T08:09:32","modified_gmt":"2021-02-26T08:09:32","slug":"large","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/large\/","title":{"rendered":"GRANDE.VALEUR"},"content":{"rendered":"

La fonction GRANDE.VALEUR dans Microsoft Excel et LARGE dans Google Sheets est utilis\u00e9e pour trouver les n-i\u00e8mes plus grandes valeurs dans un ensemble de donn\u00e9es. Cette fonction est tr\u00e8s utile lorsque vous avez besoin de r\u00e9cup\u00e9rer non seulement la valeur maximale mais aussi d’autres valeurs \u00e9lev\u00e9es de la distribution de donn\u00e9es.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction GRANDE.VALEUR\/LARGE est la suivante :<\/p>\n

=GRANDE.VALEUR(plage; n) =LARGE(range, n) <\/code><\/pre>\n
    \n
  • plage<\/strong> : Il s’agit de la plage de cellules qui contient les donn\u00e9es num\u00e9riques dont vous souhaitez trouver la grande valeur.<\/li>\n
  • n<\/strong> : Le \u00ab\u00a0n\u00a0\u00bb repr\u00e9sente l’ordre de la valeur que vous recherchez. Par exemple, si n = 1, la fonction renvoie la plus grande valeur. Si n = 2, elle renvoie la deuxi\u00e8me plus grande valeur, et ainsi de suite.<\/li>\n<\/ul>\n
    Exemples de base<\/h2>\n
    Imaginons que nous ayons un ensemble de donn\u00e9es dans la plage A1:A10 et que nous recherchions les trois plus grandes valeurs.<\/p>\n
    =GRANDE.VALEUR(A1:A10; 1) \/\/ Retourne la plus grande valeur =GRANDE.VALEUR(A1:A10; 2) \/\/ Retourne la deuxi\u00e8me plus grande valeur =GRANDE.VALEUR(A1:A10; 3) \/\/ Retourne la troisi\u00e8me plus grande valeur <\/code><\/pre>\n
    Utilisation dans le contexte analytique<\/h2>\n
    La fonction GRANDE.VALEUR\/LARGE peut \u00eatre utilis\u00e9e dans divers sc\u00e9narios analytiques, tels que le classement de performances, l’identification des valeurs extr\u00eames et beaucoup plus.<\/p>\n
    T\u00e2che : Classement des ventes<\/h2>\n
    Supposons que vous ayez une liste de ventes mensuelles pour diff\u00e9rentes succursales d’une entreprise et que vous souhaitiez trouver les trois mois ayant les meilleures ventes.<\/p>\n
      \n
    • Plage des donn\u00e9es de vente : B2:B13<\/li>\n<\/ul>\n
      =GRANDE.VALEUR(B2:B13; 1) =GRANDE.VALEUR(B2:B13; 2) =GRANDE.VALEUR(B2:B13; 3) <\/code><\/pre>\n
      Chaque formule ci-dessus retournera les trois meilleures valeurs de ventes parmi les donn\u00e9es fournies.<\/p>\n
      T\u00e2che : Trouver les meilleures performances sportives<\/h2>\n
      Consid\u00e9rez un ensemble de donn\u00e9es contenant les temps r\u00e9alis\u00e9s par des athl\u00e8tes sur une course de 100 m\u00e8tres. Pour identifier les trois meilleurs temps, vous pourriez configurer votre feuille de calcul de la mani\u00e8re suivante :<\/p>\n
        \n
      • Plage de temps : D2:D20<\/li>\n<\/ul>\n
        =GRANDE.VALEUR(D2:D20; 1) =GRANDE.VALEUR(D2:D20; 2) =GRANDE.VALEUR(D2:D20; 3) <\/code><\/pre>\n
        Ceci pourrait \u00eatre utile pour identifier les athl\u00e8tes les plus rapides et pour \u00e9ventuellement analyser d’autres aspects de leurs performances.<\/p>\n
        En g\u00e9n\u00e9ral, la fonction GRANDE.VALEUR dans Excel et LARGE dans Google Sheets r\u00e9v\u00e8le \u00eatre un outil puissant lorsqu’il s’agit de faire des analyses de haut niveau sans avoir \u00e0 trier ou \u00e0 manipuler l’ordre des donn\u00e9es originales, permettant ainsi une extraction directe et pr\u00e9cise des valeurs pertinents.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Renvoie la k-i\u00e8me plus gRande valeuR d\u2019une s\u00e9Rie de donn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[315],"tags":[],"class_list":["post-6638","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction LARGE (GRANDE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LARGE (GRANDE.VALEUR) 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\/large\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LARGE (GRANDE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LARGE (GRANDE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/large\/\" \/>\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:09:32+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LARGE (GRANDE.VALEUR) 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\/large\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/large\/\",\"name\":\"Fonction LARGE (GRANDE.VALEUR) 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:09:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LARGE (GRANDE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/large\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/large\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/large\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"GRANDE.VALEUR\"}]},{\"@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 LARGE (GRANDE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LARGE (GRANDE.VALEUR) 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\/large\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LARGE (GRANDE.VALEUR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LARGE (GRANDE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/large\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LARGE (GRANDE.VALEUR) 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\/large\/","url":"https:\/\/functiontranslator.com\/fr\/large\/","name":"Fonction LARGE (GRANDE.VALEUR) 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:09:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LARGE (GRANDE.VALEUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/large\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/large\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/large\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"GRANDE.VALEUR"}]},{"@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\/6638","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=6638"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6638\/revisions"}],"predecessor-version":[{"id":29649,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6638\/revisions\/29649"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}