{"id":1801,"date":"2023-11-04T02:16:46","date_gmt":"2023-11-04T02:16:46","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/"},"modified":"2023-12-06T06:16:04","modified_gmt":"2023-12-06T06:16:04","slug":"mengacak-daftarnya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/","title":{"rendered":"Bagaimana cara mencampur data di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3562233439\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk mengacak daftar nilai di Excel berarti Anda dapat mengurutkan data secara acak. Dan untuk itu Anda perlu menggunakan fungsi RAND di Excel dan bersamaan dengan itu Anda perlu menggunakan fungsi sortir yang Anda gunakan untuk mengurutkan data. RAND memberikan nilai acak yang membantu mengacak data ini secara acak.<\/p><p> Dalam contoh berikut, kita mempunyai daftar nama dan sekarang kita perlu mengurutkan daftar ini menggunakan urutan acak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69862\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"daftar nama\" width=\"480\" height=\"444\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah Mengacak Daftar di Excel (Mengacak Daftar)<\/h2><ol><li> Pertama masukkan RAND() di sel B1. Ini akan memberi Anda nomor acak antara 0 dan 1.<\/li><li> Kemudian Anda perlu menyeret rumus ke nama belakang yang Anda miliki dalam daftar. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-urutan-acak-dalam-daftar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-trier-au-hasard-une-liste.png\" sizes=\"auto, \" srcset=\"\" alt=\"random-sort-a-list\" width=\"355\" height=\"374\"><\/li><li> Dari sana Anda perlu membuka opsi pengurutan dari DATA \u279c SORT. Atau Anda dapat menggunakan pintasan keyboard (Alt \u279c A \u279c S \u279c S). <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi 3-sortir terbuka\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ouvrir-loption-de-tri.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-the-sort-option\" width=\"696\" height=\"351\"><\/li><li> Di &#8220;Urutkan berdasarkan&#8221;, pilih nama kolom di mana Anda memiliki nilai acak dan pilih urutan yang Anda inginkan (tidak ada bedanya karena kami mencari pengurutan acak).<\/li><li> Pada akhirnya, klik OK.<\/li><\/ol><p> Dan begitu Anda mengklik OK, Anda memiliki daftar nama acak (diurutkan secara acak). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69866\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-4-rands.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi acak\" width=\"396\" height=\"369\"><\/figure><\/div><p> Sekarang, ada satu hal yang perlu kita perhatikan di sini. Fungsi RAND adalah fungsi yang mudah menguap dan berubah setiap kali Anda menghitung ulang di Excel. Anda dapat mengubah nilai acak ini menjadi nilai sebenarnya, atau jika Anda ingin mengurutkan namanya lagi, Anda dapat membiarkannya apa adanya.<\/p><h2 class=\"wp-block-heading\"> Kolom Sortir Acak<\/h2><p> Anda juga dapat mengurutkan kolom secara acak menggunakan metode yang sama. Dalam contoh berikut, kita memiliki daftar nama yang sama di beberapa kolom dan sekarang kita perlu mengurutkan kolom dalam urutan acak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69867\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-colonnes-de-tri-aleatoire.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom pengurutan acak\" width=\"823\" height=\"100\"><\/figure><\/div><p> Pertama, Anda perlu membuat kolom angka acak seperti yang kita lakukan pada metode sebelumnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69868\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-creer-une-colonne-de-nombres-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat-kolom-angka-acak\" width=\"833\" height=\"117\"><\/figure><\/div><p> Setelah itu, Anda perlu memilih rentang data dari kedua baris. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69869\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-plages-de-donnees-selectionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih rentang data\" width=\"827\" height=\"82\"><\/figure><\/div><p> Sekarang hal selanjutnya yang kita lakukan adalah membuka opsi pengurutan. Dan pada opsi pengurutan, klik tombol \u201cOPTIONS\u201d dan pilih opsi \u201cSORT FROM LEFT TO RIGHT\u201d, lalu klik OK. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69870\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-ouvrir-loption-de-tri.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsi pengurutan terbuka\" width=\"603\" height=\"308\"><\/figure><\/div><p> Sekarang di kotak dialog opsi pengurutan, pilih &#8220;Baris1&#8221; dan pada akhirnya klik OK. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69871\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-selectionnez-la-ligne-une.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-baris-satu\" width=\"599\" height=\"289\"><\/figure><\/div><p> Dan saat Anda mengklik OK, Anda akan mendapatkan kolom-kolom yang diurutkan secara acak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69872\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-obtenir-les-colonnes-triees.png\" sizes=\"auto, \" srcset=\"\" alt=\"dapatkan-kolom-diurutkan\" width=\"821\" height=\"117\"><\/figure><\/div><p> Ini adalah bagaimana Anda bisa menggunakan daftar nilai acak di Excel menggunakan metode pengurutan acak. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/randomiser-la-liste-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/penyaring-horisontal\/\">Buat filter horizontal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/peringkat-bintang\/\">Buat templat peringkat bintang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-file\/\">Dapatkan nama file di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/dapatkan-nama-lembar\/\">Dapatkan nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghasilkan-huruf-acak\/\">Hasilkan huruf acak dengan cepat di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1801","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7Bagaimana cara mencampur data di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara mengacak daftar (mengacak data menggunakan pengurutan acak) menggunakan opsi\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7Bagaimana cara mencampur data di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara mengacak daftar (mengacak data menggunakan pengurutan acak) menggunakan opsi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\",\"name\":\"\u25b7Bagaimana cara mencampur data di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png\",\"datePublished\":\"2023-11-04T02:16:46+00:00\",\"dateModified\":\"2023-12-06T06:16:04+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara mengacak daftar (mengacak data menggunakan pengurutan acak) menggunakan opsi\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mencampur data di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7Bagaimana cara mencampur data di Excel? - Penasihat Excel","description":"Dalam tutorial ini, kita akan mempelajari cara mengacak daftar (mengacak data menggunakan pengurutan acak) menggunakan opsi","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:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7Bagaimana cara mencampur data di Excel? - Penasihat Excel","og_description":"Dalam tutorial ini, kita akan mempelajari cara mengacak daftar (mengacak data menggunakan pengurutan acak) menggunakan opsi","og_url":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/","url":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/","name":"\u25b7Bagaimana cara mencampur data di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png","datePublished":"2023-11-04T02:16:46+00:00","dateModified":"2023-12-06T06:16:04+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara mengacak daftar (mengacak data menggunakan pengurutan acak) menggunakan opsi","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-noms-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mencampur data di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1801"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1801\/revisions"}],"predecessor-version":[{"id":2488,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1801\/revisions\/2488"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}