{"id":1927,"date":"2021-01-19T12:42:56","date_gmt":"2021-01-19T05:42:56","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1927"},"modified":"2021-04-14T11:43:32","modified_gmt":"2021-04-14T04:43:32","slug":"data-validation-nang-cao","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/data-validation-nang-cao\/","title":{"rendered":"Data Validation N\u00e2ng Cao T\u1ea1o List C\u00f3 \u0110i\u1ec1u Ki\u1ec7n L\u00e0 B\u1ed9i S\u1ed1 C\u1ee7a M\u1ed9t S\u1ed1 Ho\u1eb7c T\u0103ng D\u1ea7n Theo Th\u1ee9 T\u1ef1"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1927\" class=\"elementor elementor-1927\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8a48740 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a48740\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-93d686a\" data-id=\"93d686a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a647a17 elementor-widget elementor-widget-text-editor\" data-id=\"a647a17\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong b\u00e0i vi\u1ebft <\/span><a href=\"https:\/\/hoctin.vn\/data-validation-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Data Validation Trong Excel<\/a><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, hoctin.vn \u0111\u00e3 gi\u1edbi thi\u1ec7u v\u1ec1 c\u00e1ch t\u1ea1o menu x\u1ed5 xu\u1ed1ng c\u01a1 b\u1ea3n trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng Data Validation n\u00e2ng cao \u0111\u1ec3 t\u1ea1o list c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 1 s\u1ed1 ho\u1eb7c list \u0111\u01b0\u1ee3c nh\u1eadp t\u0103ng d\u1ea7n trong Excel b\u1eb1ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m MOD, OFFSET.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-af754b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"af754b3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4654d09\" data-id=\"4654d09\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b9af7c elementor-widget elementor-widget-text-editor\" data-id=\"0b9af7c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-830d74fa-7fff-d518-3071-9d2b5a6d8360\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 t\u1ea1o \u1ee9ng Data Validation n\u00e2ng cao v\u00e0o vi\u1ec7c x\u00e1c th\u1ef1c d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n Custom, c\u00f9ng \u00f4n l\u1ea1i c\u00e1ch t\u1ea1o Data Validation (\u0111\u00e3 \u0111\u01b0\u1ee3c m\u00ecnh n\u00eau \u1edf b\u00e0i vi\u1ebft tr\u01b0\u1edbc) b\u1eb1ng c\u00e1ch ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u s\u1ebd nh\u1eadp v\u00e0 ch\u1ecdn ch\u1ee9c n\u0103ng tr\u00ean tab Data:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-61b4965 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"61b4965\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9a91ede\" data-id=\"9a91ede\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dcc9564 elementor-widget elementor-widget-image\" data-id=\"dcc9564\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/12\/cach-tao-data-validation-vao-tab-data-tren-thanh-ribbon-chon-data-validation.png\" title=\"cach-tao-data-validation-vao-tab-data-tren-thanh-ribbon-chon-data-validation\">&gt; Ch\u1ecdn Data Validation 2 l\u1ea7n \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\" \/&gt;\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b6a0c64 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b6a0c64\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6eac2ba\" data-id=\"6eac2ba\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16f3e39 elementor-widget elementor-widget-text-editor\" data-id=\"16f3e39\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y v\u1ec1 c\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 d\u1eef li\u1ec7u l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 1 s\u1ed1 (v\u00ed d\u1ee5 s\u1ed1 4) v\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 d\u1eef li\u1ec7u nh\u1eadp trong d\u00f2ng d\u01b0\u1edbi kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1ecf h\u01a1n d\u1eef li\u1ec7u c\u00f9ng c\u1ed9t n\u1eb1m \u1edf d\u00f2ng tr\u01b0\u1edbc \u0111\u00f3.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c166999 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c166999\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e8b23a8\" data-id=\"e8b23a8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8e4e694 elementor-widget elementor-widget-heading\" data-id=\"8e4e694\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-95d48d8f-7fff-a6e1-e0fd-c98bf100348a\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, V\u00ed D\u1ee5 Data Validation N\u00e2ng Cao: \u0110i\u1ec1u Ki\u1ec7n S\u1ed1 \u0110\u01b0\u1ee3c Nh\u1eadp Ph\u1ea3i L\u00e0 B\u1ed9i S\u1ed1 C\u1ee7a 1 S\u1ed1<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fd34593 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd34593\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d5e31b4\" data-id=\"d5e31b4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8d99974 elementor-widget elementor-widget-text-editor\" data-id=\"8d99974\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-c9ffa9e8-7fff-d729-e8ef-714fbd3d0659\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u1ea7n vi\u1ebft h\u00e0m =MOD(A4,4)=0 \u0111\u1ec3 \u00f4 A4 chia h\u1ebft cho 4. C\u00e1c \u00f4 sau A5, A6,&#8230; s\u1ebd nh\u1ea3y c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ffbf474 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ffbf474\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bfc6ed9\" data-id=\"bfc6ed9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e7b6454 elementor-widget elementor-widget-image\" data-id=\"e7b6454\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2021\/01\/xac-thuc-du-lieu-data-validation-boi-so-cua-1-so.png\" title=\"xac-thuc-du-lieu-data-validation-boi-so-cua-1-so\" alt=\"S\u1eed d\u1ee5ng data validation n\u00e2ng cao k\u1ebft h\u1ee3p h\u00e0m MOD \u0110\u1ec3 \u0110i\u1ec1u Ki\u1ec7n S\u1ed1 \u0110\u01b0\u1ee3c Nh\u1eadp Ph\u1ea3i L\u00e0 B\u1ed9i S\u1ed1 C\u1ee7a 1 S\u1ed1\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-29a2936 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"29a2936\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6c26eab\" data-id=\"6c26eab\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c89e911 elementor-widget elementor-widget-heading\" data-id=\"c89e911\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, V\u00ed D\u1ee5 Data Validation N\u00e2ng Cao: <\/span><\/span><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110i\u1ec1u Ki\u1ec7n \u0110\u1ec3 Nh\u1eadp Ng\u00e0y Th\u00e1ng Kh\u00f4ng Nh\u1ecf H\u01a1n D\u1eef Li\u1ec7u \u0110\u00e3 Nh\u1eadp Tr\u01b0\u1edbc \u0110\u00f3<\/span><span style=\"font-style: inherit;\"><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5b8fd9f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b8fd9f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e0e85ee\" data-id=\"e0e85ee\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-873c5a7 elementor-widget elementor-widget-text-editor\" data-id=\"873c5a7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o v\u00f9ng \u00f4 c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">L\u01b0u \u00fd: \u00f4 A4 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean nh\u1eadp ng\u00e0y th\u00e1ng n\u0103m kh\u00f4ng c\u1ea7n cho v\u00e0o v\u00f9ng Data Validation v\u00ec kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 n\u00e0o v\u1edbi \u00f4 \u0111\u1ea7u ti\u00ean (\u0111i\u1ec1u ki\u1ec7n ch\u1ec9 b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 th\u1ee9 2 l\u00e0 \u00f4 sau kh\u00f4ng \u0111\u01b0\u1ee3c l\u1edbn h\u01a1n \u00f4 tr\u01b0\u1edbc \u0111\u00f3).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-43acf64 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43acf64\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-76650b6\" data-id=\"76650b6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ef1bf7b elementor-widget elementor-widget-image\" data-id=\"ef1bf7b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2021\/01\/data-validation-nang-cao-de-gioi-han-ngay-thang-nhap-sau-khong-nho-hon-nhap-truoc.png\" title=\"data-validation-nang-cao-de-gioi-han-ngay-thang-nhap-sau-khong-nho-hon-nhap-truoc\" alt=\"\u0110i\u1ec1u Ki\u1ec7n DATA VALIDATION \u0110\u1ec3 Nh\u1eadp Ng\u00e0y Th\u00e1ng Kh\u00f4ng Nh\u1ecf H\u01a1n D\u1eef Li\u1ec7u \u0110\u00e3 Nh\u1eadp Tr\u01b0\u1edbc \u0110\u00f3\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c5d969d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c5d969d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3001177\" data-id=\"3001177\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e3de042 elementor-widget elementor-widget-text-editor\" data-id=\"e3de042\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u1eafc h\u1eb3n c\u00e1c b\u1ea1n th\u1ea5y l\u1ea1 t\u1ea1i sao hoctin.vn kh\u00f4ng \u0111\u1eb7t start date l\u00e0 A4 lu\u00f4n thay v\u00ec ph\u1ea3i s\u1eed d\u1ee5ng c\u1ea5u tr\u00fac h\u00e0m:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">=OFFSET(reference, rows, cols, height, width)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a37c80e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a37c80e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8daee39\" data-id=\"8daee39\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8f88594 elementor-widget elementor-widget-text-editor\" data-id=\"8f88594\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-09dafc3b-7fff-7a9a-81ff-aa5284a0a683\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Nguy\u00ean nh\u00e2n v\u00ec n\u1ebfu ch\u1ec9 \u0111\u1eb7t Start date l\u00e0 1 \u00f4 ngay tr\u00ean \u00f4 c\u1ea7n nh\u1eadp th\u00ec khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng ti\u1ebfp theo c\u00e1ch \u0111\u00f3 v\u00e0i \u00f4 tr\u1ed1ng, ch\u1ee9c n\u0103ng Data Validation c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng c\u00f3 t\u00e1c d\u1ee5ng g\u00ec cho vi\u1ec7c r\u00e0ng bu\u1ed9c d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4ed0e09 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ed0e09\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-eba86a5\" data-id=\"eba86a5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5451afe elementor-widget elementor-widget-text-editor\" data-id=\"5451afe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-78aa403c-7fff-b1e6-7349-1e7e4ee43005\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Vi\u1ec7c \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p h\u00e0m OFFSET gi\u00fap Excel b\u00e1o l\u1ed7i khi b\u1ea1n nh\u1eadp c\u00e1ch d\u00f2ng nh\u01b0 sau:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ef6c7ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef6c7ca\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-657869b\" data-id=\"657869b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ea3df2 elementor-widget elementor-widget-image\" data-id=\"1ea3df2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2021\/01\/excel-bao-loi-khi-nhap-ngay-khong-nam-trong-pham-vi-xac-thuc-du-lieu.png\" title=\"excel-bao-loi-khi-nhap-ngay-khong-nam-trong-pham-vi-xac-thuc-du-lieu\" alt=\"Excel b\u00e1o l\u1ed7i khi nh\u1eadp d\u1eef li\u1ec7u ch\u01b0a \u0111\u01b0\u1ee3c x\u00e1c th\u1ef1c theo Data Validation\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3c63a92 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c63a92\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-33cb03b\" data-id=\"33cb03b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-51ca38b elementor-widget elementor-widget-text-editor\" data-id=\"51ca38b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Gi\u1ea3i th\u00edch \u00fd ngh\u0129a h\u00e0m OFFSET($A$4,0,0,ROW(A5)-4,1):<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9b2ea7f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b2ea7f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-46b2176\" data-id=\"46b2176\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-128bba3 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"128bba3\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-c03d6dc4-7fff-463d-09ca-2105c8bc550d\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Reference l\u00e0 $A$$ \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh l\u00e0 \u0111i\u1ec3m l\u00e0m m\u1ed1c.<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-aa9f43ed-7fff-6091-178f-f28ca172295d\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Rows = 0, Cols = 0: S\u1ed1 h\u00e0ng\/c\u1ed9t di chuy\u1ec3n t\u1eeb \u0111i\u1ec3m l\u00e0m g\u1ed1c ($A$4).<\/span><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Height = ROW(A5)-4; Width =1: Chi\u1ec1u cao, t\u00ednh b\u1eb1ng s\u1ed1 h\u00e0ng v\u00e0 chi\u1ec1u r\u1ed9ng, t\u00ednh b\u1eb1ng s\u1ed1 c\u1ed9t, m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu tr\u1ea3 v\u1ec1.<\/span><\/span><br><span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Height \u0111\u01b0\u1ee3c vi\u1ebft l\u00e0 c\u00f4ng th\u1ee9c h\u00e0m trong khi Width c\u1ed1 \u0111\u1ecbnh b\u1eb1ng 1 v\u00ec chi\u1ec1u cao s\u1ebd thay \u0111\u1ed5i t\u01b0\u01a1ng \u1ee9ng, <i>v\u00ed d\u1ee5 t\u1ea1i \u00f4 A6 th\u00ec ph\u1ea1m vi tr\u1ea3 v\u1ec1 l\u00e0 ROW(A6)-4= 2 d\u00f2ng v\u00e0 1 c\u1ed9t b\u1eaft \u0111\u1ea7u t\u1eeb A4 &gt;&gt; l\u00e0 $A$4:A5; t\u1ea1i \u00f4 A8 th\u00ec ph\u1ea1m vi l\u00e0 4 d\u00f2ng v\u00e0 1 c\u1ed9t &gt;&gt; l\u00e0 $A$4:A7.<\/i><\/span><\/span><i><\/i><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c6a4a77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6a4a77\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-696dc4a\" data-id=\"696dc4a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c6cba6d elementor-widget elementor-widget-text-editor\" data-id=\"c6cba6d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-211e9604-7fff-5b99-b43a-9283b49f946f\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m OFFSET($A$4,0,0,1,1) tr\u1ea3 v\u1ec1 m\u1ed9t ph\u1ea1m vi tham chi\u1ebfu t\u00ednh t\u1eeb \u00f4 $A$4 (v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u nh\u1eadp ng\u00e0y \u0111\u1ea7u ti\u00ean) \u0111\u1ebfn \u00f4 li\u1ec1n k\u1ec1 tr\u01b0\u1edbc \u00f4 \u0111\u1eb7t c\u00f4ng th\u1ee9c.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-39402b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"39402b2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f8f1b60\" data-id=\"f8f1b60\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bec560f elementor-widget elementor-widget-text-editor\" data-id=\"bec560f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn th\u00eam h\u00e0m MAX k\u1ebft h\u1ee3p h\u00e0m OFFSET \u0111\u1ec3 th\u1ee9 t\u1ef1 \u00f4 c\u1ea7n nh\u1eadp ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n. <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">Khi \u0111\u00f3, vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u s\u1ebd \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c x\u00e1c th\u1ef1c nh\u01b0 y\u00eau c\u1ea7u:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1aaf032 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1aaf032\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3367850\" data-id=\"3367850\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e2c0439 elementor-widget elementor-widget-image\" data-id=\"e2c0439\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2021\/01\/data-validation-nang-cao-de-gioi-han-ngay-thang-nhap.png\" title=\"data-validation-nang-cao-de-gioi-han-ngay-thang-nhap\" alt=\"nh\u1eadp d\u1eef li\u1ec7u s\u1ebd \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c x\u00e1c th\u1ef1c nh\u01b0 y\u00eau c\u1ea7u c\u1ee7a Data Validation\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4b05da9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b05da9\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0e095f9\" data-id=\"0e095f9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78664bc elementor-widget elementor-widget-text-editor\" data-id=\"78664bc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 20pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 1 s\u1ed1 v\u00ed d\u1ee5 Data Validation N\u00e2ng Cao Trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 20pt;\"><span style=\"color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 c\u00e1c c\u00e1ch x\u00e1c th\u1ef1c d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o trong Excel v\u1edbi Data Validation.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-80524de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"80524de\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9f7beac\" data-id=\"9f7beac\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e45243f elementor-widget elementor-widget-text-editor\" data-id=\"e45243f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p><p><i><b><a href=\"https:\/\/hoctin.vn\/pivot-table-trong-excel\/\" target=\"_blank\">S\u1eed D\u1ee5ng Pivot Table \u0110\u1ec3 Ph\u00e2n T\u00edch D\u1eef Li\u1ec7u<\/a><br><\/b><\/i><\/p><p><i><b><a href=\"https:\/\/hoctin.vn\/pivot-table-nang-cao\/\" target=\"_blank\">Pivot Table N\u00e2ng Cao<\/a><br><\/b><\/i><\/p><p><a href=\"https:\/\/hoctin.vn\/cach-xoa-dong-trong-trong-excel\/\" target=\"_blank\"><i><b>C\u00e1ch X\u00f3a D\u00f2ng Tr\u1ed1ng Trong Excel<\/b><\/i><\/a><br><\/p><a href=\"https:\/\/hoctin.vn\/pivot-table-nang-cao\/\" target=\"_blank\"><\/a>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Trong b\u00e0i vi\u1ebft Data Validation Trong Excel, hoctin.vn \u0111\u00e3 gi\u1edbi thi\u1ec7u v\u1ec1 c\u00e1ch t\u1ea1o menu x\u1ed5 xu\u1ed1ng c\u01a1 b\u1ea3n trong Excel. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng Data Validation n\u00e2ng cao \u0111\u1ec3 t\u1ea1o list c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 1 s\u1ed1 ho\u1eb7c list \u0111\u01b0\u1ee3c nh\u1eadp t\u0103ng d\u1ea7n trong &#8230; <a title=\"Data Validation N\u00e2ng Cao T\u1ea1o List C\u00f3 \u0110i\u1ec1u Ki\u1ec7n L\u00e0 B\u1ed9i S\u1ed1 C\u1ee7a M\u1ed9t S\u1ed1 Ho\u1eb7c T\u0103ng D\u1ea7n Theo Th\u1ee9 T\u1ef1\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/data-validation-nang-cao\/\">Read more <span class=\"screen-reader-text\">Data Validation N\u00e2ng Cao T\u1ea1o List C\u00f3 \u0110i\u1ec1u Ki\u1ec7n L\u00e0 B\u1ed9i S\u1ed1 C\u1ee7a M\u1ed9t S\u1ed1 Ho\u1eb7c T\u0103ng D\u1ea7n Theo Th\u1ee9 T\u1ef1<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1929,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[81,82],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1927"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=1927"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1929"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}