{"id":1691,"date":"2023-07-25T09:01:48","date_gmt":"2023-07-25T09:01:48","guid":{"rendered":"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/"},"modified":"2023-07-25T09:01:48","modified_gmt":"2023-07-25T09:01:48","slug":"berisi-kueri-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/","title":{"rendered":"Kueri google spreadsheet: pilih baris yang berisi string"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk memilih baris yang berisi string tertentu menggunakan fungsi kueri Google Spreadsheet:<\/span><\/p>\n

\n

=query (<\/span> A1:C9<\/span> ,<\/span> ” pilih A, B dimana B berisi ‘ini’<\/span> ” ,<\/span> 1<\/span> )<\/span><\/strong><\/span><\/p>\n<\/blockquote>\n

Kueri khusus ini memilih kolom A dan B dari rentang sel A1:C9<\/strong> di mana kolom B berisi string “ini” dan angka 1<\/strong> menentukan bahwa ada 1 baris header di bagian atas rentang sel.<\/span><\/p>\n

Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya dengan himpunan data berikut:
<\/span> <\/p>\n

\"\"<\/p>\n

Contoh 1: Pilih Baris yang Berisi String<\/strong><\/span><\/h3>\n

Kita dapat menggunakan sintaks berikut untuk memilih semua baris dimana kolom Tim berisi string ‘ Lak<\/strong> ‘:<\/span> <\/p>\n

\"\"<\/p>\n

Kueri ini mengembalikan dua baris yang berisi string “Lak” di kolom Tim.<\/span><\/p>\n

Contoh 2: Pilih Baris yang Tidak Berisi String<\/strong><\/span><\/h3>\n

Kita dapat menggunakan sintaks berikut untuk memilih semua baris dimana kolom Tim tidak berisi<\/em> string ‘ Lak<\/strong> ‘:<\/span> <\/p>\n

\"\"<\/p>\n

Perhatikan bahwa ini mengembalikan setiap baris yang nama timnya tidak sama dengan Lakers.<\/span><\/p>\n

Contoh 3: Pilih baris yang berisi salah satu dari beberapa string<\/strong><\/span><\/h3>\n

Kita dapat menggunakan sintaks berikut untuk memilih semua baris dimana kolom Tim berisi string ‘ Lak<\/strong> ‘ atau string ‘ Mav<\/strong> ‘:<\/span> <\/p>\n

\"\"<\/p>\n

Ini hanya mengembalikan baris yang nama timnya sama dengan Lakers atau Mavericks.<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Google Sheets: cara menambahkan nilai berdasarkan kategori<\/a>
Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Anda dapat menggunakan sintaks berikut untuk memilih baris yang berisi string tertentu menggunakan fungsi kueri Google Spreadsheet: =query ( A1:C9 , ” pilih A, B dimana B berisi ‘ini’ ” , 1 ) Kueri khusus ini memilih kolom A dan B dari rentang sel A1:C9 di mana kolom B berisi string “ini” dan angka 1 […]<\/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":"\nKueri Google Spreadsheet: pilih baris yang berisi string<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi query di Google Sheets untuk memilih baris yang berisi string tertentu.\" \/>\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\/berisi-kueri-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: pilih baris yang berisi string\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi query di Google Sheets untuk memilih baris yang berisi string tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T09:01:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult1.png\" \/>\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\/berisi-kueri-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\",\"name\":\"Kueri Google Spreadsheet: pilih baris yang berisi string\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T09:01:48+00:00\",\"dateModified\":\"2023-07-25T09:01:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi query di Google Sheets untuk memilih baris yang berisi string tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: pilih baris yang berisi string\"}]},{\"@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":"Kueri Google Spreadsheet: pilih baris yang berisi string","description":"Tutorial ini menjelaskan cara menggunakan fungsi query di Google Sheets untuk memilih baris yang berisi string tertentu.","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\/berisi-kueri-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: pilih baris yang berisi string","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi query di Google Sheets untuk memilih baris yang berisi string tertentu.","og_url":"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-25T09:01:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mult1.png"}],"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\/berisi-kueri-google-sheets\/","url":"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/","name":"Kueri Google Spreadsheet: pilih baris yang berisi string","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T09:01:48+00:00","dateModified":"2023-07-25T09:01:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi query di Google Sheets untuk memilih baris yang berisi string tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: pilih baris yang berisi string"}]},{"@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\/1691"}],"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=1691"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1691\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}