Microsoft Excel ve Google Sheets, her iki platformda da kullan\u0131c\u0131lar\u0131n veri setlerini kolayca d\u00fczenlemelerini sa\u011flayan “SIRALA” fonksiyonuna sahiptir. Bu fonksiyon, belirlenen s\u00fctuna g\u00f6re verileri artan veya azalan d\u00fczende s\u0131ralamak amac\u0131yla kullan\u0131l\u0131r ve b\u00fcy\u00fck veri k\u00fcmelerini organize etme ve analiz etme konusunda b\u00fcy\u00fck kolayl\u0131klar sunar.<\/p>\n
SIRALA<\/b> fonksiyonun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n \u0130\u015fte bu arg\u00fcmanlar\u0131n her birinin a\u00e7\u0131klamalar\u0131:<\/p>\n \u00d6rnek kullan\u0131m:<\/p>\n Bu form\u00fcl, A2’den B10’a kadar olan aral\u0131\u011f\u0131 ikinci s\u00fctunda (B s\u00fctunu) yer alan de\u011ferlere g\u00f6re azalan s\u0131rada s\u0131ralar.<\/p>\n Senaryo 1: Sat\u0131\u015f Verilerini S\u0131ralama<\/b><\/p>\n Bir \u015firketin ayl\u0131k sat\u0131\u015f verileri i\u00e7eren bir tabloyu ele alal\u0131m. Bu verileri sat\u0131\u015f miktar\u0131na g\u00f6re azalan d\u00fczende s\u0131ralamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131l\u0131r:<\/p>\n Bu form\u00fcl, A2 ve B20 aras\u0131ndaki verileri, B s\u00fctunu (sat\u0131\u015f miktarlar\u0131) temel al\u0131narak azalan d\u00fczende s\u0131ralar ve b\u00f6ylece en y\u00fcksek sat\u0131\u015f yapanlar en \u00fcste gelir.<\/p>\n Senaryo 2: \u00d6\u011frenci Notlar\u0131n\u0131 S\u0131ralama<\/b><\/p>\n \u00d6\u011frenci notlar\u0131n\u0131 not de\u011ferlerine g\u00f6re artan d\u00fczende s\u0131ralamak isterseniz, a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p>\n Bu form\u00fcl, A1’den C30’a kadar olan alan\u0131, C s\u00fctunu (notlar) baz al\u0131narak artan d\u00fczende s\u0131ralar, b\u00f6ylece notlar en d\u00fc\u015f\u00fckten en y\u00fckse\u011fe do\u011fru s\u0131ralanm\u0131\u015f olur.<\/p>\n Microsoft Excel ve Google Sheets\u2019in bu \u00e7ok y\u00f6nl\u00fc “SIRALA” fonksiyonunu kullanarak, verilerinizi rahatl\u0131kla s\u0131ralayabilir ve daha anla\u015f\u0131l\u0131r bir hale getirebilirsiniz. Her iki platformda da benzer \u015fekilde i\u015flev g\u00f6ren bu fonksiyon, veriler \u00fczerinde h\u0131zl\u0131 ve etkili d\u00fczenlemeler yapman\u0131z\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":" Aral\u0131\u011f\u0131n veya dizinin i\u00e7eri\u011fini s\u0131ralar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15644","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\n=SIRALA(dizi; s\u0131ralama_s\u00fctunu; azalan_mi; [s\u0131ra])<\/code><\/pre>\n\n
=SIRALA(A2:B10, 2, TRUE)<\/code><\/pre>\nGer\u00e7ek D\u00fcnya Senaryolar\u0131<\/h2>\n
=SIRALA(A2:B20, 2, TRUE)<\/code><\/pre>\n=SIRALA(A1:C30, 3, FALSE)<\/code><\/pre>\n