\u00d6rne\u011fin, a\u015fa\u011f\u0131daki iki veri k\u00fcmesine sahip oldu\u011fumuzu ve hem Tak\u0131m<\/strong> s\u00fctunundaki hem de Sol Veri K\u00fcmesi Konumu<\/strong> s\u00fctunundaki de\u011ferle e\u015fle\u015fen Noktalar<\/strong> s\u00fctunundaki de\u011feri d\u00f6nd\u00fcrmek i\u00e7in sa\u011f veri k\u00fcmesinde D\u00dc\u015eEYARA’y\u0131 kullanmak istedi\u011finizi varsayal\u0131m:<\/span> <\/p>\n A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/span><\/p>\n D\u00dc\u015eEYARA i\u015flemini yapabilmemiz i\u00e7in \u00f6ncelikle ilk veri setinde Tak\u0131m<\/strong> ve Puan<\/strong> s\u00fctunlar\u0131ndaki de\u011ferleri bir araya getiren bir yard\u0131mc\u0131 s\u00fctun olu\u015fturmam\u0131z gerekiyor.<\/span><\/p>\n A2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc A s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyip dolduraca\u011f\u0131z:<\/span> <\/p>\n A S\u00fctunu art\u0131k Tak\u0131m<\/strong> ve Pozisyon<\/strong> de\u011ferlerinin birle\u015fimini i\u00e7eriyor.<\/span><\/p>\n Bu yeni s\u00fctunu bir sonraki ad\u0131mda D\u00dc\u015eEYARA form\u00fcl\u00fcm\u00fczde kullanaca\u011f\u0131z.<\/span><\/p>\n Daha sonra I2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc I. s\u00fctunda kalan her h\u00fccreye s\u00fcr\u00fckleyip dolduraca\u011f\u0131z:<\/span> <\/p>\n Bu form\u00fcl, A<\/strong> s\u00fctununun F<\/strong> ve G<\/strong> s\u00fctunlar\u0131ndaki metin de\u011ferlerinin birle\u015fimini bulur ve D<\/strong> s\u00fctununda kar\u015f\u0131l\u0131k gelen de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Sa\u011f veri k\u00fcmesindeki her oyuncunun puan de\u011ferinin, sol veri k\u00fcmesindeki kar\u015f\u0131l\u0131k gelen oyuncunun puan de\u011feriyle e\u015fle\u015fti\u011fini unutmay\u0131n.<\/span><\/p>\n Birden fazla kritere sahip bir D\u00dc\u015eEYARA’y\u0131 ba\u015far\u0131yla kulland\u0131k.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar’da di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l yap\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Google E-Tablolar’da E\u011eERHATA’y\u0131 D\u00dc\u015eEYARA ile kullanma<\/a> \u00c7o\u011fu zaman, birden fazla kritere dayal\u0131 de\u011ferleri bulmak i\u00e7in Google E-Tablolar’da D\u00dc\u015eEYARA’y\u0131 kullanmak isteyebilirsiniz. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki iki veri k\u00fcmesine sahip oldu\u011fumuzu ve hem Tak\u0131m s\u00fctunundaki hem de Sol Veri K\u00fcmesi Konumu s\u00fctunundaki de\u011ferle e\u015fle\u015fen Noktalar s\u00fctunundaki de\u011feri d\u00f6nd\u00fcrmek i\u00e7in sa\u011f veri k\u00fcmesinde D\u00dc\u015eEYARA’y\u0131 kullanmak istedi\u011finizi varsayal\u0131m: A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir. 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":[],"class_list":["post-3406","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev1.jpg\")
<\/p>\n 1. Ad\u0131m: Destek S\u00fctunu Olu\u015fturun<\/strong><\/span><\/h2>\n
= B2<\/span> & C2<\/span><\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherchev2.jpg\")
<\/p>\n 2. Ad\u0131m: D\u00dc\u015eEYARA’y\u0131 Birden \u00c7ok \u00d6l\u00e7\u00fctle Kullan\u0131n<\/strong><\/span><\/h2>\n
=VLOOKUP( F2<\/span> & G2<\/span> , $A$2:$D$13<\/span> , 4, FALSE)<\/span><\/strong><\/pre>\n![\"Birden](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookup3.jpg\")
<\/p>\n Ek kaynaklar<\/span><\/strong><\/h2>\n
Google E-Tablolarda Ters D\u00dc\u015eEYARA Nas\u0131l Yap\u0131l\u0131r<\/a>
Google E-Tablolar’da b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 D\u00dc\u015eEYARA nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"