{"id":4939,"date":"2023-07-06T04:12:01","date_gmt":"2023-07-06T04:12:01","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/"},"modified":"2023-07-06T04:12:01","modified_gmt":"2023-07-06T04:12:01","slug":"google-sheet-mendapatkan-surat-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/","title":{"rendered":"Cara mendapatkan surat kolom di google sheets (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk mendapatkan huruf kolom yang sesuai dengan nomor kolom tertentu di Google Spreadsheet:<\/span><\/p>\n

 =<\/span> SUBSTITUTE<\/span> (<\/span> ADDRESS<\/span> (<\/span> 1,8,4<\/span> )<\/span> ,<\/span> \u201c<\/span><\/span> 1<\/span> \u201d<\/span> ,<\/span> \u201c<\/span> \u201d<\/span> )<\/span> _<\/span>\n<\/strong><\/pre>\n
 Rumus khusus ini akan mengembalikan huruf kolom yang sesuai dengan kolom 8<\/strong> lembar kerja.<\/span><\/p>\n
 Misalnya, rumus ini akan menghasilkan “H” karena cocok dengan huruf di kolom 8.<\/span><\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara mendapatkan huruf kolom di Google Sheets<\/strong><\/span><\/h2>\n
 Katakanlah kita ingin mengembalikan huruf dari kolom kedelapan di spreadsheet Google Sheets.<\/span><\/p>\n
 Kita bisa mengetikkan rumus berikut di sel A1<\/strong> untuk melakukan ini:<\/span><\/p>\n
 =<\/span> SUBSTITUTE<\/span> (<\/span> ADDRESS<\/span> (<\/span> 1,8,4<\/span> )<\/span> ,<\/span> \u201c<\/span><\/span> 1<\/span> \u201d<\/span> ,<\/span> \u201c<\/span> \u201d<\/span> )<\/span> _<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Google<\/p>\n
 Mengembalikan rumus “H” karena merupakan huruf kolom yang sesuai dengan kolom kedelapan.<\/span><\/p>\n
 Untuk mendapatkan huruf kolom berbeda, cukup ganti angka 8<\/strong> dengan nilai berbeda di rumus.<\/span><\/p>\n
 Misalnya, kita menggunakan angka 2<\/strong> dalam rumus:<\/span><\/p>\n
 =<\/span> SUBSTITUTE<\/span> (<\/span> ADDRESS<\/span> (<\/span> 1,2,4<\/span> )<\/span> ,<\/span> \u201c<\/span><\/span> 1<\/span> \u201d<\/span> ,<\/span> \u201c<\/span> \u201d<\/span> )<\/span> _<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Mengembalikan rumus “B” karena merupakan huruf kolom yang sesuai dengan kolom kedua.<\/span><\/p>\n
 Bagaimana cara kerja rumus ini?<\/strong><\/span><\/h2>\n
 Ingat rumus yang kami gunakan untuk mendapatkan huruf yang sesuai dengan<\/span> kolom kedelapan di Google Sheets:<\/span><\/p>\n
 =<\/span> SUBSTITUTE<\/span> (<\/span> ADDRESS<\/span> (<\/span> 1,8,4<\/span> )<\/span> ,<\/span> \u201c<\/span><\/span> 1<\/span> \u201d<\/span> ,<\/span> \u201c<\/span> \u201d<\/span> )<\/span> _<\/span><\/strong><\/pre>\n
 Begini cara kerja rumus ini:<\/span><\/p>\n
 Pertama, kita menggunakan ADDRESS(1,8,4)<\/strong> untuk mendapatkan alamat sel di baris 1, kolom 8, dan kita menggunakan 4 untuk menentukan bahwa kita menginginkan referensi relatif<\/a> .<\/span><\/p>\n
 Ini mengembalikan H1<\/strong> .<\/span><\/p>\n
 Selanjutnya kita gunakan fungsi SUBSTITUTE<\/strong> untuk mengganti angka 1<\/strong> dengan spasi.<\/span><\/p>\n
 Ini mengembalikan H.<\/strong><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Cara menggunakan nama kolom di kueri Google Sheets<\/a>
 Cara memfilter kolom berdasarkan beberapa nilai di Google Spreadsheet<\/a>
 Cara menemukan duplikat dalam dua kolom di Google Sheets<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk mendapatkan huruf kolom yang sesuai dengan nomor kolom tertentu di Google Spreadsheet: = SUBSTITUTE ( ADDRESS ( 1,8,4 ) , \u201c 1 \u201d , \u201c \u201d ) _ Rumus khusus ini akan mengembalikan huruf kolom yang sesuai dengan kolom 8 lembar kerja. Misalnya, rumus ini akan menghasilkan “H” karena […]<\/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":"\nCara Mendapatkan Surat Kolom di Google Sheets (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan huruf kolom di Google Sheets, dengan contoh lengkap.\" \/>\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\/google-sheet-mendapatkan-surat-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mendapatkan Surat Kolom di Google Sheets (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan huruf kolom di Google Sheets, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T04:12:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clette1.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\/google-sheet-mendapatkan-surat-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/\",\"name\":\"Cara Mendapatkan Surat Kolom di Google Sheets (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T04:12:01+00:00\",\"dateModified\":\"2023-07-06T04:12:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan huruf kolom di Google Sheets, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mendapatkan surat kolom di google sheets (dengan contoh)\"}]},{\"@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":"Cara Mendapatkan Surat Kolom di Google Sheets (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mendapatkan huruf kolom di Google Sheets, dengan contoh lengkap.","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\/google-sheet-mendapatkan-surat-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mendapatkan Surat Kolom di Google Sheets (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mendapatkan huruf kolom di Google Sheets, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-06T04:12:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clette1.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\/google-sheet-mendapatkan-surat-kolom\/","url":"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/","name":"Cara Mendapatkan Surat Kolom di Google Sheets (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T04:12:01+00:00","dateModified":"2023-07-06T04:12:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan huruf kolom di Google Sheets, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-mendapatkan-surat-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mendapatkan surat kolom di google sheets (dengan contoh)"}]},{"@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\/4939"}],"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=4939"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4939\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}