{"id":7740,"date":"2021-08-14T15:31:33","date_gmt":"2021-08-14T08:31:33","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7740"},"modified":"2026-05-28T14:36:54","modified_gmt":"2026-05-28T07:36:54","slug":"cach-lay-danh-sach-ngau-nhien-khong-trung-lap-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-lay-danh-sach-ngau-nhien-khong-trung-lap-trong-excel\/","title":{"rendered":"C\u00e1ch l\u1ea5y danh s\u00e1ch ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p trong Excel"},"content":{"rendered":"<p>L\u01b0u \u00fd\u00a0C\u00e1ch n\u00e0y ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng tr\u00ean phi\u00ean b\u1ea3n Excel 365 c\u00f3 h\u1ed7 tr\u1ee3 c\u00e1c h\u00e0m m\u1ea3ng \u0111\u1ed9ng \u0110\u1ec3 t\u1ea1o ra m\u1ed9t danh s\u00e1ch ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p trong Excel, th\u00ec c\u00f4ng th\u1ee9c chung c\u1ee7a ch\u00fang ta nh\u01b0 sau INDEX(SORTBY(c\u1ed9t_d\u1eef_li\u1ec7u, RANDARRAY(ROWS(c\u1ed9t_d\u1eef_li\u1ec7u))), SEQUENCE(n)) Trong \u0111\u00f3: \u2013\u00a0c\u1ed9t_d\u1eef_li\u1ec7u\u00a0l\u00e0 c\u1ed9t d\u1eef li\u1ec7u ngu\u1ed3n... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"excerpt":{"rendered":"<p>L\u01b0u \u00fd\u00a0C\u00e1ch n\u00e0y ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng tr\u00ean phi\u00ean b\u1ea3n Excel 365 c\u00f3 h\u1ed7 tr\u1ee3 c\u00e1c h\u00e0m m\u1ea3ng \u0111\u1ed9ng \u0110\u1ec3 t\u1ea1o ra m\u1ed9t danh s\u00e1ch ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p trong Excel, th\u00ec c\u00f4ng th\u1ee9c chung c\u1ee7a ch\u00fang ta nh\u01b0 sau INDEX(SORTBY(c\u1ed9t_d\u1eef_li\u1ec7u, RANDARRAY(ROWS(c\u1ed9t_d\u1eef_li\u1ec7u))), SEQUENCE(n)) Trong \u0111\u00f3: \u2013\u00a0c\u1ed9t_d\u1eef_li\u1ec7u\u00a0l\u00e0 c\u1ed9t d\u1eef li\u1ec7u ngu\u1ed3n&#8230;... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-7740","post","type-post","status-publish","format-standard","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7740"}],"version-history":[{"count":1,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7740\/revisions"}],"predecessor-version":[{"id":10672,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7740\/revisions\/10672"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}