{"id":6505,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdmax\/"},"modified":"2021-02-26T08:04:59","modified_gmt":"2021-02-26T08:04:59","slug":"dmax","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dmax\/","title":{"rendered":"BDMAX"},"content":{"rendered":"

La fonction DMAX (ou BDMAX dans certaines versions localis\u00e9es de MS Excel), disponible sous Microsoft Excel et Google Sheets, permet de d\u00e9terminer la valeur maximale dans une colonne sp\u00e9cifique d\u2019une base de donn\u00e9es, conform\u00e9ment \u00e0 des crit\u00e8res pr\u00e9d\u00e9finis. Cet outil s’av\u00e8re particuli\u00e8rement pr\u00e9cieux pour des analyses o\u00f9 il est n\u00e9cessaire d’identifier la valeur la plus \u00e9lev\u00e9e en fonction de conditions sp\u00e9cifiques.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction DMAX se pr\u00e9sente comme suit :<\/p>\n

=DMAX(base_de_donn\u00e9es, champ, crit\u00e8res)<\/code><\/pre>\n
    \n
  • base_de_donn\u00e9es<\/strong> : Correspond \u00e0 la plage de cellules qui compose la base de donn\u00e9es.<\/li>\n
  • champ<\/strong> : D\u00e9signe la colonne o\u00f9 rechercher la valeur maximale. Ce champ peut \u00eatre indiqu\u00e9 par le nom de l’ent\u00eate entre guillemets ou par le num\u00e9ro correspondant \u00e0 la colonne.<\/li>\n
  • crit\u00e8res<\/strong> : Repr\u00e9sente la plage de cellules contenant les conditions qui serviront \u00e0 filtrer les donn\u00e9es.<\/li>\n<\/ul>\n
    Exemples pratiques<\/h2>\n
    Voici quelques exemples illustrant l’utilisation de la fonction DMAX.<\/p>\n
    Exemple 1 : Recherche de la note maximale<\/h2>\n
    Consid\u00e9rons une base de donn\u00e9es d\u2019\u00e9tudiants avec les colonnes ID, Nom, Classe et Note. Pour trouver la note la plus \u00e9lev\u00e9e dans la classe 10B, nous utiliserions la configuration suivante :<\/p>\n
    =DMAX(A2:D100, \"Note\", F1:F2)<\/code><\/pre>\n\n\n\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\nD<\/th>\nF<\/th>\n<\/tr>\n
    ID<\/td>\nNom<\/td>\nClasse<\/td>\nNote<\/td>\nClasse<\/td>\n<\/tr>\n
    1<\/td>\nJean<\/td>\n10A<\/td>\n84<\/td>\n10B<\/td>\n<\/tr>\n
    2<\/td>\nMarie<\/td>\n10B<\/td>\n92<\/td>\n<\/td>\n<\/tr>\n
    …<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n<\/td>\n<\/tr>\n<\/table>\n
    Dans cet exemple, la plage de crit\u00e8res se trouve dans F1:F2, o\u00f9 F1 contient l’en-t\u00eate ‘Classe’ et F2 la valeur ’10B’.<\/p>\n
    Exemple 2 : Salaire maximal dans un d\u00e9partement sp\u00e9cifique<\/h2>\n
    Examinons une base de donn\u00e9es d’employ\u00e9s comportant les colonnes ID, Nom, D\u00e9partement et Salaire. Pour obtenir le salaire maximal dans le d\u00e9partement ‘Marketing’, la formule serait la suivante :<\/p>\n
    =DMAX(A2:D100, \"Salaire\", H1:H2)<\/code><\/pre>\n\n\n\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\nD<\/th>\nH<\/th>\n<\/tr>\n
    ID<\/td>\nNom<\/td>\nD\u00e9partement<\/td>\nSalaire<\/td>\nD\u00e9partement<\/td>\n<\/tr>\n
    1<\/td>\nLuc<\/td>\nVentes<\/td>\n35000<\/td>\nMarketing<\/td>\n<\/tr>\n
    2<\/td>\nSophie<\/td>\nMarketing<\/td>\n42000<\/td>\n<\/td>\n<\/tr>\n
    …<\/td>\n…<\/td>\n…<\/td>\n…<\/td>\n<\/td>\n<\/tr>\n<\/table>\n
    Les crit\u00e8res sont sp\u00e9cifi\u00e9s dans la plage H1:H2, o\u00f9 H1 indique ‘D\u00e9partement’ et H2 sp\u00e9cifie ‘Marketing’, ce qui permet de cibler uniquement les donn\u00e9es du d\u00e9partement ‘Marketing’.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR maximale des entR\u00e9es de base de donn\u00e9es s\u00e9lectionn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-6505","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DMAX (BDMAX) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DMAX (BDMAX) 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\/dmax\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DMAX (BDMAX) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DMAX (BDMAX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dmax\/\" \/>\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:04:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DMAX (BDMAX) 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\/dmax\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dmax\/\",\"name\":\"Fonction DMAX (BDMAX) 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:04:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DMAX (BDMAX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dmax\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dmax\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dmax\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es\",\"item\":\"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDMAX\"}]},{\"@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 DMAX (BDMAX) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DMAX (BDMAX) 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\/dmax\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DMAX (BDMAX) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DMAX (BDMAX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dmax\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DMAX (BDMAX) 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\/dmax\/","url":"https:\/\/functiontranslator.com\/fr\/dmax\/","name":"Fonction DMAX (BDMAX) 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:04:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DMAX (BDMAX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dmax\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dmax\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dmax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es","item":"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/"},{"@type":"ListItem","position":3,"name":"BDMAX"}]},{"@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\/6505","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=6505"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6505\/revisions"}],"predecessor-version":[{"id":29517,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6505\/revisions\/29517"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}