{"id":8129,"date":"2024-12-21T21:24:19","date_gmt":"2024-12-21T21:24:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-sequence-co-ban-trong-excel\/"},"modified":"2024-12-21T21:24:19","modified_gmt":"2024-12-21T21:24:19","slug":"huong-dan-su-dung-ham-sequence-co-ban-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-sequence-co-ban-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m SEQUENCE c\u01a1 b\u1ea3n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><a href=\"http:\/\/blog.ezworkapp.com\/ham-sequence-co-ban-trong-excel.html\"><strong>H\u00e0m SEQUENCE<\/strong> <\/a>l\u00e0 m\u1ed9t h\u00e0m hi\u1ec7n t\u1ea1i ch\u1ec9 xu\u1ea5t hi\u1ec7n trong phi\u00ean b\u1ea3n Office 365. H\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n t\u1ea1o m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ed1 li\u00ean ti\u1ebfp trong m\u1ed9t m\u1ea3ng. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y,<strong><a href=\"http:\/\/blog.ezworkapp.com\/\"> H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd \u0111\u01b0a ra nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n h\u00e0m.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6767320292770\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-sequence-co-ban-trong-excel.html#Ham_SEQUENCE_tao_danh_sach_so_lien_tiep\" title=\"H\u00e0m SEQUENCE t\u1ea1o danh s\u00e1ch s\u1ed1 li\u00ean ti\u1ebfp\">H\u00e0m SEQUENCE t\u1ea1o danh s\u00e1ch s\u1ed1 li\u00ean ti\u1ebfp<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-sequence-co-ban-trong-excel.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-sequence-co-ban-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-sequence-co-ban-trong-excel.html#Danh_so_thu_tu\" title=\"\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-sequence-co-ban-trong-excel.html#Tao_danh_sach_thang_ngay_trong_thang%E2%80%A6\" title=\"T\u1ea1o danh s\u00e1ch th\u00e1ng, ng\u00e0y trong th\u00e1ng\u2026\">T\u1ea1o danh s\u00e1ch th\u00e1ng, ng\u00e0y trong th\u00e1ng\u2026<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-sequence-co-ban-trong-excel.html#Lap_bang_cuu_chuong_voi_SEQUENCE\" title=\"L\u1eadp b\u1ea3ng c\u1eedu ch\u01b0\u01a1ng v\u1edbi SEQUENCE\">L\u1eadp b\u1ea3ng c\u1eedu ch\u01b0\u01a1ng v\u1edbi SEQUENCE<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_SEQUENCE_tao_danh_sach_so_lien_tiep\"><\/span>H\u00e0m SEQUENCE t\u1ea1o danh s\u00e1ch s\u1ed1 li\u00ean ti\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SEQUENCE nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=<strong>SEQUENCE(row, [column], [start], [step])<\/strong><\/em><\/p>\n<\/blockquote>\n<p>Th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c:<\/p>\n<p><strong>row<\/strong>: s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng \u0111\u00e1nh s\u1ed1. VD v\u1edbi 10 h\u00e0ng, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 1 m\u1ea3ng t\u1eeb 1 t\u1edbi 10.<\/p>\n<p>Th\u00e0nh ph\u1ea7n kh\u00f4ng b\u1eaft bu\u1ed9c:<\/p>\n<p><strong>column<\/strong>: s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t \u0111\u00e1nh s\u1ed1, m\u1eb7c \u0111\u1ecbnh l\u00e0 1.<\/p>\n<p><strong>start<\/strong>: s\u1ed1 \u0111\u1ea7u ti\u00ean trong m\u1ea3ng, m\u1eb7c \u0111\u1ecbnh l\u00e0 1.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-735.gif\" title=\"ex101_92019-nho-735\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>step<\/strong>: kho\u1ea3ng c\u00e1ch nh\u1ea3y b\u1eadc gi\u1eefa c\u00e1c s\u1ed1, m\u1eb7c \u0111\u1ecbnh l\u00e0 1. N\u1ebfu gi\u00e1 tr\u1ecb step thay \u0111\u1ed5i, ch\u1eb3ng h\u1ea1n b\u1eb1ng 3, ta s\u1ebd c\u00f3 d\u00e3y 1, 4, 7\u2026<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi h\u00e0m SEQUENCE, ta c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o nh\u1eefng tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Danh_so_thu_tu\"><\/span>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>H\u00e0m SEQUENCE s\u1ebd thay th\u1ebf thao t\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html\">\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 v\u1edbi Autofill<\/a> th\u00f4ng th\u01b0\u1eddng. \u0110\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb 1 \u0111\u1ebfn 20, c\u00f4ng th\u1ee9c c\u1ee7a ta nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=SEQUENCE(20)<\/em><\/p>\n<\/blockquote>\n<figure id=\"attachment_29287\" aria-describedby=\"caption-attachment-29287\" style=\"width: 360px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29287 size-full\" title=\"huong-dan-su-dung-ham-sequence-trong-excel-1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sequence-1.png\" alt=\"huong-dan-su-dung-ham-sequence-trong-excel-1\" width=\"360\" height=\"473\"><figcaption id=\"caption-attachment-29287\" class=\"wp-caption-text\">huong-dan-su-dung-ham-sequence-trong-excel-1<\/figcaption><\/figure>\n<h5><span class=\"ez-toc-section\" id=\"Tao_danh_sach_thang_ngay_trong_thang%E2%80%A6\"><\/span>T\u1ea1o danh s\u00e1ch th\u00e1ng, ng\u00e0y trong th\u00e1ng\u2026<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>\u0110\u1ec3 t\u1ea1o danh s\u00e1ch th\u00e1ng ta s\u1ebd k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-date-co-ban-trong-excel.html\">h\u00e0m DATE<\/a> v\u00e0 SEQUENCE, sau \u0111\u00f3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i trong Format Cell:<\/p>\n<blockquote>\n<p><em>=DATE(2019,SEQUENCE(1,12),1)<\/em><\/p>\n<\/blockquote>\n<figure id=\"attachment_29290\" aria-describedby=\"caption-attachment-29290\" style=\"width: 1022px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29290 size-full\" title=\"huong-dan-su-dung-ham-sequence-trong-excel-2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sequence-2-1.png\" alt=\"huong-dan-su-dung-ham-sequence-trong-excel-2\" width=\"1022\" height=\"106\"><figcaption id=\"caption-attachment-29290\" class=\"wp-caption-text\">huong-dan-su-dung-ham-sequence-trong-excel-2<\/figcaption><\/figure>\n<p>Ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SEQUENCE \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o nhanh ch\u00f3ng t\u1ea5t c\u1ea3 ng\u00e0y trong th\u00e1ng nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>=SEQUENCE(DAY(EOMONTH(B$1,0)))<\/em><\/p>\n<\/blockquote>\n<p>Ti\u1ebfn h\u00e0nh autofill cho c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i:<\/p>\n<figure id=\"attachment_29291\" aria-describedby=\"caption-attachment-29291\" style=\"width: 878px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29291 size-full\" title=\"huong-dan-su-dung-ham-sequence-trong-excel-3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sequence-3.png\" alt=\"huong-dan-su-dung-ham-sequence-trong-excel-3huong-dan-su-dung-ham-sequence-trong-excel-3\" width=\"878\" height=\"529\"><figcaption id=\"caption-attachment-29291\" class=\"wp-caption-text\">huong-dan-su-dung-ham-sequence-trong-excel-3<\/figcaption><\/figure>\n<h5><span class=\"ez-toc-section\" id=\"Lap_bang_cuu_chuong_voi_SEQUENCE\"><\/span>L\u1eadp b\u1ea3ng c\u1eedu ch\u01b0\u01a1ng v\u1edbi SEQUENCE<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>B\u1eb1ng h\u00e0m SEQUENCE, ta c\u0169ng c\u00f3 th\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c b\u1ea3ng c\u1eedu ch\u01b0\u01a1ng nh\u01b0 sau:<\/p>\n<p><em>Ti\u00eau \u0111\u1ec1 b\u1ea3ng:\u00a0=SEQUENCE(1,10)<\/em><\/p>\n<figure id=\"attachment_29292\" aria-describedby=\"caption-attachment-29292\" style=\"width: 661px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29292 size-full\" title=\"huong-dan-su-dung-ham-sequence-trong-excel-4\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sequence-4.png\" alt=\"huong-dan-su-dung-ham-sequence-trong-excel-4\" width=\"661\" height=\"89\"><figcaption id=\"caption-attachment-29292\" class=\"wp-caption-text\">huong-dan-su-dung-ham-sequence-trong-excel-4<\/figcaption><\/figure>\n<p><em>D\u1eef li\u1ec7u b\u1ea3ng: B2=SEQUENCE($K$1,$B$1,B$1,B$1), sau \u0111\u00f3 autofill t\u1eeb C2:K2<\/em><\/p>\n<figure id=\"attachment_29294\" aria-describedby=\"caption-attachment-29294\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29294 size-full\" title=\"huong-dan-su-dung-ham-sequence-trong-excel-5\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-sequence-5.png\" alt=\"huong-dan-su-dung-ham-sequence-trong-excel-5\" width=\"650\" height=\"287\"><figcaption id=\"caption-attachment-29294\" class=\"wp-caption-text\">huong-dan-su-dung-ham-sequence-trong-excel-5<\/figcaption><\/figure>\n<p>Qua h\u01b0\u1edbng d\u1eabn t\u1ed5ng quan c\u1ee7a H\u1ecdc Excel Online c\u00e1c b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sequence ch\u01b0a? N\u1ebfu ch\u01b0a th\u00ec h\u00e3y cmt th\u1eafc m\u1eafc xu\u1ed1ng ph\u00eda d\u01b0\u1edbi nh\u00e9. H\u00e3y truy c\u1eadp v\u00e0o trang c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 t\u00ecm ki\u1ebfm th\u00eam c\u00e1c b\u00e0i vi\u1ebft chi ti\u1ebft v\u1ec1<strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-trong-excel-va-cac-vi-du-minh-hoa.html\"> c\u00e1c h\u00e0m trong Excel<\/a><\/strong><\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-mang-dong-vung-tran-trong-excel.html\"><strong>C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng v\u00e0 v\u00f9ng tr\u00e0n trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-toan-va-su-dung-ham-mang-dong-se-don-gian-hon-voi-excel-trong-nam-2019.html\">H\u00e0m m\u1ea3ng \u0111\u1ed9ng trong Excel 365<\/a><\/strong><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-735.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8130,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8129"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8129\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8130"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}