{"id":4142,"date":"2023-07-13T07:43:39","date_gmt":"2023-07-13T07:43:39","guid":{"rendered":"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/"},"modified":"2023-07-13T07:43:39","modified_gmt":"2023-07-13T07:43:39","slug":"nomor-baris-kueri-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/","title":{"rendered":"Kueri google spreadsheet: cara mendapatkan nomor baris dalam kueri"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut dalam kueri Google Spreadsheet untuk menambahkan kolom yang berisi nomor baris:<\/span><\/p>\n

 =ARRAYFORMULA(QUERY({ A2:B11<\/span> , ROW( A2:B11<\/span> )}, \" SELECT Col1, Col3 WHERE Col1 = 'Mavs'<\/span> \", 0<\/span> ))\n<\/span><\/strong><\/pre>\n
 Kueri khusus ini akan memilih nilai dari kolom Col1<\/strong> (kolom A) dan Col3<\/strong> (kolom C) dimana nilai Col1<\/strong> sama dengan \u201cMavs\u201d \u2013 kueri ini juga mengasumsikan bahwa Col3<\/strong> kosong sehingga Col3<\/strong> hanya digunakan untuk mencari jumlah garis.<\/span><\/p>\n
 Catatan<\/strong> : Kita perlu membungkus QUERY<\/strong> dalam ARRAYFORMULA<\/strong> sehingga kita bisa mendapatkan nomor baris untuk setiap baris dan bukan hanya baris pertama.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Dapatkan nomor baris di kueri Google Spreadsheet<\/strong><\/span><\/h2>\n
 Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk memilih semua nilai di kolom A di mana tim sama dengan “Mavs” dan juga memilih nomor baris untuk setiap baris:<\/span><\/p>\n
 =ARRAYFORMULA(QUERY({ A2:B11<\/span> , ROW( A2:B11<\/span> )}, \" SELECT Col1, Col3 WHERE Col1 = 'Mavs'<\/span> \", 0<\/span> ))<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan kueri ini dalam praktiknya:<\/span> <\/p>\n
\"Nomor<\/p>\n
 Kueri mengembalikan nilai di kolom A di mana tim sama dengan “Mavs” beserta nomor baris untuk setiap baris tersebut.<\/span><\/p>\n
 Dari hasilnya terlihat bahwa pemain tim \u201cMavs\u201d berada di baris 2<\/strong> , 3<\/strong> dan 6<\/strong> dari dataset asli.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
Kueri Google Spreadsheet: Cara mengembalikan baris unik saja<\/a>
 Kueri Google Spreadsheet: cara menghapus header dari hasil<\/a>
 Kueri Google Spreadsheet: Cara Mengabaikan Sel Kosong di Kueri<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut dalam kueri Google Spreadsheet untuk menambahkan kolom yang berisi nomor baris: =ARRAYFORMULA(QUERY({ A2:B11 , ROW( A2:B11 )}, ” SELECT Col1, Col3 WHERE Col1 = ‘Mavs’ “, 0 )) Kueri khusus ini akan memilih nilai dari kolom Col1 (kolom A) dan Col3 (kolom C) dimana nilai Col1 sama dengan \u201cMavs\u201d \u2013 […]<\/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: Cara mendapatkan nomor baris dalam kueri \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan nomor baris dalam kueri 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\/nomor-baris-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: Cara mendapatkan nomor baris dalam kueri \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan nomor baris dalam kueri Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T07:43:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requete-de-ligne1.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\/nomor-baris-kueri-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/\",\"name\":\"Kueri Google Spreadsheet: Cara mendapatkan nomor baris dalam kueri \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T07:43:39+00:00\",\"dateModified\":\"2023-07-13T07:43:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan nomor baris dalam kueri Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara mendapatkan nomor baris dalam kueri\"}]},{\"@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: Cara mendapatkan nomor baris dalam kueri \u2013 Statorial","description":"Tutorial ini menjelaskan cara mendapatkan nomor baris dalam kueri 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\/nomor-baris-kueri-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara mendapatkan nomor baris dalam kueri \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mendapatkan nomor baris dalam kueri Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-13T07:43:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requete-de-ligne1.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\/nomor-baris-kueri-google-sheets\/","url":"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/","name":"Kueri Google Spreadsheet: Cara mendapatkan nomor baris dalam kueri \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T07:43:39+00:00","dateModified":"2023-07-13T07:43:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan nomor baris dalam kueri Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nomor-baris-kueri-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara mendapatkan nomor baris dalam kueri"}]},{"@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\/4142"}],"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=4142"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4142\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}