{"id":10655,"date":"2025-01-14T22:42:16","date_gmt":"2025-01-14T22:42:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tao-data-validation-voi-name-dong-trong-excel-voi-ham-offset-va-counta\/"},"modified":"2025-01-14T22:42:16","modified_gmt":"2025-01-14T22:42:16","slug":"tao-data-validation-voi-name-dong-trong-excel-voi-ham-offset-va-counta","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tao-data-validation-voi-name-dong-trong-excel-voi-ham-offset-va-counta\/","title":{"rendered":"T\u1ea1o data validation v\u1edbi name \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m Offset v\u00e0 counta"},"content":{"rendered":"
\n

Trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh, b\u1ea1n \u0111\u00e3 g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i m\u1edf r\u1ed9ng danh s\u00e1ch dropdown c\u1ee7a t\u00ednh n\u0103ng data validation, s\u1ebd th\u1eadt l\u00e0 t\u1ed1t n\u1ebfu ch\u00fang ta kh\u00f4ng ph\u1ea3i v\u00e0o h\u1ed9p tho\u1ea1i Data Validation sau \u0111\u00f3 k\u00e9o l\u1ea1i v\u00f9ng c\u00f4ng th\u1ee9c m\u00e0 ch\u1ec9 c\u1ea7n vi\u1ebft th\u00eam v\u00e0o danh s\u00e1ch \u0111\u00e3 chu\u1ea9n b\u1ecb s\u1eb5n l\u00e0 dropdown validation c\u1ee7a ch\u00fang ta s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt theo:<\/p>\n

<\/a><\/p>\n

C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1<\/strong>: ch\u00fang ta \u0111i t\u1ea1o 1 Name Range \u0111\u1ed9ng (ti\u1ebfng Anh: Dynamic Name Range) b\u1eb1ng c\u00e1ch b\u1ea5m v\u00e0o th\u1ebb Formulas \/ Define Name<\/p>\n

Sau \u0111\u00f3 nh\u1eadp nh\u01b0 h\u00ecnh minh h\u1ecda:<\/p>\n

Ch\u00fa \u00fd: Trong h\u00ecnh minh h\u1ecda, d\u1ea5u ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c tham s\u1ed1 c\u1ee7a c\u00f4ng th\u1ee9c l\u00e0 d\u1ea5u \u201c;\u201d, c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd ph\u1ea3i chuy\u1ec3n th\u00e0nh d\u1ea5u \u201c,\u201d \u0111\u1ec3 tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng.<\/p>\n

C\u00f4ng th\u1ee9c:<\/p>\n

=OFFSET(Sheet1!$A$1;0;0;COUNTA(Sheet1!$A:$A);1)\r\n\r\nho\u1eb7c\r\n\r\n=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)\r\n<\/strong><\/pre>\n
<\/a><\/p>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
B\u01b0\u1edbc 2<\/strong>: S\u1eed d\u1ee5ng name n\u00e0y trong ch\u1ee9c n\u0103ng Data Validation ( Th\u1ebb Data \/ Data Validation \/ Th\u1ebb Settings trong c\u1eeda s\u1ed5 hi\u1ec7n ra \/ Ch\u1ecdn Allow l\u00e0 List)<\/p>\n
<\/a><\/p>\n
Cu\u1ed1i c\u00f9ng, ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n
Thanh.<\/p>\n<\/div>\n
\n
Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n
T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n
H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n
HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n
\n
\u00a9  document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10656,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10655","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\/10655","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=10655"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10655\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10656"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}