Ancak, bir aral\u0131ktaki bir de\u011feri aramak ve t\u00fcm e\u015fle\u015fmeler<\/em> i\u00e7in e\u015fle\u015fen de\u011ferleri d\u00f6nd\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, C2:C11<\/strong> aral\u0131\u011f\u0131nda arama yapar ve C2:<\/strong> C11 i\u00e7indeki de\u011ferin E2’ye<\/strong> e\u015fit oldu\u011fu t\u00fcm sat\u0131rlar<\/em> i\u00e7in A2:A11<\/strong> aral\u0131\u011f\u0131ndaki e\u015fle\u015fen de\u011ferleri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Google E-Tablolar’da \u00e7e\u015fitli basketbol tak\u0131mlar\u0131yla ilgili bilgileri g\u00f6r\u00fcnt\u00fcleyen a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n A s\u00fctununda “Roketler” tak\u0131m\u0131n\u0131 bulmak ve C s\u00fctununda kar\u015f\u0131l\u0131k gelen puan de\u011ferini d\u00f6nd\u00fcrmek i\u00e7in D\u00dc\u015eEYARA<\/strong> ile a\u015fa\u011f\u0131daki form\u00fcl\u00fc kulland\u0131\u011f\u0131m\u0131z\u0131 varsayal\u0131m:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n D\u00dc\u015eEYARA<\/strong> i\u015flevi, “Tak\u0131m” s\u00fctununda Roketlerin ilk olu\u015fumu i\u00e7in “Puan” s\u00fctunundaki de\u011feri d\u00f6nd\u00fcr\u00fcr, ancak “Tak\u0131m” s\u00fctununda Roketleri de i\u00e7eren di\u011fer iki sat\u0131r i\u00e7in puan de\u011ferleri d\u00f6nd\u00fcrmede ba\u015far\u0131s\u0131z olur. Tak\u0131m”.<\/span><\/p>\n “Tak\u0131m” s\u00fctununda Roket i\u00e7eren t\u00fcm sat\u0131rlar\u0131n puan de\u011ferlerini d\u00f6nd\u00fcrmek i\u00e7in bunun yerine F\u0130LTRE<\/strong> fonksiyonunu kullanabiliriz.<\/span><\/p>\n \u0130\u015fte kullanabilece\u011fimiz tam form\u00fcl:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n F\u0130LTRE<\/strong> fonksiyonunun, “Tak\u0131m” s\u00fctununun Roketleri i\u00e7erdi\u011fi \u00fc\u00e7 sat\u0131r i\u00e7in \u00fc\u00e7 nokta de\u011ferini d\u00f6nd\u00fcrd\u00fc\u011f\u00fcn\u00fc unutmay\u0131n.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar’da di\u011fer yayg\u0131n g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Google E-Tablolar: D\u00dc\u015eEYARA’y\u0131 Birden \u00c7ok \u00d6l\u00e7\u00fctle Kullan\u0131n<\/a> Varsay\u0131lan olarak, Google E-Tablolar’daki D\u00dc\u015eEYARA i\u015flevi bir aral\u0131ktaki de\u011feri arar ve yaln\u0131zca ilk e\u015fle\u015fme i\u00e7in e\u015fle\u015fen bir de\u011fer d\u00f6nd\u00fcr\u00fcr. Ancak, bir aral\u0131ktaki bir de\u011feri aramak ve t\u00fcm e\u015fle\u015fmeler i\u00e7in e\u015fle\u015fen de\u011ferleri d\u00f6nd\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: =FILTER( C2:C11 , E2 = A2:A11 ) Bu \u00f6zel form\u00fcl, C2:C11 aral\u0131\u011f\u0131nda arama yapar ve C2: C11 i\u00e7indeki de\u011ferin […]<\/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-3407","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =FILTER( C2:C11<\/span> , E2<\/span> = A2:A11<\/span> )<\/strong><\/pre>\n \u00d6rnek: T\u00fcm e\u015fle\u015fmeleri d\u00f6nd\u00fcrmek i\u00e7in D\u00dc\u015eEYARA’y\u0131 kullan\u0131n<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tous1.jpg\")
<\/p>\n =VLOOKUP( E2<\/span> , A2:C11,3<\/span> ,FALSE)\n<\/span><\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tous2.jpg\")
<\/p>\n =FILTER( C2:C11<\/span> , E2<\/span> = A2:A11<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tous3.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Google E-Tablolar: Ters D\u00dc\u015eEYARA Nas\u0131l Yap\u0131l\u0131r<\/a>
Google E-Tablolar: birden \u00e7ok ko\u015fulla nas\u0131l filtreleme yap\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"