A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Excel’de sola birle\u015ftirme ger\u00e7ekle\u015ftirmek i\u00e7in D\u00dc\u015eEYARA<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Excel’de iki tablo i\u00e7in a\u015fa\u011f\u0131daki de\u011ferleri girerek ba\u015flayal\u0131m:<\/span> <\/p>\n Sol tablodaki t\u00fcm sat\u0131rlar\u0131 tutaca\u011f\u0131m\u0131z ve yaln\u0131zca sa\u011f tablodaki Tak\u0131m<\/strong> s\u00fctununda e\u015fle\u015fen de\u011ferlere sahip sat\u0131rlar\u0131 birle\u015ftirece\u011fimiz bir sol birle\u015ftirme ger\u00e7ekle\u015ftirece\u011fiz.<\/span><\/p>\n Daha sonra ilk tablodaki de\u011ferleri kopyalay\u0131p yeni bir h\u00fccre aral\u0131\u011f\u0131na yap\u0131\u015ft\u0131ral\u0131m:<\/span> <\/p>\n Daha sonra C13 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazaca\u011f\u0131z:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc C s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyip dolduraca\u011f\u0131z:<\/span> <\/p>\n Asistler<\/strong> ve Ribaundlar<\/strong> s\u00fctun ba\u015fl\u0131klar\u0131n\u0131 da eklemekten \u00e7ekinmeyin:<\/span> <\/p>\n Sol birle\u015ftirme art\u0131k tamamland\u0131.<\/span><\/p>\n Soldaki tablodaki her sat\u0131r tutulur ve yaln\u0131zca sa\u011fdaki tablodaki e\u015fle\u015fen tak\u0131m adlar\u0131na sahip sat\u0131rlar tutulur.<\/span><\/p>\n Sa\u011fdaki tabloda belirli bir tak\u0131m\u0131n bir ma\u00e7\u0131 yoksa Asistler ve Ribaund s\u00fctunlar\u0131nda #N\/A<\/strong> de\u011feri g\u00f6r\u00fcnt\u00fclenir.<\/span><\/p>\n \u00d6rne\u011fin, Mav’ler sa\u011fdaki tabloda mevcuttu, dolay\u0131s\u0131yla asist ve ribaund i\u00e7in kar\u015f\u0131l\u0131k gelen de\u011ferlere sahiplerdi.<\/span><\/p>\n Ancak Warriors do\u011fru grupta yer alamad\u0131, bu y\u00fczden asist ve ribaund konusunda #N\/A’lar\u0131<\/strong> var.<\/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: birden \u00e7ok kelime i\u00e7eren h\u00fccrelerin filtrelenmesi<\/a> Sol birle\u015ftirme, sol tablodaki her sat\u0131r\u0131n tutuldu\u011fu ve yaln\u0131zca sa\u011f tablodaki belirli bir s\u00fctunda e\u015fle\u015fen de\u011fere sahip sat\u0131rlar\u0131n tutuldu\u011fu iki tabloyu birle\u015ftirmenize olanak tan\u0131r. A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Excel’de sola birle\u015ftirme ger\u00e7ekle\u015ftirmek i\u00e7in D\u00dc\u015eEYARA i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir. Ad\u0131m 1: Her tablo i\u00e7in de\u011ferleri girin Excel’de iki tablo i\u00e7in a\u015fa\u011f\u0131daki de\u011ferleri girerek ba\u015flayal\u0131m: Sol tablodaki […]<\/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-3397","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n Ad\u0131m 1: Her tablo i\u00e7in de\u011ferleri girin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche1.jpg\")
<\/p>\n 2. Ad\u0131m: \u0130lk tablonun bir kopyas\u0131n\u0131 olu\u015fturun<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche2.jpg\")
<\/p>\n 3. Ad\u0131m: D\u00dc\u015eEYARA’y\u0131 kullanarak sol birle\u015ftirme ger\u00e7ekle\u015ftirin<\/strong><\/span><\/h2>\n
=VLOOKUP( A2<\/span> , $E$2:$G$9<\/span> , {2,3}, FALSE)\n<\/strong><\/pre>\n![\"Excel'de](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche3.jpg\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gauche4.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: bir s\u00fctunu \u00e7e\u015fitli de\u011ferlere g\u00f6re filtreleme<\/a>
Excel geli\u015fmi\u015f filtresi: bo\u015f olmayan de\u011ferlere sahip sat\u0131rlar\u0131 g\u00f6ster<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"