{"id":10641,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/sortuj-wedlug\/"},"modified":"2021-02-26T05:24:43","modified_gmt":"2021-02-26T05:24:43","slug":"sortby","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pl\/sortby\/","title":{"rendered":"SORTUJ.WED\u0141UG,"},"content":{"rendered":"

Funkcja SORTBY<\/code> (pol. SORTUJ.WED\u0141UG<\/code>) w Microsoft Excel i Google Sheets umo\u017cliwia sortowanie zakresu lub tablicy danych na podstawie zwi\u0105zanego zakresu lub tablicy wed\u0142ug jednego lub wi\u0119cej kryteri\u00f3w sortowania. Jest to bardzo przydatne narz\u0119dzie do porz\u0105dkowania du\u017cych zbior\u00f3w danych, zapewniaj\u0105ce elastyczno\u015b\u0107 niezb\u0119dn\u0105 w zaawansowanych analizach danych.<\/p>\n

Opis i sk\u0142adnia funkcji<\/h2>\n

Sk\u0142adnia funkcji SORTBY<\/code> prezentuje si\u0119 nast\u0119puj\u0105co:<\/p>\n

=SORTUJ.WED\u0141UG(tablica; kolumna_sortowana1; [kolejno\u015b\u01071]; [kolumna_sortowana2; kolejno\u015b\u01072]; ...)<\/code><\/pre>\n
    \n
  • tablica<\/strong> – zakres lub tablica, kt\u00f3ra zawiera dane do posortowania.<\/li>\n
  • kolumna_sortowana1<\/strong> – zakres lub tablica stanowi\u0105ca pierwszy klucz sortowania.<\/li>\n
  • kolejno\u015b\u01071<\/strong> – (opcjonalnie) okre\u015bla kierunek sortowania dla kolumna_sortowana1<\/strong>. Mo\u017cliwe warto\u015bci to 1 (dla sortowania rosn\u0105cego) lub -1 (dla sortowania malej\u0105cego). Domy\u015blnie warto\u015b\u0107 jest ustawiona na 1.<\/li>\n
  • Dodatkowe pary argument\u00f3w kolumna_sortowana<\/strong> i kolejno\u015b\u0107<\/strong> mo\u017cna doda\u0107, aby sortowa\u0107 dane wed\u0142ug wielu kryteri\u00f3w.<\/li>\n<\/ul>\n
    Przyk\u0142ad u\u017cycia funkcji<\/h2>\n
    Oto przyk\u0142ad u\u017cycia funkcji:<\/p>\n
    =SORTUJ.WED\u0141UG(A2:B10, B2:B10, 1)<\/code><\/pre>\n
    W tym przypadku, dane z zakresu A2:B10 zostan\u0105 posortowane rosn\u0105co (kolejno\u015b\u0107 ustawiona na 1) na podstawie warto\u015bci w kolumnie B.<\/p>\n
    Praktyczne zastosowania<\/h2>\n
    Zadanie 1: Sortowanie listy student\u00f3w<\/h2>\n
    Gdy mamy list\u0119 student\u00f3w z ich wynikami egzamin\u00f3w i chcemy ich posortowa\u0107 najpierw wed\u0142ug nazwiska, a nast\u0119pnie wed\u0142ug imienia, mo\u017cemy u\u017cy\u0107:<\/p>\n
    =SORTUJ.WED\u0141UG(A2:C100, B2:B100, 1, A2:A100, 1)<\/code><\/pre>\n
    Sortowanie odbywa si\u0119 tu dla danych w zakresie A2:C100, pocz\u0105wszy od warto\u015bci w kolumnie B (nazwiska), a p\u00f3\u017aniej w kolumnie A (imiona), obie w kolejno\u015bci rosn\u0105cej.<\/p>\n
    Zadanie 2: Sortowanie produkt\u00f3w wed\u0142ug kategorii i ceny<\/h2>\n
    Je\u015bli chcemy posortowa\u0107 list\u0119 produkt\u00f3w pocz\u0105wszy od kategorii, a nast\u0119pnie ceny, u\u017cyjemy:<\/p>\n
    =SORTUJ.WED\u0141UG(A2:D100, B2:B100, 1, C2:C100, -1)<\/code><\/pre>\n
    Tutaj sortowanie rozpoczyna si\u0119 od kolumny B (kategoria), a potem przechodzi do kolumny C (cena, od najwy\u017cszej do najni\u017cszej). Dane znajduj\u0105 si\u0119 w zakresie A2:D100.<\/p>\n
    Dzi\u0119ki funkcji SORTBY<\/code>, proces sortowania danych staje si\u0119 znacznie prostszy, oferuj\u0105c jednocze\u015bnie szczeg\u00f3\u0142ow\u0105 kontrol\u0119 nad kolejno\u015bci\u0105 element\u00f3w. To czyni j\u0105 niezwykle u\u017cytecznym narz\u0119dziem przy przetwarzaniu tabelarycznych zbior\u00f3w danych w Excelu i Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Sortuje zawarto\u015b\u0107 zakresu lub tablicy na podstawie warto\u015bci z odpowiedniego zakresu lub tablicy<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[425],"tags":[],"class_list":["post-10641","post","type-post","status-publish","format-standard","hentry","category-odnosnikow-i-odwolan"],"acf":[],"yoast_head":"\nFunkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia<\/title>\n<meta name=\"description\" content=\"Opis funkcji SORTBY (SORTUJ.WED\u0141UG,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pl\/sortby\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta property=\"og:description\" content=\"Opis funkcji SORTBY (SORTUJ.WED\u0141UG,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pl\/sortby\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T05:24:43+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/sortby\/\",\"url\":\"https:\/\/functiontranslator.com\/pl\/sortby\/\",\"name\":\"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-26T05:24:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcji SORTBY (SORTUJ.WED\u0141UG,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pl\/sortby\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pl\/sortby\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/sortby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkcje programu Excel\",\"item\":\"https:\/\/functiontranslator.com\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Odno\u015bnik\u00f3w i odwo\u0142a\u0144\",\"item\":\"https:\/\/functiontranslator.com\/pl\/odnosnikow-i-odwolan\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SORTUJ.WED\u0141UG,\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pl\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","description":"Opis funkcji SORTBY (SORTUJ.WED\u0141UG,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/pl\/sortby\/","og_locale":"pl_PL","og_type":"article","og_title":"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","og_description":"Opis funkcji SORTBY (SORTUJ.WED\u0141UG,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","og_url":"https:\/\/functiontranslator.com\/pl\/sortby\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-26T05:24:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","twitter_misc":{"Napisane przez":"glavadmin","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pl\/sortby\/","url":"https:\/\/functiontranslator.com\/pl\/sortby\/","name":"Funkcja SORTBY (SORTUJ.WED\u0141UG,) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-26T05:24:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcji SORTBY (SORTUJ.WED\u0141UG,) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pl\/sortby\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pl\/sortby\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pl\/sortby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkcje programu Excel","item":"https:\/\/functiontranslator.com\/pl\/"},{"@type":"ListItem","position":2,"name":"Odno\u015bnik\u00f3w i odwo\u0142a\u0144","item":"https:\/\/functiontranslator.com\/pl\/odnosnikow-i-odwolan\/"},{"@type":"ListItem","position":3,"name":"SORTUJ.WED\u0141UG,"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pl\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/comments?post=10641"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10641\/revisions"}],"predecessor-version":[{"id":27953,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10641\/revisions\/27953"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/media?parent=10641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/categories?post=10641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/tags?post=10641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}