{"id":4093,"date":"2023-07-13T15:59:23","date_gmt":"2023-07-13T15:59:23","guid":{"rendered":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/"},"modified":"2023-07-13T15:59:23","modified_gmt":"2023-07-13T15:59:23","slug":"ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/","title":{"rendered":"Google e-tablolar: ayn\u0131 e-tabloda importrange kullan\u0131n"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ba\u015fka bir e-tablodaki verileri i\u00e7e aktarmak i\u00e7in Google E-Tablolar&#8217;daki <strong>IMPORTRANGE<\/strong> i\u015flevini kullanabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ancak, verileri ayn\u0131 \u00e7al\u0131\u015fma kitab\u0131 i\u00e7indeki bir sayfadan ba\u015fka bir sayfaya aktarmak istiyorsan\u0131z, <strong>IMPORTRANGE<\/strong> i\u015flevini kullanman\u0131za gerek yoktur.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunun yerine <strong>QUERY<\/strong> i\u015flevini kullanmak \u00e7ok daha basittir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00d6rne\u011fin, <strong>B1:B9<\/strong> aral\u0131\u011f\u0131ndaki h\u00fccreleri, <strong>asist<\/strong> ad\u0131 verilen bir sayfadan ge\u00e7erli sayfan\u0131za aktarmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY( <span style=\"color: #ff6600;\">assists!B1:B9<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bu, yaln\u0131zca verileri i\u00e7e aktarmak i\u00e7in <strong>IMPORTRANGE<\/strong> i\u015flevini kullanmaktan ve sayfan\u0131n bulundu\u011fu URL&#8217;yi girmekten \u00e7ok daha etkilidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Verileri bir sayfadan ba\u015fka bir sayfaya aktarmak i\u00e7in QUERY kullanma<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Farkl\u0131 tak\u0131mlardan basketbol oyuncular\u0131n\u0131n att\u0131\u011f\u0131 puanlar hakk\u0131nda bilgi i\u00e7eren, <strong>puanlar<\/strong> ad\u0131 verilen a\u015fa\u011f\u0131daki sayfaya sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32541 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importer1.png\" alt=\"\" width=\"486\" height=\"485\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Ve ayn\u0131 \u00e7al\u0131\u015fma kitab\u0131nda, ayn\u0131 basketbolcular taraf\u0131ndan yap\u0131lan <strong>asistler<\/strong> hakk\u0131nda bilgi i\u00e7eren, asistler ad\u0131 verilen ba\u015fka bir sayfam\u0131z\u0131n oldu\u011funu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32542 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importer2.png\" alt=\"\" width=\"510\" height=\"472\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Yard\u0131m sayfas\u0131ndan<\/strong> <strong>B1:B9<\/strong> aral\u0131\u011f\u0131ndaki de\u011ferleri i\u00e7e aktarmak i\u00e7in <strong>puan<\/strong> tablosunun <b>C1<\/b> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY( <span style=\"color: #ff6600;\">assists!B1:B9<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32543 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importer3.png\" alt=\"\" width=\"483\" height=\"454\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>QUERY<\/strong> fonksiyonunu kullanarak <strong>B1:B9<\/strong> de\u011ferlerini <strong>yard\u0131m<\/strong> sayfas\u0131ndan <strong>puan<\/strong> sayfas\u0131na ba\u015far\u0131yla aktarabildi\u011fimizi unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Almak istedi\u011fimiz veriler ayn\u0131 \u00e7al\u0131\u015fma kitab\u0131nda oldu\u011fundan <strong>IMPORTRANGE<\/strong> fonksiyonunu kullanmaya gerek yoktu.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar&#8217;da di\u011fer yayg\u0131n g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/google-e-tablolar-ice-aktarma-araligi-birden-fazla-sayfa\/\" target=\"_blank\" rel=\"noopener\">Google E-Tablolar: IMPORTRANGE&#8217;\u0131 birden \u00e7ok sayfayla kullanma<\/a><br \/> Google E-Tablolar: IMPORTRANGE ko\u015fullar\u0131yla birlikte nas\u0131l kullan\u0131l\u0131r?<br \/> <a href=\"https:\/\/statorials.org\/tr\/google-e-tablolar-filtre-ice-aktarma-araligi\/\">Google E-Tablolar: IMPORTRANGE verileri nas\u0131l filtrelenir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ba\u015fka bir e-tablodaki verileri i\u00e7e aktarmak i\u00e7in Google E-Tablolar&#8217;daki IMPORTRANGE i\u015flevini kullanabilirsiniz. Ancak, verileri ayn\u0131 \u00e7al\u0131\u015fma kitab\u0131 i\u00e7indeki bir sayfadan ba\u015fka bir sayfaya aktarmak istiyorsan\u0131z, IMPORTRANGE i\u015flevini kullanman\u0131za gerek yoktur. Bunun yerine QUERY i\u015flevini kullanmak \u00e7ok daha basittir. \u00d6rne\u011fin, B1:B9 aral\u0131\u011f\u0131ndaki h\u00fccreleri, asist ad\u0131 verilen bir sayfadan ge\u00e7erli sayfan\u0131za aktarmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: =QUERY( [&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":[],"class_list":["post-4093","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google E-Tablolar: IMPORTRANGE&#039;\u0131 ayn\u0131 e-tabloda kullan\u0131n \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, ayn\u0131 sayfadaki verileri Google E-Tablolar&#039;a aktarmak i\u00e7in IMPORTRANGE i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google E-Tablolar: IMPORTRANGE&#039;\u0131 ayn\u0131 e-tabloda kullan\u0131n \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, ayn\u0131 sayfadaki verileri Google E-Tablolar&#039;a aktarmak i\u00e7in IMPORTRANGE i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T15:59:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importer1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/\",\"url\":\"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/\",\"name\":\"Google E-Tablolar: IMPORTRANGE&#39;\u0131 ayn\u0131 e-tabloda kullan\u0131n \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-13T15:59:23+00:00\",\"dateModified\":\"2023-07-13T15:59:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, ayn\u0131 sayfadaki verileri Google E-Tablolar&#39;a aktarmak i\u00e7in IMPORTRANGE i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google e-tablolar: ayn\u0131 e-tabloda importrange kullan\u0131n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google E-Tablolar: IMPORTRANGE&#39;\u0131 ayn\u0131 e-tabloda kullan\u0131n \u2013 Statorials","description":"Bu e\u011fitimde, ayn\u0131 sayfadaki verileri Google E-Tablolar&#39;a aktarmak i\u00e7in IMPORTRANGE i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/","og_locale":"tr_TR","og_type":"article","og_title":"Google E-Tablolar: IMPORTRANGE&#39;\u0131 ayn\u0131 e-tabloda kullan\u0131n \u2013 Statorials","og_description":"Bu e\u011fitimde, ayn\u0131 sayfadaki verileri Google E-Tablolar&#39;a aktarmak i\u00e7in IMPORTRANGE i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/","og_site_name":"Statorials","article_published_time":"2023-07-13T15:59:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importer1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/","url":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/","name":"Google E-Tablolar: IMPORTRANGE&#39;\u0131 ayn\u0131 e-tabloda kullan\u0131n \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-13T15:59:23+00:00","dateModified":"2023-07-13T15:59:23+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, ayn\u0131 sayfadaki verileri Google E-Tablolar&#39;a aktarmak i\u00e7in IMPORTRANGE i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/ayni-sayfanin-google-sayfalarini-ice-aktarma-araligi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Google e-tablolar: ayn\u0131 e-tabloda importrange kullan\u0131n"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4093"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4093\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}