{"id":7292,"date":"2024-12-21T17:14:51","date_gmt":"2024-12-21T17:14:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chon-hang-loat-hang-cach-nhau-mot-hoac-n-hang-trong-excel\/"},"modified":"2024-12-21T17:14:51","modified_gmt":"2024-12-21T17:14:51","slug":"cach-chon-hang-loat-hang-cach-nhau-mot-hoac-n-hang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chon-hang-loat-hang-cach-nhau-mot-hoac-n-hang-trong-excel\/","title":{"rendered":"C\u00e1ch ch\u1ecdn h\u00e0ng lo\u1ea1t h\u00e0ng c\u00e1ch nhau m\u1ed9t ho\u1eb7c N h\u00e0ng trong Excel"},"content":{"rendered":"
\n

Khi ch\u00fang ta s\u1eed d\u1ee5ng m\u1ed9t b\u1ea3ng t\u00ednh, \u0111\u00f4i khi ch\u00fang ta c\u1ea7n ph\u1ea3i ch\u1ecdn h\u00e0ng c\u00e1ch nhau 1 ho\u1eb7c n h\u00e0ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng, xo\u00e1 ho\u1eb7c sao ch\u00e9p. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ch\u00fang theo c\u00e1ch th\u1ee7 c\u00f4ng, nh\u01b0ng n\u1ebfu c\u00f3 h\u00e0ng tr\u0103m h\u00e0ng, ph\u01b0\u01a1ng ph\u00e1p n\u00e0y kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1ed1t.<\/p>\n

Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i s\u1ebd ch\u1ecdn c\u00e1c h\u00e0ng c\u00e1ch nhau. V\u1edbi m\u00e3 VBA, t\u00f4i l\u00e0m nh\u01b0 sau:<\/p>\n

1. Ch\u1ecdn d\u00e3y d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ch\u1ecdn m\u1ed7i h\u00e0ng ho\u1eb7c N h\u00e0ng<\/p>\n

2. Nh\u1ea5p Developer<\/strong> > Visual Basic<\/strong>, m\u1ed9t c\u1eeda s\u1ed5 Microsoft Visual Basic for applications<\/strong> s\u1ebd xu\u1ea5t hi\u1ec7n, nh\u1ea5n Insert<\/strong> > Module, <\/strong>v\u00e0 ch\u00e8n \u0111o\u1ea1n m\u00e3 sau v\u00e0o Module:<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
\n
\u00a0<\/code><\/div>\n
3. Nh\u1ea5p v\u00e0o n\u00fat \"doc-multiply-calculation-3\"\"doc-multiply-calculation-3\" \u0111\u1ec3 ch\u1ea1y m\u00e3. M\u1ed9t h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n y\u00eau c\u1ea7u ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u.<\/div>\n
<\/div>\n
4. Nh\u1ea5n OK. M\u1ed9t h\u1ed9p tho\u1ea1i kh\u00e1c xu\u1ea5t hi\u1ec7n y\u00eau c\u1ea7u ch\u1ecdn h\u00e0ng ph\u00e2n c\u00e1ch, tr\u01b0\u1eddng h\u1ee3p n\u00e0y t\u00f4i nh\u1eadp 3.<\/div>\n
<\/div>\n
5. Nh\u1ea5n OK. V\u00e0 b\u00e2y gi\u1edd c\u1ee9 m\u1ed7i 3 h\u00e0ng ph\u00e2n c\u00e1ch th\u00ec c\u00f3 m\u1ed9t h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/div>\n
<\/div>\n
<\/div>\n<\/div>\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":"

Khi ch\u00fang ta s\u1eed d\u1ee5ng m\u1ed9t b\u1ea3ng t\u00ednh, \u0111\u00f4i khi ch\u00fang ta c\u1ea7n ph\u1ea3i ch\u1ecdn..<\/p>\n","protected":false},"author":1,"featured_media":7293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7292","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7292","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=7292"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7292\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7293"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}