\u00d6rne\u011fin, bir \u015firketin \u00e7al\u0131\u015fanlar\u0131n\u0131n farkl\u0131 tarihlerde yapt\u0131\u011f\u0131 sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu varsayal\u0131m:<\/span> <\/p>\n Diyelim ki \u00c7al\u0131\u015fan<\/b> s\u00fctununda yinelenen de\u011ferlere sahip sat\u0131rlar\u0131 kald\u0131rmak, ancak Tarih<\/strong> s\u00fctununda en son tarihin bulundu\u011fu sat\u0131r\u0131 tutmak istiyorsunuz:<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n \u00d6ncelikle D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/span><\/p>\n Bu, veri k\u00fcmesinden benzersiz \u00e7al\u0131\u015fan adlar\u0131n\u0131n bir listesini olu\u015fturur:<\/span> <\/p>\n Daha sonra, her benzersiz \u00e7al\u0131\u015fan ad\u0131yla ili\u015fkili Tarih<\/strong> s\u00fctunundaki en son tarihi bulmak i\u00e7in E2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p E s\u00fctunundaki kalan h\u00fccrelere s\u00fcr\u00fckleyin:<\/span> <\/p>\n Varsay\u0131lan olarak Excel bu tarihleri seri numaralar\u0131 olarak g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n Bu say\u0131lar\u0131 tarihlere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in E2:E5<\/strong> aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n, ard\u0131ndan Giri\u015f<\/strong> sekmesindeki Say\u0131<\/strong> grubundaki Say\u0131 Bi\u00e7imi<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcn\u00fc t\u0131klay\u0131n ve ard\u0131ndan K\u0131sa Tarih’i<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n E s\u00fctunundaki say\u0131lar art\u0131k tarih olarak bi\u00e7imlendirilecek:<\/span> <\/p>\n D ve E s\u00fctunlar\u0131 art\u0131k orijinal veri k\u00fcmesini, \u00c7al\u0131\u015fan<\/strong> s\u00fctununda yinelenen de\u011ferlere sahip olan sat\u0131rlar\u0131n kald\u0131r\u0131ld\u0131\u011f\u0131 ve Tarih<\/strong> s\u00fctununda yaln\u0131zca en son tarihe sahip sat\u0131rlar\u0131n tutuldu\u011fu \u015fekilde g\u00f6steriyor.<\/span><\/p>\n \u00d6rne\u011fin, \u00c7al\u0131\u015fan<\/strong> s\u00fctununda yinelenen “Andy” de\u011ferine sahip d\u00f6rt sat\u0131r var, ancak bu d\u00f6rt sat\u0131r aras\u0131nda en g\u00fcncel tarihe sahip olan sat\u0131r 06\/01\/2023 tarihli olan\u0131d\u0131r:<\/span> <\/p>\n Bu, filtrelenmi\u015f veri k\u00fcmesinde “Andy” bulunan t\u00fcm olas\u0131 sat\u0131rlar aras\u0131nda tutulan sat\u0131rd\u0131r.<\/span><\/p>\n Ayn\u0131 i\u015flem her bir benzersiz \u00e7al\u0131\u015fan ad\u0131 i\u00e7in tekrarlan\u0131r.<\/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: kopyalar\u0131n nas\u0131l say\u0131laca\u011f\u0131<\/a> \u00c7o\u011fu zaman, Excel’deki yinelenen sat\u0131rlar\u0131 kald\u0131rmak, ancak en son tarihi i\u00e7eren sat\u0131r\u0131 belirli bir s\u00fctunda tutmak isteyebilirsiniz. \u00d6rne\u011fin, bir \u015firketin \u00e7al\u0131\u015fanlar\u0131n\u0131n farkl\u0131 tarihlerde yapt\u0131\u011f\u0131 sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011funuzu varsayal\u0131m: Diyelim ki \u00c7al\u0131\u015fan s\u00fctununda yinelenen de\u011ferlere sahip sat\u0131rlar\u0131 kald\u0131rmak, ancak Tarih s\u00fctununda en son tarihin bulundu\u011fu sat\u0131r\u0131 tutmak istiyorsunuz: A\u015fa\u011f\u0131daki \u00f6rnek […]<\/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-4820","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garder-nouveau1.png\")
<\/p>\n \u00d6rnek: Yinelenenleri kald\u0131r\u0131n ancak sat\u0131r\u0131 Excel’deki en son tarihe sahip tutun<\/strong><\/h2>\n
=SINGLE( A2:A13 )<\/span><\/span><\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garder-nouveau2.png\")
<\/p>\n =MAX(IF( $A$2:$A$13<\/span> = D2<\/span> , $B$2:$B$13<\/span> ))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garder-nouveau3.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-courte.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garder-nouveau4.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garder-nouveau5.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: yinelenen sat\u0131rlar\u0131n nas\u0131l vurgulanaca\u011f\u0131<\/a>
Excel: D\u00dc\u015eEYARA Kullan\u0131larak Yinelenenler Nas\u0131l Bulunur?<\/a>
Excel: \u0130ki S\u00fctuna Dayal\u0131 Yinelenen Sat\u0131rlar\u0131 Kald\u0131rma<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"