{"id":5027,"date":"2023-07-04T22:26:27","date_gmt":"2023-07-04T22:26:27","guid":{"rendered":"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/"},"modified":"2023-07-04T22:26:27","modified_gmt":"2023-07-04T22:26:27","slug":"pencarian-excel-kemunculan-pertama-beberapa-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/","title":{"rendered":"Excel: temukan kemunculan pertama berdasarkan beberapa kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menemukan kemunculan pertama suatu nilai dalam kolom di Excel berdasarkan beberapa kriteria:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">C2:C13<\/span> ,MATCH(1,INDEX(( <span style=\"color: #ff0000;\">A2:A13<\/span> = <span style=\"color: #800080;\">F1<\/span> )*( <span style=\"color: #008000;\">B2:B13<\/span> = <span style=\"color: #ed4eae;\">F2<\/span> ),),FALSE))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengembalikan nilai pertama dalam rentang <strong>C2:C13<\/strong> dengan nilai terkait di <strong>A2:A13<\/strong> sama dengan nilai di sel <strong>F1<\/strong> <em>dan<\/em> nilai terkait di <strong>B2:B13<\/strong> sama dengan nilai di sel <strong>F2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Temukan kejadian pertama berdasarkan beberapa kriteria di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang poin yang dicetak oleh berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39196 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/om1.png\" alt=\"\" width=\"521\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mengembalikan nilai poin untuk kemunculan pertama seorang pemain yang ada di tim <strong>Spurs<\/strong> dan menempati posisi <strong>Forward<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menentukan kriteria ini di sel <strong>F1<\/strong> dan <strong>F2<\/strong> , lalu ketikkan rumus berikut di sel <strong>F3<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INDEX( <span style=\"color: #3366ff;\">C2:C13<\/span> ,MATCH(1,INDEX(( <span style=\"color: #ff0000;\">A2:A13<\/span> = <span style=\"color: #800080;\">F1<\/span> )*( <span style=\"color: #008000;\">B2:B13<\/span> = <span style=\"color: #ed4eae;\">F2<\/span> ),),FALSE))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39197\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/om2.png\" alt=\"Excel mencari kejadian pertama berdasarkan beberapa kriteria\" width=\"679\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai poin <strong>31<\/strong> , karena ini mewakili nilai poin pemain pertama yang masuk skuad <strong>Spurs<\/strong> dan memainkan posisi <strong>striker<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika kita mengubah kriteria di sel <strong>F1<\/strong> dan <strong>F2<\/strong> , rumusnya akan secara otomatis mengembalikan pemain baru yang cocok dengan kriteria baru tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya saja kita mengubah tim menjadi <strong>Rockets<\/strong> dan posisinya menjadi <strong>Guard<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39198 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/om3.png\" alt=\"\" width=\"677\" height=\"358\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya dengan benar mengembalikan nilai <strong>12<\/strong> , yang merupakan nilai poin yang sesuai dengan pemain pertama yang masuk tim <strong>Rockets<\/strong> dan memiliki posisi <strong>Penjaga<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menghitung-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung duplikat di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-kejadian\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah kemunculan di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung frekuensi teks di Excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/dihitung-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan kelompok di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menemukan kemunculan pertama suatu nilai dalam kolom di Excel berdasarkan beberapa kriteria: =INDEX( C2:C13 ,MATCH(1,INDEX(( A2:A13 = F1 )*( B2:B13 = F2 ),),FALSE)) Rumus khusus ini mengembalikan nilai pertama dalam rentang C2:C13 dengan nilai terkait di A2:A13 sama dengan nilai di sel F1 dan nilai terkait di B2:B13 sama [&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>Excel: Temukan kemunculan pertama berdasarkan beberapa kriteria - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari kemunculan pertama suatu nilai di Excel berdasarkan beberapa kriteria, termasuk 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\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Temukan kemunculan pertama berdasarkan beberapa kriteria - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari kemunculan pertama suatu nilai di Excel berdasarkan beberapa kriteria, termasuk contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T22:26:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/om1.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\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/\",\"name\":\"Excel: Temukan kemunculan pertama berdasarkan beberapa kriteria - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T22:26:27+00:00\",\"dateModified\":\"2023-07-04T22:26:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari kemunculan pertama suatu nilai di Excel berdasarkan beberapa kriteria, termasuk contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: temukan kemunculan pertama berdasarkan beberapa kriteria\"}]},{\"@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":"Excel: Temukan kemunculan pertama berdasarkan beberapa kriteria - Statologi","description":"Tutorial ini menjelaskan cara mencari kemunculan pertama suatu nilai di Excel berdasarkan beberapa kriteria, termasuk 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\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Temukan kemunculan pertama berdasarkan beberapa kriteria - Statologi","og_description":"Tutorial ini menjelaskan cara mencari kemunculan pertama suatu nilai di Excel berdasarkan beberapa kriteria, termasuk contoh.","og_url":"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-04T22:26:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/om1.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\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/","url":"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/","name":"Excel: Temukan kemunculan pertama berdasarkan beberapa kriteria - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T22:26:27+00:00","dateModified":"2023-07-04T22:26:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari kemunculan pertama suatu nilai di Excel berdasarkan beberapa kriteria, termasuk contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencarian-excel-kemunculan-pertama-beberapa-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: temukan kemunculan pertama berdasarkan beberapa kriteria"}]},{"@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\/5027"}],"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=5027"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5027\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}