{"id":8112,"date":"2024-12-21T21:21:19","date_gmt":"2024-12-21T21:21:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-so-tu-nhien-ngau-nhien-khong-trung-trong-khoang\/"},"modified":"2024-12-21T21:21:19","modified_gmt":"2024-12-21T21:21:19","slug":"cach-tao-so-tu-nhien-ngau-nhien-khong-trung-trong-khoang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tao-so-tu-nhien-ngau-nhien-khong-trung-trong-khoang\/","title":{"rendered":"C\u00e1ch t\u1ea1o s\u1ed1 t\u1ef1 nhi\u00ean ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng trong kho\u1ea3ng"},"content":{"rendered":"
\n

C\u00e1ch t\u1ea1o s\u1ed1 t\u1ef1 nhi\u00ean ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng trong kho\u1ea3ng:<\/strong><\/p>\n

B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n C\u00e1ch t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng trong kho\u1ea3ng b\u1eb1ng 1 c\u00f4ng th\u1ee9c Excel. B\u1ea1n h\u00e3y l\u00e0m theo h\u01b0\u1edbng d\u1eabn nh\u01b0 sau \u0111\u1ec3 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng trong 1 kho\u1ea3ng:<\/p>\n

V\u1ea5n \u0111\u1ec1: t\u1ea1o ra 100 s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 500 cho 100 anh em.
\nGi\u1ea3i ph\u00e1p: l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1: Thi\u1ebft l\u1eadp kho\u1ea3ng gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n l\u1ea5y s\u1ed1 ng\u1eabu nhi\u00ean.
\nB1 = 1
\nB2 = 500<\/p>\n

B\u01b0\u1edbc 2: Trong \u00f4 E4 nh\u1eadp c\u00f4ng th\u1ee9c sau \u0111\u00e2y v\u00e0o (\u1ea4n CTRL + SHIFT + ENTER v\u00ec l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng):<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean th\u00ec B1 v\u00e0 B2 l\u00e0 kho\u1ea3ng b\u1ea1n c\u1ea7n l\u1ea5y s\u1ed1 ng\u1eabu nhi\u00ean. Sau khi nh\u1eadp c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o \u00f4 E4 xong, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o xu\u1ed1ng ph\u00eda d\u01b0\u1edbi 100 \u00f4. T\u1ea5t nhi\u00ean l\u00e0 b\u1ea1n KH\u00d4NG th\u1ec3 t\u1ea1o ra h\u01a1n 500 s\u1ed1 t\u1ef1 nhi\u00ean ng\u1eabu nhi\u00ean trong Excel trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 500 r\u1ed3i.<\/p>\n

\u2014\u2014\u2014<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u00a0 \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n

To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/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":8113,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8112","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\/8112","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=8112"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8112\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8113"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}