Form\u00fcl 1: Say\u0131lar\u0131 artan d\u00fczende s\u0131ralay\u0131n (en k\u00fc\u00e7\u00fckten en b\u00fcy\u00fc\u011fe)<\/strong><\/span><\/p>\n Form\u00fcl 2: Say\u0131lar\u0131 azalan d\u00fczende s\u0131ralay\u0131n (b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe)<\/strong><\/span><\/p>\n Bu iki form\u00fcl, Excel’de K\u00dc\u00c7\u00dcK<\/strong> veya B\u00dcY\u00dcK<\/strong> i\u015flevlerini kullanman\u0131za ba\u011fl\u0131 olarak A2:A13<\/strong> aral\u0131\u011f\u0131ndaki say\u0131lar\u0131 artan veya azalan d\u00fczende s\u0131ralar.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, Excel’deki a\u015fa\u011f\u0131daki say\u0131 s\u00fctunuyla her form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n A2:A13<\/strong> aral\u0131\u011f\u0131ndaki en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcrmek i\u00e7in B2 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra A2:A13<\/strong> aral\u0131\u011f\u0131ndaki say\u0131lar\u0131 artan s\u0131rada d\u00f6nd\u00fcrmek i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctununda kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n B S\u00fctunu art\u0131k A s\u00fctunundaki say\u0131lar\u0131 artan s\u0131rada (en k\u00fc\u00e7\u00fckten en b\u00fcy\u00fc\u011fe) g\u00f6steriyor<\/span><\/p>\n Bu form\u00fcl\u00fcn, bir aral\u0131ktaki n’inci en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcrmek i\u00e7in Excel’deki K\u00dc\u00c7\u00dcK<\/strong> i\u015flevini kulland\u0131\u011f\u0131n\u0131 ve ard\u0131ndan n’nin de\u011ferini belirtmek i\u00e7in SATIR<\/strong> i\u015flevini kulland\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n \u00d6rne\u011fin, B s\u00fctunundaki ilk de\u011fer, A s\u00fctunundaki 1. en k\u00fc\u00e7\u00fck de\u011feri temsil eder.<\/span><\/p>\n Daha sonra B s\u00fctunundaki ikinci de\u011fer, A s\u00fctunundaki ikinci en k\u00fc\u00e7\u00fck de\u011feri temsil eder.<\/span><\/p>\n Ve benzeri.<\/span><\/p>\n A2:A13<\/strong> aral\u0131\u011f\u0131ndaki en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcrmek i\u00e7in B2 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra A2:A13<\/strong> aral\u0131\u011f\u0131ndaki say\u0131lar\u0131 azalan s\u0131rada d\u00f6nd\u00fcrmek i\u00e7in bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n B S\u00fctunu art\u0131k A s\u00fctunundaki say\u0131lar\u0131 artan s\u0131rada (en b\u00fcy\u00fc\u011f\u00fcnden en k\u00fc\u00e7\u00fc\u011f\u00fcne) g\u00f6r\u00fcnt\u00fcl\u00fcyor.<\/span><\/p>\n Bu form\u00fcl\u00fcn, bir aral\u0131ktaki n’inci en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcrmek i\u00e7in Excel’deki B\u00dcY\u00dcK<\/b> i\u015flevini kulland\u0131\u011f\u0131n\u0131 ve ard\u0131ndan n’nin de\u011ferini belirtmek i\u00e7in SATIR<\/strong> i\u015flevini kulland\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n \u00d6rne\u011fin, B s\u00fctunundaki ilk de\u011fer, A s\u00fctunundaki ilk en b\u00fcy\u00fck de\u011feri temsil eder.<\/span><\/p>\n Daha sonra B s\u00fctunundaki ikinci de\u011fer, A s\u00fctunundaki ikinci en b\u00fcy\u00fck de\u011feri temsil eder.<\/span><\/p>\n Ve benzeri.<\/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: bir pivot tablonun birden \u00e7ok s\u00fctuna g\u00f6re nas\u0131l s\u0131ralanaca\u011f\u0131<\/a> Excel’deki say\u0131lar\u0131 artan veya azalan d\u00fczende s\u0131ralamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanabilirsiniz: Form\u00fcl 1: Say\u0131lar\u0131 artan d\u00fczende s\u0131ralay\u0131n (en k\u00fc\u00e7\u00fckten en b\u00fcy\u00fc\u011fe) =SMALL( $A$2:$A$13 ,ROWS( $A$2:A2 )) Form\u00fcl 2: Say\u0131lar\u0131 azalan d\u00fczende s\u0131ralay\u0131n (b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe) =LARGE( $A$2:$A$13 ,ROWS( $A$2:A2 )) Bu iki form\u00fcl, Excel’de K\u00dc\u00c7\u00dcK veya B\u00dcY\u00dcK i\u015flevlerini kullanman\u0131za ba\u011fl\u0131 olarak A2:A13 aral\u0131\u011f\u0131ndaki say\u0131lar\u0131 artan veya […]<\/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-5023","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =SMALL( $A$2:$A$13<\/span> ,ROWS( $A$2:A2<\/span> ))\n<\/strong><\/pre>\n =LARGE( $A$2:$A$13<\/span> ,ROWS( $A$2:A2<\/span> ))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire-de-tri1.png\")
<\/p>\n \u00d6rnek 1: Excel’de Say\u0131lar\u0131 Artan D\u00fczende S\u0131ralama<\/strong><\/span><\/h2>\n
=SMALL( $A$2:$A$13<\/span> ,ROWS( $A$2:A2<\/span> ))<\/strong><\/pre>\n![\"Excel,](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire-de-tri2.png\")
<\/p>\n \u00d6rnek 2:<\/strong><\/span> Excel’de say\u0131lar\u0131 azalan d\u00fczende<\/strong><\/span> s\u0131ralama<\/h2>\n
=LARGE( $A$2:$A$13<\/span> ,ROWS( $A$2:A2<\/span> ))<\/strong><\/pre>\n![\"Excel,](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire-de-tri3.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: Bart grafi\u011findeki \u00e7ubuklar nas\u0131l s\u0131ralan\u0131r<\/a>
Excel: soyad\u0131na g\u00f6re nas\u0131l s\u0131ralan\u0131r<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"