{"id":2837,"date":"2023-07-20T11:45:39","date_gmt":"2023-07-20T11:45:39","guid":{"rendered":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/"},"modified":"2023-07-20T11:45:39","modified_gmt":"2023-07-20T11:45:39","slug":"daftar-acak-google-sheet-2","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/","title":{"rendered":"Google spreadsheet: cara memilih nilai acak dari daftar"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk memilih nilai acak dari daftar di Google Spreadsheet:<\/span><\/p>\n

 =<\/span> INDEX<\/span> (<\/span> A2:A16<\/span> ,<\/span> RANDBETWEEN<\/span> (<\/span> 1<\/span> ,<\/span> COUNTA<\/span> (<\/span> A2:A16<\/span> )<\/span> )<\/span> )<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini memilih nilai acak dalam rentang A2:A16<\/strong> .<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Pilih nilai acak dari daftar di Google Spreadsheet<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki daftar nilai berikut di Google Spreadsheet:<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa mengetikkan rumus berikut di sel C2<\/strong> untuk memilih nilai acak dalam rentang A2:A16<\/strong> :<\/span><\/p>\n
 =<\/span> INDEX<\/span> (<\/span> A2:A16<\/span> ,<\/span> RANDBETWEEN<\/span> (<\/span> 1<\/span> ,<\/span> COUNTA<\/span> (<\/span> A2:A16<\/span> )<\/span> )<\/span> )<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n
\"Google<\/p>\n
 Kita dapat melihat bahwa rumus tersebut memilih 26<\/strong> secara acak dari daftar nilai di kolom A.<\/span><\/p>\n
 Jika Anda mengklik sel C2<\/strong> dan mengklik Ctrl+C<\/strong> , lalu klik Ctrl+V<\/strong> untuk menempelkan rumus yang sama ke sel C2<\/strong> , nilai baru akan dipilih secara acak dari daftar:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat melihat bahwa rumus kali ini memilih 33<\/b> secara acak dari daftar nilai.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi RANDBETWEEN<\/b> di Google Spreadsheet di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara Mengacak Daftar di Google Sheets<\/a>
 Cara memilih sampel acak di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut untuk memilih nilai acak dari daftar di Google Spreadsheet: = INDEX ( A2:A16 , RANDBETWEEN ( 1 , COUNTA ( A2:A16 ) ) ) Rumus khusus ini memilih nilai acak dalam rentang A2:A16 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Pilih nilai acak dari daftar di […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nGoogle Spreadsheet: Cara memilih nilai acak dari daftar \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih nilai acak dari daftar di Google Sheets, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara memilih nilai acak dari daftar \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih nilai acak dari daftar di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T11:45:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste-aleatoire1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/\",\"url\":\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/\",\"name\":\"Google Spreadsheet: Cara memilih nilai acak dari daftar \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T11:45:39+00:00\",\"dateModified\":\"2023-07-20T11:45:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih nilai acak dari daftar di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memilih nilai acak dari daftar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Spreadsheet: Cara memilih nilai acak dari daftar \u2013 Statorial","description":"Tutorial ini menjelaskan cara memilih nilai acak dari daftar di Google Sheets, dengan sebuah contoh.","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:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara memilih nilai acak dari daftar \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara memilih nilai acak dari daftar di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/","og_site_name":"Statorials","article_published_time":"2023-07-20T11:45:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/liste-aleatoire1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/","url":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/","name":"Google Spreadsheet: Cara memilih nilai acak dari daftar \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T11:45:39+00:00","dateModified":"2023-07-20T11:45:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih nilai acak dari daftar di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/daftar-acak-google-sheet-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memilih nilai acak dari daftar"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2837"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2837"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2837\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}