{"id":2649,"date":"2023-07-21T08:29:03","date_gmt":"2023-07-21T08:29:03","guid":{"rendered":"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/"},"modified":"2023-07-21T08:29:03","modified_gmt":"2023-07-21T08:29:03","slug":"nilai-n-teratas-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/","title":{"rendered":"Google sheets: cara mengekstrak nilai n pertama dari rentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengekstrak nilai N pertama dari rentang data di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C16<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Select A,B,C Order by B Desc Limit 5<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini melihat data dalam rentang <strong>A1:C16<\/strong> dan mengembalikan baris dengan <strong>5<\/strong> nilai tertinggi di kolom <strong>B.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengekstrak 10 nilai pertama, cukup ganti angka <strong>5<\/strong> dengan angka <strong>10<\/strong> di rumus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Ekstrak N nilai pertama dari rentang di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan poin dan rebound dari 15 tim bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23352 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top5_1.jpg\" alt=\"\" width=\"536\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kueri berikut untuk mengekstrak baris dengan nilai tertinggi 5 poin:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C16<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Select A,B,C Order by B Desc Limit 5<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23353 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top5_2.jpg\" alt=\"\" width=\"672\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kueri di sel E1 mengembalikan baris dengan nilai lima poin tertinggi, yang secara otomatis diurutkan dalam urutan menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita dapat menggunakan kueri berikut untuk mengekstrak baris dengan 10 nilai poin tertinggi:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C16<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Select A,B,C Order by B Desc Limit 10<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23354 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top5_3.jpg\" alt=\"\" width=\"663\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kueri di sel E1 mengembalikan baris dengan nilai tertinggi 10 poin, yang secara otomatis diurutkan dalam urutan menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan kueri berikut untuk mengembalikan 10 nilai poin tertinggi tanpa kolom lainnya:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=query( <span style=\"color: #ff6600;\">A1:C16<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Select B Order by B Desc Limit 10<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23355 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top5_4.jpg\" alt=\"\" width=\"518\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kueri di sel E1 mengembalikan 10 nilai poin tertinggi, yang secara otomatis diurutkan dalam urutan menurun.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/contoh-lembar-acak-google\/\" target=\"_blank\" rel=\"noopener\">Cara memilih sampel acak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung frekuensi di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/beberapa-pernyataan-if-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan beberapa pernyataan IF di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengekstrak nilai N pertama dari rentang data di Google Spreadsheet: =query( A1:C16 , &#8221; Select A,B,C Order by B Desc Limit 5 &#8221; ) Kueri khusus ini melihat data dalam rentang A1:C16 dan mengembalikan baris dengan 5 nilai tertinggi di kolom B. Untuk mengekstrak 10 nilai pertama, cukup ganti [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Sheets: Cara mengekstrak nilai N pertama dari rentang \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekstrak nilai N pertama dari suatu rentang di Google Sheets, dengan 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\/nilai-n-teratas-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets: Cara mengekstrak nilai N pertama dari rentang \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekstrak nilai N pertama dari suatu rentang di Google Sheets, dengan contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T08:29:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top5_1.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\/nilai-n-teratas-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/\",\"name\":\"Google Sheets: Cara mengekstrak nilai N pertama dari rentang \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T08:29:03+00:00\",\"dateModified\":\"2023-07-21T08:29:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekstrak nilai N pertama dari suatu rentang di Google Sheets, dengan contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengekstrak nilai n pertama dari rentang\"}]},{\"@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 Sheets: Cara mengekstrak nilai N pertama dari rentang \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengekstrak nilai N pertama dari suatu rentang di Google Sheets, dengan 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\/nilai-n-teratas-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets: Cara mengekstrak nilai N pertama dari rentang \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengekstrak nilai N pertama dari suatu rentang di Google Sheets, dengan contoh.","og_url":"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-21T08:29:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/top5_1.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\/nilai-n-teratas-google-sheet\/","url":"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/","name":"Google Sheets: Cara mengekstrak nilai N pertama dari rentang \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T08:29:03+00:00","dateModified":"2023-07-21T08:29:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekstrak nilai N pertama dari suatu rentang di Google Sheets, dengan contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nilai-n-teratas-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengekstrak nilai n pertama dari rentang"}]},{"@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\/2649"}],"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=2649"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2649\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}