{"id":8673,"date":"2024-12-24T12:25:04","date_gmt":"2024-12-24T12:25:04","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/huong-dan-thiet-lap-chi-duoc-nhap-so-tang-dan-trong-1-cot-trong-excel\/"},"modified":"2024-12-24T12:25:04","modified_gmt":"2024-12-24T12:25:04","slug":"huong-dan-thiet-lap-chi-duoc-nhap-so-tang-dan-trong-1-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/huong-dan-thiet-lap-chi-duoc-nhap-so-tang-dan-trong-1-cot-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 t\u0103ng d\u1ea7n trong 1 c\u1ed9t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong m\u1ed9t\u00a0s\u1ed1 c\u00f4ng vi\u1ec7c y\u00eau c\u1ea7u khi nh\u1eadp s\u1ed1\u00a0li\u1ec7u tr\u00ean\u00a0Excel ph\u1ea3i\u00a0\u0111\u1ea3m b\u1ea3o nguy\u00ean t\u1eafc s\u1ed1 li\u1ec7u t\u0103ng d\u1ea7n theo d\u00f2ng, s\u1ed1 nh\u1eadp sau ph\u1ea3i lu\u00f4n l\u1edbn h\u01a1n s\u1ed1 nh\u1eadp tr\u01b0\u1edbc. Y\u00eau c\u1ea7u n\u00e0y li\u00ean quan t\u1edbi\u00a0\u0111\u1eb7c th\u00f9 c\u00f4ng vi\u1ec7c, v\u00ed d\u1ee5 nh\u01b0 k\u1ef9 thu\u1eadt. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 thi\u1ebft l\u1eadp ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 t\u0103ng d\u1ea7n trong c\u00f9ng 1 c\u1ed9t trong Excel? Ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/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-676aa81f48da2\" 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\/huong-dan-cach-thiet-lap-chi-duoc-nhap-so-tang-dan-trong-cung-1-cot-trong-excel.html#Cach_thiet_lap_chi_duoc_nhap_so_tang_dan_trong_cung_1_cot_trong_Excel\" title=\"C\u00e1ch thi\u1ebft l\u1eadp ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 t\u0103ng d\u1ea7n trong c\u00f9ng 1 c\u1ed9t trong Excel\">C\u00e1ch thi\u1ebft l\u1eadp ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 t\u0103ng d\u1ea7n trong c\u00f9ng 1 c\u1ed9t trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-thiet-lap-chi-duoc-nhap-so-tang-dan-trong-cung-1-cot-trong-excel.html#Vi_du_ve_truong_hop_yeu_cau_nhap_so_tang_dan\" title=\"V\u00ed d\u1ee5 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u nh\u1eadp s\u1ed1\u00a0t\u0103ng d\u1ea7n\">V\u00ed d\u1ee5 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u nh\u1eadp s\u1ed1\u00a0t\u0103ng d\u1ea7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-thiet-lap-chi-duoc-nhap-so-tang-dan-trong-cung-1-cot-trong-excel.html#Cach_thuc_hien\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thiet_lap_chi_duoc_nhap_so_tang_dan_trong_cung_1_cot_trong_Excel\"><\/span>C\u00e1ch thi\u1ebft l\u1eadp ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 t\u0103ng d\u1ea7n trong c\u00f9ng 1 c\u1ed9t trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_ve_truong_hop_yeu_cau_nhap_so_tang_dan\"><\/span>V\u00ed d\u1ee5 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u nh\u1eadp s\u1ed1\u00a0t\u0103ng d\u1ea7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27303\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-thiet-lap-data-validation-nhap-so-tang-dan.png\" width=\"240\" height=\"244\" title=\"vi-du-thiet-lap-data-validation-nhap-so-tang-dan\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, c\u1ed9t A ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y, c\u1ed9t B ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 l\u0169y k\u1ebf.<\/p>\n<p>V\u1ec1\u00a0\u00fd ngh\u0129a c\u1ee7a t\u1eeb \u201cL\u0169y k\u1ebf\u201d l\u00e0 th\u1ec3 hi\u1ec7n s\u1ed1 t\u0103ng d\u1ea7n, s\u1ed1 li\u1ec7u sau b\u1eb1ng s\u1ed1 tr\u01b0\u1edbc\u00a0\u0111\u00f3 c\u1ed9ng th\u00eam v\u1edbi 1 l\u01b0\u1ee3ng nh\u1ea5t\u00a0\u0111\u1ecbnh.<\/p>\n<p>Do\u00a0\u0111\u00f3\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta c\u1ea7n quy\u00a0\u0111\u1ecbnh trong v\u00f9ng B2:B9, ch\u1ec9\u00a0\u0111\u01b0\u1ee3c nh\u1eadp s\u1ed1 theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, s\u1ed1 sau ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 tr\u01b0\u1edbc\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u kh\u00f4ng b\u1ecb sai.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thuc_hien\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ecdn v\u00f9ng B3:B9 (B\u1eaft\u00a0\u0111\u1ea7u\u00a0\u00e1p d\u1ee5ng t\u1eeb d\u00f2ng 3, v\u00ec\u00a0\u00f4 B2 l\u00e0\u00a0\u00f4\u00a0\u0111\u1ea7u ti\u00ean n\u00ean kh\u00f4ng quy\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ed9 l\u1edbn t\u1ea1i\u00a0\u00f4 n\u00e0y)<\/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-806.gif\" title=\"ex101_92019-nho-806\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u1ecdn th\u1ebb Data &gt; Data Validation<\/p>\n<p>Trong c\u1eeda s\u1ed5\u00a0Data Validation, thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<ul>\n<li>M\u1ee5c Allow: ch\u1ecdn Whole Number n\u1ebfu mu\u1ed1n ch\u1ec9 nh\u1eadp s\u1ed1\u00a0nguy\u00ean, ch\u1ecdn Decimal n\u1ebfu mu\u1ed1n nh\u1eadp c\u1ea3 s\u1ed1\u00a0th\u1eadp ph\u00e2n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27304\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiet-lap-data-validation-allow.png\" width=\"588\" height=\"413\" title=\"thiet-lap-data-validation-allow\"><\/p>\n<ul>\n<li>M\u1ee5c Data ch\u1ecdn\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (Greater then\u00a0or equal to)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27305\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiet-lap-data-validation-data-dieu-kien.png\" width=\"590\" height=\"411\" title=\"thiet-lap-data-validation-data-dieu-kien\"><\/p>\n<ul>\n<li>M\u1ee5c Minimum: s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27306\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dieu-kien-data-validation-number-tang-dan.png\" width=\"826\" height=\"412\" title=\"dieu-kien-data-validation-number-tang-dan\"><\/p>\n<p style=\"padding-left: 30px\">=OFFSET(B3,-1,0,1,1)<\/p>\n<p style=\"padding-left: 30px\"><strong>\u00dd ngh\u0129a:<\/strong><\/p>\n<p style=\"padding-left: 60px\">H\u00e0m\u00a0OFFSET s\u1ebd tr\u1ea3 v\u1ec1 tham chi\u1ebfu t\u00ednh t\u1eeb\u00a0\u00f4 B3 (t\u1ea1i v\u1ecb tr\u00ed\u00a0\u0111\u1eb7t Data Validation cho\u00a0\u00f4 B3), l\u00f9i l\u00ean tr\u00ean 1 d\u00f2ng, kh\u00f4ng thay\u00a0\u0111\u1ed5i v\u1ec1 c\u1ed9t,\u00a0\u0111\u1ed9 l\u1edbn l\u00e0 1 h\u00e0ng, 1 c\u1ed9t =&gt; K\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb trong\u00a0\u00f4 B2 (tr\u01b0\u1edbc\u00a0\u00f4 B3)<\/p>\n<p style=\"padding-left: 60px\">V\u00ec ch\u00fang ta\u00a0\u00e1p d\u1ee5ng Data Validation trong c\u1ea3 v\u00f9ng B3:B9 do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i t\u01b0\u01a1ng\u00a0\u1ee9ng theo t\u1eebng\u00a0\u00f4.\u00a0Khi sang\u00a0\u00f4 B4 th\u00ec h\u00e0m\u00a0OFFSET trong Data Validation s\u1ebd t\u1ef1 thay\u00a0\u0111\u1ed5i th\u00e0nh\u00a0=OFFSET(B4,-1,0,1,1)\u00a0\u0111\u1ec3 tham chi\u1ebfu t\u1edbi\u00a0\u00f4 B3<\/p>\n<p>Sau khi th\u1ef1c hi\u1ec7n xong, b\u1ea5m OK<\/p>\n<p>K\u1ebft qu\u1ea3 khi ch\u00fang ta nh\u1eadp d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27307\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-khi-nhap-khong-dung-dieu-kien.png\" width=\"774\" height=\"244\" title=\"loi-khi-nhap-khong-dung-dieu-kien\"><\/p>\n<p>T\u1ea1i v\u1ecb tr\u00ed\u00a0\u00f4 B7, nh\u1eadp s\u1ed1 nh\u1ecf h\u01a1n\u00a0\u00f4 B6 ch\u00fang ta s\u1ebd th\u1ea5y c\u00f3 th\u00f4ng b\u00e1o l\u1ed7i c\u1ee7a Data Validation th\u1ec3 hi\u1ec7n vi\u1ec7c nh\u1eadp li\u1ec7u kh\u00f4ng\u00a0\u0111\u00fang quy\u00a0\u0111\u1ecbnh\u00a0\u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n<p><strong>T\u1ed5ng k\u1ebft l\u1ea1i c\u00e1ch l\u00e0m theo h\u00ecnh d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-cach-lam-thiet-lap-data-validation-dk-tang-dan.png\" width=\"555\" height=\"240\" title=\"ket-qua-cach-lam-thiet-lap-data-validation-dk-tang-dan\"><\/p>\n<ul>\n<li>C\u1ed9t C th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp b\u1eb1ng Data Validation<\/li>\n<li>C\u1ed9t D th\u1ec3 hi\u1ec7n c\u00f4ng th\u1ee9c\u00a0\u00e1p d\u1ee5ng trong Data Validation t\u1ea1i t\u1eebng\u00a0\u00f4<\/li>\n<\/ul>\n<p>R\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n nh\u01b0ng c\u0169ng r\u1ea5t hi\u1ec7u qu\u1ea3\u00a0\u0111\u00fang kh\u00f4ng n\u00e0o? Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c v\u1ec1 ch\u1ee9c n\u0103ng Data Validation c\u1ee7a\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/data-validation-va-nhung-nguoi-ban-khong-dung-vba.html\">Data Validation v\u00e0 nh\u1eefng ng\u01b0\u1eddi b\u1ea1n (kh\u00f4ng d\u00f9ng VBA)<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Data Validation \u0111\u1ec3 nh\u1eadp nhanh d\u1eef li\u1ec7u t\u1eeb select box<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/danh-sach-data-validation-phu-thuoc-nhau-trong-excel.html\">T\u1ea1o Drop-down list c\u00f3 gi\u00e1 tr\u1ecb ph\u1ee5 thu\u1ed9c m\u1ed9t list kh\u00e1c<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-thay-doi-kich-thuoc-danh-sach-tha-xuong-trong-data-validation-bang-vba-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc danh s\u00e1ch th\u1ea3 xu\u1ed1ng trong Data Validation b\u1eb1ng VBA Excel<\/a><\/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-806.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8674,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8673","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\/8673","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=8673"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8673\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8674"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}