Y\u00f6ntem 1: Tek bir kritere g\u00f6re en eski tarihi bulma<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, A2<\/strong> :A13 aral\u0131\u011f\u0131ndaki de\u011ferin F1<\/strong> h\u00fccresindeki de\u011fere e\u015fit oldu\u011fu C2:C13<\/strong> aral\u0131\u011f\u0131ndaki en eski tarihi bulur.<\/span><\/p>\n Y\u00f6ntem 2: Birden fazla kritere g\u00f6re en eski tarihi bulma<\/strong><\/span><\/p>\n Bu \u00f6zel form\u00fcl, C2:C13<\/strong> aral\u0131\u011f\u0131ndaki en eski tarihi bulur; burada A2:A13<\/strong> aral\u0131\u011f\u0131ndaki de\u011fer, F1<\/strong> h\u00fccresindeki de\u011fere ve<\/em> B2:B13<\/strong> aral\u0131\u011f\u0131ndaki de\u011fer, F2<\/strong> h\u00fccresindeki de\u011fere e\u015fittir.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, basketbolcular\u0131n farkl\u0131 tak\u0131mlara ne zaman kat\u0131ld\u0131klar\u0131 hakk\u0131nda bilgi i\u00e7eren Excel’deki a\u015fa\u011f\u0131daki veri k\u00fcmesiyle her bir form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n Diyelim ki Rockets tak\u0131m\u0131 oyuncular\u0131 aras\u0131nda en erken tarihi bulmak istiyoruz.<\/span><\/p>\n Rockets tak\u0131m\u0131n\u0131n ad\u0131n\u0131 F1<\/strong> h\u00fccresinde belirtebilir, ard\u0131ndan en erken tarihi bulmak i\u00e7in F2<\/strong> 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 Varsay\u0131lan olarak Excel, tarihi say\u0131sal bi\u00e7imde g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n Bunu tan\u0131nabilir bir tarih bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in F2<\/strong> h\u00fccresini se\u00e7in, ard\u0131ndan Giri\u015f<\/strong> sekmesindeki Say\u0131 Bi\u00e7imi<\/strong> a\u00e7\u0131l\u0131r men\u00fcs\u00fcne t\u0131klay\u0131n ve ard\u0131ndan K\u0131sa Tarih’e<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Tarih art\u0131k 04\/13\/2009<\/strong> bi\u00e7iminde olacakt\u0131r; bu, Tak\u0131m<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccredeki de\u011ferin Roketlere e\u015fit oldu\u011fu Kat\u0131lma Tarihi<\/strong> s\u00fctunundaki en erken tarihi temsil eder:<\/span> <\/p>\n Diyelim ki Mavs tak\u0131m\u0131nda forvet pozisyonunda bulunan oyuncular aras\u0131nda en erken tarihi bulmak istiyoruz.<\/span><\/p>\n Bu kriterleri F1<\/strong> ve F2<\/strong> h\u00fccrelerinde belirtebilir, ard\u0131ndan en erken tarihi bulmak i\u00e7in F3<\/strong> 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 Form\u00fcl, 1\/4\/2019<\/strong> de\u011ferini d\u00f6nd\u00fcr\u00fcr; bu, Ekip<\/strong> s\u00fctunundaki ilgili h\u00fccredeki de\u011ferin Mavs’e e\u015fit oldu\u011fu ve<\/em> Konum<\/strong> s\u00fctunundaki kar\u015f\u0131l\u0131k gelen h\u00fccrenin Forward’a e\u015fit oldu\u011fu Kat\u0131lma Tarihi<\/strong> s\u00fctunundaki en erken tarihi temsil eder.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer genel g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: belirli bir tarihte ya\u015f nas\u0131l hesaplan\u0131r<\/a> Belirli bir kritere g\u00f6re belirli bir s\u00fctundaki en eski tarihi bulmak i\u00e7in Excel’de a\u015fa\u011f\u0131daki form\u00fclleri kullanabilirsiniz: Y\u00f6ntem 1: Tek bir kritere g\u00f6re en eski tarihi bulma =MIN(IF( $A$2:$A$13 = F1 , $C$2:$C$13 )) Bu \u00f6zel form\u00fcl, A2 :A13 aral\u0131\u011f\u0131ndaki de\u011ferin F1 h\u00fccresindeki de\u011fere e\u015fit oldu\u011fu C2:C13 aral\u0131\u011f\u0131ndaki en eski tarihi bulur. Y\u00f6ntem 2: Birden fazla […]<\/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-5002","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =MIN(IF( $A$2:$A$13<\/span> = F1<\/span> , $C$2:$C$13<\/span> ))\n<\/strong><\/pre>\n =MINIFS( C2:C13<\/span> , A2:A13<\/span> , F1<\/span> , B2:B13<\/span> , F2<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ecrit1.png\")
<\/p>\n \u00d6rnek 1: Excel’deki bir kritere g\u00f6re en eski tarihi bulma<\/strong><\/span><\/h2>\n
=MIN(IF( $A$2:$A$13<\/span> = F1<\/span> , $C$2:$C$13<\/span> ))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ecrit2.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-courte.png\")
<\/p>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ecrit3.png\")
<\/p>\n \u00d6rnek 2: Excel’de birden fazla kritere g\u00f6re en eski tarihi bulma<\/strong><\/span><\/h2>\n
=MINIFS( C2:C13<\/span> , A2:A13<\/span> , F1<\/span> , B2:B13<\/span> , F2<\/span> )<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ecrit4.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: tarihin iki tarih aras\u0131nda olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir<\/a>
Excel: Tarihe g\u00f6re D\u00dc\u015eEYARA nas\u0131l kullan\u0131l\u0131r?<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"