{"id":11810,"date":"2022-03-20T20:43:50","date_gmt":"2022-03-20T13:43:50","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11810"},"modified":"2022-03-20T22:44:34","modified_gmt":"2022-03-20T15:44:34","slug":"ham-random-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/","title":{"rendered":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11810&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Excel trong h\u1ecdc t\u1eadp, trong c\u00f4ng vi\u1ec7c th\u00ec h\u1eb3n b\u1ea1n c\u0169ng kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi <\/span><\/span><\/span><a href=\"https:\/\/teky.edu.vn\/blog\/\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m RANDOM trong Excel<\/span><\/span><\/b><\/a><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">. Tuy nhi\u00ean, v\u1eabn c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng l\u1ea7m t\u01b0\u1edfng r\u1eb1ng h\u00e0m RANDOM v\u00e0 h\u00e0m RAND l\u00e0 hai h\u00e0m kh\u00e1c nhau. Th\u1ef1c ch\u1ea5t, hai h\u00e0m n\u00e0y ch\u1ec9 l\u00e0 m\u1ed9t v\u00e0 RAND l\u00e0 c\u00e1ch vi\u1ebft ng\u1eafn g\u1ecdn h\u01a1n c\u1ee7a t\u1eeb RANDOM. V\u1eady h\u00e0m RANDOM \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o?<\/span><\/span><\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Dinh_nghia_cu_phap_ham_RANDOM_trong_excel\" >\u0110\u1ecbnh ngh\u0129a c\u00fa ph\u00e1p h\u00e0m RANDOM trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Cach_su_dung_ham_RAND_trong_Excel_doi_voi_so\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RAND trong Excel \u0111\u1ed1i v\u1edbi s\u1ed1<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#So_ngau_nhien_lon_hon_0_va_nho_hon_1\" >S\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n 0 v\u00e0 nh\u1ecf h\u01a1n 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#So_ngau_nhien_lon_hon_a_va_nho_hon_b\" >S\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n a v\u00e0 nh\u1ecf h\u01a1n b<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Cach_su_dung_ham_RAND_trong_Excel_doi_voi_chu\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RAND trong Excel \u0111\u1ed1i v\u1edbi ch\u1eef<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Chu_viet_hoa\" >Ch\u1eef vi\u1ebft hoa<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Chu_viet_thuong\" >Ch\u1eef vi\u1ebft th\u01b0\u1eddng<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Cach_khong_bi_lap_lai_du_lieu_khi_dung_ham_RANDOM_trong_Excel\" >C\u00e1ch kh\u00f4ng b\u1ecb l\u1eb7p l\u1ea1i d\u1eef li\u1ec7u khi d\u00f9ng h\u00e0m RANDOM trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Cong_thuc_1\" >C\u00f4ng th\u1ee9c 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#Cong_thuc_2\" >C\u00f4ng th\u1ee9c 2<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_nghia_cu_phap_ham_RANDOM_trong_excel\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110\u1ecbnh ngh\u0129a c\u00fa ph\u00e1p h\u00e0m RANDOM trong excel<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m RAND trong Excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean \u0111\u01b0\u1ee3c ph\u00e2n b\u1ed1 \u0111\u1ec1u, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 v\u00e0 nh\u1ecf h\u01a1n 1.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">M\u1ed7i khi trang t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n hay b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c, thay \u0111\u1ed5i s\u1ed1 li\u1ec7u, h\u00e0m RAND s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean m\u1edbi.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Th\u00f4ng th\u01b0\u1eddng, c\u00e1c h\u00e0m trong Excel \u0111\u1ec1u y\u00eau c\u1ea7u ph\u1ea3i c\u00f3 tham s\u1ed1, ngo\u1ea1i tr\u1eeb h\u00e0m RAND.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00fa ph\u00e1p<\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> h\u00e0m RANDOM trong Excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau: =RAND()<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11834 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-7.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-7-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_RAND_trong_Excel_doi_voi_so\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RAND trong Excel \u0111\u1ed1i v\u1edbi s\u1ed1<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m RANDOM trong Excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ea5y ra m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean trong ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh. \u0110\u00f3 c\u00f3 th\u1ec3 l\u00e0 ph\u1ea1m vi c\u00f3 s\u1eb5n c\u1ee7a h\u00e0m RAND ho\u1eb7c l\u00e0 ph\u1ea1m vi do b\u1ea1n t\u1ea1o ra.<\/span><\/span><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_ngau_nhien_lon_hon_0_va_nho_hon_1\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">S\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n 0 v\u00e0 nh\u1ecf h\u01a1n 1<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Mu\u1ed1n c\u00f3 s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 1, h\u00e3y d\u00f9ng c\u00f4ng th\u1ee9c:<\/span><\/span><\/span><\/p>\n<p style=\"text-align: center\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= RAND ()<\/span><\/span><\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11833 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-10.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-10-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_ngau_nhien_lon_hon_a_va_nho_hon_b\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">S\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n a v\u00e0 nh\u1ecf h\u01a1n b<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Mu\u1ed1n c\u00f3 s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng a v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng b, h\u00e3y d\u00f9ng c\u00f4ng th\u1ee9c:<\/span><\/span><\/span><\/p>\n<p><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= RAND () * (ba) + a<\/span><\/span><\/b><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u1eefng v\u00ed d\u1ee5 sau s\u1ebd gi\u00fap b\u1ea1n c\u1ea3m th\u1ea5y d\u1ec5 hi\u1ec3u h\u01a1n.<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Mu\u1ed1n c\u00f3 s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 18:<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= RAND () * (18-0) +0<\/span><\/span><\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11828 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-10.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-10-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Mu\u1ed1n c\u00f3 s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 23 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 100:<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= RAND () * (100-23) +23<\/span><\/span><\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11829 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-11.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-11-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_RAND_trong_Excel_doi_voi_chu\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RAND trong Excel \u0111\u1ed1i v\u1edbi ch\u1eef<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Kh\u00f4ng ch\u1ec9 cho ra k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean, <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m RANDOM trong Excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> c\u00f2n c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Mu\u1ed1n l\u1ea5y \u0111\u01b0\u1ee3c m\u1ed9t k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean, b\u1ea1n ph\u1ea3i k\u1ebft h\u1ee3p gi\u1eefa 3 h\u00e0m: RAND, INT, CHAR.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u01b0ng tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n bi\u1ebft r\u1eb1ng b\u1ea1n s\u1ebd l\u1ea5y k\u00fd t\u1ef1 t\u1eeb trong b\u1ea3ng m\u00e3 ASCII (American Standard Code for Information Interchange &#8211; Chu\u1ea9n m\u00e3 trao \u0111\u1ed5i th\u00f4ng tin Hoa K\u1ef3). \u0110\u00e2y l\u00e0 b\u1ed9 m\u00e3 h\u00f3a k\u00fd t\u1ef1 cho b\u1ea3ng ch\u1eef c\u00e1i Latinh v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 hi\u1ec3n th\u1ecb v\u0103n b\u1ea3n trong m\u00e1y t\u00ednh. V\u1eady n\u00ean, b\u1ea1n h\u00e3y nh\u1edb: c\u00e1c ch\u1eef vi\u1ebft hoa c\u00f3 v\u1ecb tr\u00ed t\u1eeb m\u00e3 65 &#8211; 90 trong b\u1ea3ng m\u00e3, c\u00e1c ch\u1eef vi\u1ebft th\u01b0\u1eddng c\u00f3 v\u1ecb tr\u00ed t\u1eeb m\u00e3 97 \u0111\u1ebfn 122 trong b\u1ea3ng m\u00e3.<\/span><\/span><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chu_viet_hoa\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ch\u1eef vi\u1ebft hoa<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><i><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch 1:\u00a0<\/span><\/span><\/span><\/i><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m RAND \u0111\u1ec3 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 65 &#8211; 90.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11831 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-9.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-9-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ti\u1ebfp theo, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m INT \u0111\u1ec3 l\u00e0m tr\u00f2n \u0111\u1ebfn m\u1ed9t s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11830 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-10.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-10-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00e0 cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng h\u00e0m CHAR \u0111\u1ec3 l\u1ea5y k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean vi\u1ebft hoa.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11832 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-10.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-10-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><i><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch 2:<\/span><\/span><\/span><\/i><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"> B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u1ea3 3 h\u00e0m v\u00e0o c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11822 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-1.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/12-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chu_viet_thuong\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ch\u1eef vi\u1ebft th\u01b0\u1eddng<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u1ea1n ch\u1ec9 c\u1ea7n l\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u0111\u1ed1i v\u1edbi ch\u1eef vi\u1ebft hoa v\u00e0 thay \u0111\u1ed5i s\u1ed1 t\u1eeb 97 \u0111\u1ebfn 122.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">S\u1eed d\u1ee5ng h\u00e0m RAND:<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11825 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-1.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">S\u1eed d\u1ee5ng h\u00e0m INT:<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11823 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-1.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/13-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">S\u1eed d\u1ee5ng h\u00e0m CHAR:<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11824 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-1.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/14-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">K\u1ebft h\u1ee3p 3 h\u00e0m:<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11826 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-2.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/16-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">L\u01b0u \u00fd:\u00a0<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Trong qu\u00e1 tr\u00ecnh b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c, s\u1ed1 li\u1ec7u s\u1ebd b\u1ecb thay \u0111\u1ed5i gi\u1ed1ng nh\u01b0 nh\u1eefng b\u1ee9c \u1ea3nh minh h\u1ecda \u1edf tr\u00ean. N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n \u0111i\u1ec1u n\u00e0y x\u1ea3y ra, sau khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c xong h\u00e3y nh\u1ea5n F9 r\u1ed3i Enter. L\u00e0m nh\u01b0 v\u1eady, k\u1ebft qu\u1ea3 trong \u00f4 s\u1ebd chuy\u1ec3n sang d\u1ea1ng gi\u00e1 tr\u1ecb.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c sau:<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ch\u1ecdn c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c ng\u1eabu nhi\u00ean v\u00e0 nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p ch\u00fang.<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Nh\u1ea5p chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mu\u1ed1n, nh\u1ea5n Shift F10 r\u1ed3i nh\u1ea5n V ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn Paste Special r\u1ed3i ch\u1ecdn Value Feature.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <\/span><\/span><a href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\"><em><strong><span style=\"color: #0000ff\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch th\u00eam c\u1ed9t trong excel<\/span><\/span><\/span><\/strong><\/em><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khong_bi_lap_lai_du_lieu_khi_dung_ham_RANDOM_trong_Excel\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch kh\u00f4ng b\u1ecb l\u1eb7p l\u1ea1i d\u1eef li\u1ec7u khi d\u00f9ng h\u00e0m RANDOM trong Excel<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ch\u1eafc ch\u1eafn s\u1ebd c\u00f3 nh\u1eefng l\u00fac b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng m\u1ed9t d\u00e3y c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean nh\u01b0ng ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p tr\u00f9ng l\u1eb7p v\u1edbi nhau. Tuy nhi\u00ean <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m RANDOM trong Excel <\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">kh\u00f4ng c\u00f3 s\u1eb5n t\u00ednh n\u0103ng n\u00e0y. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t trong nh\u1eefng c\u00e1ch t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean duy nh\u1ea5t b\u1eb1ng c\u00f4ng th\u1ee9c.<\/span><\/span><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_1\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c 1<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: center\"><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= IF (ROW () &#8211; ROW (H $ 1) +1&gt; $ D $ 1\/2, &#8220;&#8221;, RANK (OFFSET ($ E $ 1, ROW () &#8211; ROW (H $ 1) + (COLUMN () &#8211; COLUMN ($ H1)) * ($ D $ 1\/2),), $ E $ 1: INDEX ($ E $ 1: $ E $ 1000, $ D $ 1)))<\/span><\/span><\/strong><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Gi\u1ea3 thuy\u1ebft \u0111\u01b0\u1ee3c \u0111\u1eb7t ra l\u00e0 b\u1ea1n \u0111ang mu\u1ed1n t\u1ea1o d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p v\u00e0o 2 c\u1ed9t. V\u1eady c\u00e1ch l\u00e0m nh\u01b0 sau:<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 1: Ch\u1ecdn 1 \u00f4 b\u1ea5t k\u1ef3, v\u00ed d\u1ee5 l\u00e0 \u00f4 E1. Nh\u1eadp c\u00f4ng th\u1ee9c =RAND()<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11827 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-11.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-11-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 2: Nh\u1ea5n chu\u1ed9t v\u00e0o c\u1ed9t E \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11819 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-4.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 3: Nh\u1ea5n Ctrl + D \u0111\u1ec3 h\u00e0m RANDOM \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 c\u1ed9t E.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11818 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-6.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-6-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-6-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 4: Ch\u1ecdn \u00f4 D1 v\u00e0 ghi v\u00e0o \u0111\u00f3 s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 ng\u1eabu nhi\u00ean m\u00e0 b\u1ea1n c\u1ea7n. V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n c\u00f3 c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 1 \u0111\u1ebfn 60, b\u1ea1n s\u1ebd \u0111i\u1ec1n 60 v\u00e0o \u00f4 n\u00e0y.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11821 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-1.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-1-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-1-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 5: Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n \u0111\u1ec3 d\u1eef li\u1ec7u. V\u00ed d\u1ee5 b\u1ea1n c\u1ea7n cho d\u1eef li\u1ec7u v\u00e0o 2 c\u1ed9t H v\u00e0 I th\u00ec b\u1ea1n ch\u1ecdn \u00f4 H1 \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c.\u00a0<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Trong c\u00f4ng th\u1ee9c n\u00e0y, E1 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m RANDOM. D1 l\u00e0 s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 ng\u1eabu nhi\u00ean duy nh\u1ea5t b\u1eaft \u0111\u1ea7u t\u1eeb 1 m\u00e0 b\u1ea1n mu\u1ed1n c\u00f3. H1 l\u00e0 \u00f4 b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c d\u00e0i v\u00e0 cho bi\u1ebft v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n ch\u00e8n d\u1eef li\u1ec7u. S\u1ed1 2 th\u1ec3 hi\u1ec7n r\u1eb1ng b\u1ea1n c\u1ea7n ch\u00e8n c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean sang 2 c\u1ed9t. Nh\u1eefng th\u00f4ng tin n\u00e0y b\u1ea1n c\u00f3 \u0111\u1ec3 thay \u0111\u1ed5i t\u00f9y \u00fd.<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11820 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-2.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-2-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-2-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 6: K\u00e9o th\u1ea3 chu\u1ed9t t\u1eeb \u00f4 H1 \u0111\u1ebfn h\u1ebft ph\u1ea7n d\u1eef li\u1ec7u m\u00e0 b\u1ea1n c\u1ea7n d\u00f9ng.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11817 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-9.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-9-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-9-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch n\u00e0y tuy kh\u00f4ng kh\u00f3 \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0ng l\u1ea1i c\u00f3 \u0111i\u1ec3m h\u1ea1n ch\u1ebf \u1edf ch\u1ed7 b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 1. Th\u1ebf nh\u01b0ng, b\u1ea1n c\u0169ng kh\u00f4ng c\u1ea7n lo l\u1eafng v\u00ec c\u00f4ng th\u1ee9c sau s\u1ebd gi\u00fap kh\u1eafc ph\u1ee5c v\u1ea5n \u0111\u1ec1 n\u00e0y ngay.<\/span><\/span><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_2\"><\/span><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f4ng th\u1ee9c 2<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Mu\u1ed1n t\u1ea1o m\u1ed9t danh s\u00e1ch s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean:<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= INDEX (DUY NH\u1ea4T (RANDARRAY (n * 2,1, t\u1ed1i thi\u1ec3u, t\u1ed1i \u0111a)), SEQUENCE (n))\u00a0<\/span><\/span><\/strong><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u1edbi n l\u00e0 s\u1ed1 gi\u00e1 tr\u1ecb c\u1ea7n t\u1ea1o.<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">T\u1ea1o danh s\u00e1ch s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean:<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= INDEX (UNIQUE (RANDARRAY (n * 2,1, min, max, TRUE)), SEQUENCE (n))<\/span><\/span><\/b><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u1edbi n l\u00e0 s\u1ed1 gi\u00e1 tr\u1ecb c\u1ea7n t\u1ea1o.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">V\u00ed d\u1ee5: B\u1ea1n mu\u1ed1n t\u1ea1o danh s\u00e1ch 5 s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean t\u1eeb 1 \u0111\u1ebfn 100, kh\u00f4ng c\u00f3 s\u1ed1 n\u00e0o b\u1ecb tr\u00f9ng l\u1eb7p. V\u1eady b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0:<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11815 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Ho\u1eb7c mu\u1ed1n \u0111\u1ed5i sang 5 s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean, b\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam TRUE v\u00e0o \u0111\u1ed1i s\u1ed1 cu\u1ed1i gi\u1ed1ng nh\u01b0 h\u00ecnh.<\/span><\/span><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11816 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-9.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-9-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-9-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">D\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p:\u00a0<\/span><\/span><\/span><\/p>\n<p style=\"text-align: center\"><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= INDEX (UNIQUE (RANDARRAY (h\u00e0ng * 2, c\u1ed9t, t\u1ed1i thi\u1ec3u, t\u1ed1i \u0111a)), SEQUENCE (h\u00e0ng), {1,2, &#8230;})\u00a0<\/span><\/span><\/strong><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Trong \u0111\u00f3:\u00a0<\/span><\/span><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">rows l\u00e0 s\u1ed1 h\u00e0ng b\u1ea1n c\u1ea7n ch\u00e8n d\u1eef li\u1ec7u.<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">columns l\u00e0 s\u1ed1 c\u1ed9t b\u1ea1n c\u1ea7n ch\u00e8n d\u1eef li\u1ec7u.<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">min l\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">max l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/span><\/span><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">{1,2,&#8230;} l\u00e0 m\u1ed9t h\u1eb1ng s\u1ed1 m\u1ea3ng d\u00f9ng \u0111\u1ec3 bi\u1ec3u th\u1ecb c\u00e1c s\u1ed1 c\u1ed9t \u0111\u01b0\u1ee3c \u0111i\u1ec1n d\u1eef li\u1ec7u. V\u00ed d\u1ee5, mu\u1ed1n \u0111i\u1ec1n v\u00e0o 1 c\u1ed9t, b\u1ea1n s\u1ebd ghi {1}; \u0111i\u1ec1n v\u00e0o 5 c\u1ed9t, b\u1ea1n s\u1ebd ghi {1,2,3,4,5}.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n c\u00f3 m\u1ed9t d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 1 \u0111\u1ebfn 100 \u0111i\u1ec1n v\u00e0o 3 c\u1ed9t, 10 h\u00e0ng.<\/span><\/span><\/span><\/p>\n<p style=\"text-align: center\"><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= INDEX (DUY NH\u1ea4T (RANDARRAY (20,3,1,100)), SEQUENCE (10), {1,2,3})<\/span><\/span><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11814 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-9.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-9-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-9-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0 m\u1ed9t d\u00e3y c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean, kh\u00f4ng l\u1eb7p l\u1ea1i. Trong tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n \u0111\u00f3 l\u00e0 d\u00e3y s\u1ed1 nguy\u00ean, h\u00e3y \u0111\u1eb7t \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a RANDARRAY l\u00e0 TRUE.\u00a0<\/span><\/span><\/span><\/p>\n<p style=\"text-align: center\"><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">= INDEX (DUY NH\u1ea4T (RANDARRAY (20,3,1,100, TRUE)), SEQUENCE (10), {1,2,3})<\/span><\/span><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11813 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10.jpg\" alt=\"h\u00e0m RANDOM trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-10-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin c\u01a1 b\u1ea3n v\u00e0 chi ti\u1ebft nh\u1ea5t v\u1ec1 <\/span><\/span><\/span><b><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">h\u00e0m RANDOM trong Excel<\/span><\/span><\/b><span style=\"font-weight: 400\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">. Hy v\u1ecdng b\u1ea1n \u0111\u1ecdc \u0111\u00e3 ti\u1ebfp thu \u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c trong b\u00e0i vi\u1ebft m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng v\u00e0o vi\u1ec7c h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea3n th\u00e2n!<\/span><\/span><\/span><\/p>\n<p><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <\/span><\/span><a href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\"><span style=\"color: #0000ff\"><em><strong><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">H\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel<\/span><\/span><\/strong><\/em><\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Excel trong h\u1ecdc t\u1eadp, trong c\u00f4ng vi\u1ec7c th\u00ec h\u1eb3n b\u1ea1n c\u0169ng kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi h\u00e0m RANDOM trong Excel. Tuy nhi\u00ean, v\u1eabn c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng l\u1ea7m t\u01b0\u1edfng r\u1eb1ng h\u00e0m RANDOM v\u00e0 h\u00e0m RAND l\u00e0 hai h\u00e0m kh\u00e1c nhau. Th\u1ef1c ch\u1ea5t, hai h\u00e0m &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11811,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel<\/title>\n<meta name=\"description\" content=\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel. Tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Teky nh\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel\" \/>\n<meta property=\"og:description\" content=\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel. Tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Teky nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-20T13:43:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-20T15:44:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel\",\"datePublished\":\"2022-03-20T13:43:50+00:00\",\"dateModified\":\"2022-03-20T15:44:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\"},\"wordCount\":2062,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\",\"name\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg\",\"datePublished\":\"2022-03-20T13:43:50+00:00\",\"dateModified\":\"2022-03-20T15:44:34+00:00\",\"description\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel. Tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Teky nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel","description":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel. Tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Teky nh\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel","og_description":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel. Tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Teky nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-20T13:43:50+00:00","article_modified_time":"2022-03-20T15:44:34+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"11 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel","datePublished":"2022-03-20T13:43:50+00:00","dateModified":"2022-03-20T15:44:34+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/"},"wordCount":2062,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/","name":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg","datePublished":"2022-03-20T13:43:50+00:00","dateModified":"2022-03-20T15:44:34+00:00","description":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel. Tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Teky nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-random-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"Nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n n\u1eafm v\u1eefng v\u1ec1 h\u00e0m RANDOM trong Excel"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-10-400x267.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11810"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11810\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11811"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}