SIRALA\u00d6L\u00c7\u00dcT<\/strong> fonksiyonu, Microsoft Excel ve Google Sheets’te belirtilen bir veya birden fazla referans aral\u0131\u011f\u0131 temelinde bir dizi veya aral\u0131\u011f\u0131 s\u0131ralamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, g\u00f6nderilen s\u0131ralama kriterine ba\u011fl\u0131 olarak veri dizinizi yeniden s\u0131ralar. <\/p>\n SIRALA\u00d6L\u00c7\u00dcT<\/strong> fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n Bir \u00fcr\u00fcn listesini sat\u0131\u015f miktar\u0131na g\u00f6re azalan s\u0131rada d\u00fczenlemek istedi\u011fimiz bir durumu ele alal\u0131m:<\/p>\n Burada, A2:A6 aral\u0131\u011f\u0131 \u00fcr\u00fcn isimlerini, B2:B6 aral\u0131\u011f\u0131 ise bu \u00fcr\u00fcnlerin sat\u0131\u015f miktarlar\u0131n\u0131 i\u00e7erir. Bu form\u00fcl, sat\u0131\u015f miktarlar\u0131na g\u00f6re \u00fcr\u00fcn listesini azalan s\u0131rayla s\u0131ralar. <\/p>\n \u015eirketinizin m\u00fc\u015fteri baz\u0131nda sat\u0131\u015f miktarlar\u0131n\u0131 listesi var, ve bu listeyi m\u00fc\u015fteri isimlerine g\u00f6re alfabetik s\u0131rayla ve her bir m\u00fc\u015fteri i\u00e7in sat\u0131\u015f miktar\u0131na g\u00f6re azalan \u015fekilde s\u0131ralamak istiyorsunuz: <\/p>\n Bu \u00f6rnekte, A2:A10 aral\u0131\u011f\u0131nda m\u00fc\u015fteri isimleri, B2:B10 aral\u0131\u011f\u0131nda ise sat\u0131\u015f miktarlar\u0131 bulunmaktad\u0131r. M\u00fc\u015fteri isimleri \u00f6nce artan s\u0131rayla s\u0131ralanacak, ard\u0131ndan her m\u00fc\u015fteri i\u00e7in sat\u0131\u015f miktarlar\u0131 azalan s\u0131rayla d\u00fczenlenecektir. <\/p>\n Bir s\u0131n\u0131ftaki \u00f6\u011frencilerin notlar\u0131n\u0131 hem isimlerine g\u00f6re alfabetik olarak hem de notlar\u0131na g\u00f6re azalan \u015fekilde d\u00fczenlemek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir: <\/p>\n Burada, A s\u00fctunu \u00f6\u011frenci isimlerini, C s\u00fctunu ise \u00f6\u011frenci notlar\u0131n\u0131 i\u00e7erir. \u0130lk olarak \u00f6\u011frenciler isimlerine g\u00f6re alfabetik olarak s\u0131ralan\u0131r, sonras\u0131nda ayn\u0131 isme sahip \u00f6\u011frenciler notlar\u0131na g\u00f6re azalan s\u0131rayla d\u00fczenlenir. <\/p>\n","protected":false},"excerpt":{"rendered":" Aral\u0131k veya dizi i\u00e7eri\u011fini, ilgili aral\u0131ktaki veya dizideki de\u011ferleri temel alarak 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-15645","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nS\u00f6zdizimi ve Parametreler<\/h2>\n
=SIRALA\u00d6L\u00c7\u00dcT(dizi, s\u0131ralama_dizisi1, [s\u0131ralama_t\u00fcr\u00fc1], [s\u0131ralama_dizisi2, s\u0131ralama_t\u00fcr\u00fc2], ...)<\/code><\/pre>\n\n
\u00d6rnek Kullan\u0131m<\/h2>\n
=SIRALA\u00d6L\u00c7\u00dcT(A2:A6, B2:B6, -1)<\/code><\/pre>\nS\u0131ralama \u0130le \u0130lgili Pratik Problemler<\/h2>\n
Problem 1: Sat\u0131\u015f Raporu S\u0131ralamas\u0131<\/h2>\n
=SIRALA\u00d6L\u00c7\u00dcT(A2:B10, A2:A10, 1, B2:B10, -1)<\/code><\/pre>\nProblem 2: \u00d6\u011frenci Notlar\u0131n\u0131 S\u0131ralama<\/h2>\n
=SIRALA\u00d6L\u00c7\u00dcT(A2:C10, A2:A10, 1, C2:C10, -1)<\/code><\/pre>\n