Yatay olarak birden fazla de\u011fer d\u00f6nd\u00fcrmek i\u00e7in INDEX<\/strong> ve MATCH<\/strong> kullanmak istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/span><\/p>\n Bu \u00f6zel form\u00fcl, A17<\/strong> h\u00fccresindeki A2:A13<\/strong> aral\u0131\u011f\u0131ndaki de\u011feri arar ve B2:B13<\/strong> aral\u0131\u011f\u0131nda kar\u015f\u0131l\u0131k gelen de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Daha sonra birden fazla de\u011feri g\u00f6r\u00fcnt\u00fclemek i\u00e7in bu form\u00fcl\u00fc yatay olarak s\u00fcr\u00fckleyebilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekte bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n Farkl\u0131 tak\u0131mlardaki basketbolcular\u0131n att\u0131\u011f\u0131 puanlar hakk\u0131nda bilgi i\u00e7eren Excel’de a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki tak\u0131m s\u00fctununda “Mavs” aramas\u0131 yapmak ve her puan de\u011ferini yatay olarak d\u00f6nd\u00fcrmek istiyoruz.<\/span><\/p>\n Bunu yapmak i\u00e7in B17<\/b> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/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 Daha sonra #SAYI!<\/strong> g\u00f6r\u00fcnt\u00fcleyen bir h\u00fccreyle kar\u015f\u0131la\u015f\u0131ncaya kadar bu form\u00fcl\u00fc t\u0131klay\u0131p yatay olarak sa\u011fa s\u00fcr\u00fckleyebiliriz. tak\u0131m s\u00fctununda \u201cMavs\u201da kar\u015f\u0131l\u0131k gelen puan de\u011ferlerinin her birini g\u00f6r\u00fcnt\u00fclemek i\u00e7in:<\/span> <\/p>\n Form\u00fcl ayn\u0131 sat\u0131rda 24, 40, 15 ve 25 de\u011ferlerini do\u011fru bir \u015fekilde d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Bu de\u011ferlerin her birinin puan s\u00fctununda, tak\u0131m s\u00fctunundaki “Mav’lere” kar\u015f\u0131l\u0131k gelen bir de\u011feri temsil etti\u011fini unutmay\u0131n:<\/span> <\/p>\n Ba\u015fka bir tak\u0131m\u0131n puan de\u011ferlerini bulmak i\u00e7in A17<\/strong> h\u00fccresindeki tak\u0131m ad\u0131n\u0131 d\u00fczenlemekten \u00e7ekinmeyin.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: INDEX MATCH ile IF i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131<\/a> Bir s\u00fctunda bir de\u011fer bulmak ve kar\u015f\u0131l\u0131k gelen de\u011feri ba\u015fka bir s\u00fctunda d\u00f6nd\u00fcrmek i\u00e7in Excel’deki INDEX ve KA\u00c7INCI i\u015flevlerini kullanabilirsiniz. Yatay olarak birden fazla de\u011fer d\u00f6nd\u00fcrmek i\u00e7in INDEX ve MATCH kullanmak istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz: =INDEX( $B$2:$B$13 , SMALL(IF( $A$17 = $A$2:$A$13 ,ROW( $A$2:$A$13 )-ROW( $B$2 )+1), COLUMN( A1 ))) Bu \u00f6zel form\u00fcl, A17 h\u00fccresindeki […]<\/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-4808","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =INDEX( $B$2:$B$13<\/span> , SMALL(IF( $A$17<\/span> = $A$2:$A$13<\/span> ,ROW( $A$2:$A$13<\/span> )-ROW( $B$2<\/span> )+1), COLUMN( A1<\/span> )))\n<\/strong><\/pre>\n \u00d6rnek: Birden fazla de\u011feri yatay olarak d\u00f6nd\u00fcrmek i\u00e7in INDEX MATCH’i kullan\u0131n<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vho1.png\")
<\/p>\n =INDEX( $B$2:$B$13<\/span> , SMALL(IF( $A$17<\/span> = $A$2:$A$13<\/span> ,ROW( $A$2:$A$13<\/span> )-ROW( $B$2<\/span> )+1), COLUMN( A1<\/span> )))\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ih1.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ih2.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vho3.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: INDEX MATCH ile SUM nas\u0131l kullan\u0131l\u0131r?<\/a>
Excel: Birden \u00c7ok De\u011feri Dikey Olarak D\u00f6nd\u00fcrmek i\u00e7in INDEX ve MATCH’i Kullan\u0131n<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"