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

La Fonction SEQUENCE<\/strong> est un outil extr\u00eamement utile dans Excel et Google Sheets, con\u00e7u pour g\u00e9n\u00e9rer automatiquement une liste de nombres en ordre s\u00e9quentiel. Cette fonction est id\u00e9ale pour cr\u00e9er des s\u00e9ries de donn\u00e9es, organiser des index et de nombreux autres usages efficacement et rapidement.<\/p>\n

D\u00e9finition et Syntaxe<\/h2>\n

Dans Excel et Google Sheets, la syntaxe de la fonction SEQUENCE est la suivante :<\/p>\n

SEQUENCE(lignes, [colonnes], [d\u00e9but], [pas])<\/code><\/pre>\n
    \n
  • lignes<\/strong> : Indique le nombre de lignes \u00e0 remplir avec des valeurs s\u00e9quentielles.<\/li>\n
  • colonnes<\/strong> : (Facultatif) Sp\u00e9cifie le nombre de colonnes \u00e0 remplir. La valeur par d\u00e9faut est 1.<\/li>\n
  • d\u00e9but<\/strong> : (Facultatif) D\u00e9termine la premi\u00e8re valeur de la s\u00e9quence. Si non sp\u00e9cifi\u00e9, elle commence \u00e0 1.<\/li>\n
  • pas<\/strong> : (Facultatif) D\u00e9finit l’incr\u00e9ment entre les valeurs de la s\u00e9quence. Le pas par d\u00e9faut est de 1.<\/li>\n<\/ul>\n
    Exemples Simples<\/h2>\n
    Voici quelques exemples pour illustrer l’utilisation de la fonction SEQUENCE :<\/p>\n\n\n\n\n\n
    Formule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    SEQUENCE(4)<\/code><\/td>\nG\u00e9n\u00e8re 4 valeurs (1, 2, 3, 4) dans une colonne unique.<\/td>\n<\/tr>\n
    SEQUENCE(3, 2)<\/code><\/td>\nG\u00e9n\u00e8re un tableau de 3 lignes et 2 colonnes avec des valeurs s\u00e9quentielles de 1 \u00e0 6.<\/td>\n<\/tr>\n
    SEQUENCE(5, 1, 100, 10)<\/code><\/td>\nProduit 5 valeurs commen\u00e7ant \u00e0 100, avec un incr\u00e9ment de 10 (100, 110, 120, etc.).<\/td>\n<\/tr>\n<\/table>\n
    Applications Pratiques<\/h2>\n
    Cr\u00e9ation d’un calendrier<\/h2>\n
    Imaginons que vous avez besoin de cr\u00e9er un calendrier simple pour un mois de 30 jours dans Google Sheets ou Excel :<\/p>\n
    SEQUENCE(30, 1, 1, 1)<\/code><\/pre>\n
    Cette formule g\u00e9n\u00e8re un tableau qui \u00e9num\u00e8re les 30 jours du mois, id\u00e9al pour planifier chaque semaine.<\/p>\n
    Utilisation avec d’autres fonctions :<\/p>\n
    =TEXTE(DATE(2023, 12, SEQUENCE(30)), \"dddd\")<\/code><\/pre>\n
    Cette formule affiche les jours de la semaine correspondants \u00e0 chaque date du mois.<\/p>\n
    Indexation de Donn\u00e9es<\/h2>\n
    Si vous disposez d’une liste de donn\u00e9es et n\u00e9cessitez de leur attribuer un index, utilisez :<\/p>\n
    SEQUENCE(COUNTA(A2:A21), 1, 1, 1)<\/code><\/pre>\n
    Cette formule cr\u00e9e une colonne d’index de 1 \u00e0 20, en supposant que la colonne A contienne 20 \u00e9l\u00e9ments. Cette indexation assure une r\u00e9f\u00e9rence unique pour chaque \u00e9l\u00e9ment des donn\u00e9es.<\/p>\n
    En d\u00e9finitive, la fonction SEQUENCE est un moyen polyvalent et efficace pour g\u00e9n\u00e9rer des s\u00e9ries num\u00e9riques, simplifiant ainsi la manipulation et l’organisation des donn\u00e9es dans Excel et Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    G\u00e9n\u00e8re une liste de nombres s\u00e9quentiels dans une matrice, comme 1, 2, 3, 4<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6762","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SEQUENCE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SEQUENCE 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\/sequence\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SEQUENCE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SEQUENCE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sequence\/\" \/>\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:30+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SEQUENCE 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\/sequence\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sequence\/\",\"name\":\"Fonction SEQUENCE 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:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SEQUENCE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sequence\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sequence\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sequence\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SEQUENCE\"}]},{\"@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 SEQUENCE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SEQUENCE 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\/sequence\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SEQUENCE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SEQUENCE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sequence\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SEQUENCE 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\/sequence\/","url":"https:\/\/functiontranslator.com\/fr\/sequence\/","name":"Fonction SEQUENCE 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:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SEQUENCE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sequence\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sequence\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sequence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"SEQUENCE"}]},{"@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\/6762","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=6762"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6762\/revisions"}],"predecessor-version":[{"id":22571,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6762\/revisions\/22571"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}