{"id":3329,"date":"2022-06-30T14:27:14","date_gmt":"2022-06-30T12:27:14","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3329"},"modified":"2022-06-30T14:35:39","modified_gmt":"2022-06-30T12:35:39","slug":"sort-i-sortby-funkcije-u-excel","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/","title":{"rendered":"[:sr]Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u[:en]What is the difference between SORT and SORTBY function in Excel[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">[:sr]Sadr\u017eaj[:en] Contents[:]<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#SORT_i_SORTBY_funkcije_u_Excel-u\" >SORT i SORTBY funkcije u Excel-u<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#SORTBY_funkcija_u_Excel-u\" >SORTBY funkcija u Excel-u<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#SORT_and_SORTBY_functions_in_Excel\" >SORT and SORTBY functions in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#SORTBY_function_in_Excel\" >SORTBY function in Excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n[:sr]Od verzije 2021 dodate su nove SORT i SORTBY funkcije u Excel-u koje sortiraju podatke u tabeli po odabranoj koloni, ili u drugom slu\u010daju sortiranje podataka po definisanom nizu.<\/p>\n<p>U <a href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/\">verzijama<\/a>: <strong>2021, 365, za<span class=\"appliesToItem\">\u00a0Mac<\/span>\u00a0i za\u00a0<span class=\"appliesToItem\">web<\/span><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"SORT_i_SORTBY_funkcije_u_Excel-u\"><\/span>SORT i SORTBY funkcije u Excel-u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kao \u0161to sam naveo u prethodnom \u010dlanku <a href=\"https:\/\/kalkulacija.com\/sort\/\">sortiranje sadr\u017eaja<\/a> opsega i\/ili niza vrednosti videli smo jedan standardizovani pristup sortiranju podataka. Oblast vrednosti u obliku tabele (nije <a href=\"https:\/\/kalkulacija.com\/wordpress\/kreirati-excel-tabele\/\">objekat tabela<\/a>) mo\u017eemo sortirati izborom kolone rastu\u0107im ili opadaju\u0107im redosledom od A-Z ili od Z-A, kao i od najmanjeg do nave\u0107eg broja i obrnuto.<\/p>\n<p>SORT\u00a0funkcija sortira sadr\u017eaj opsega ili niza u rastuc\u0301em ili opadajuc\u0301em redosledu. Vrednosti se mogu sortirati po jednoj ili vi\u0161e kolona. SORT vrac\u0301a <a href=\"https:\/\/theexcelclub.com\/excel-dynamic-arrays-a-new-way-to-model-your-excel-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">dinami\u010dki niz<\/a> rezultata.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"SORTBY_funkcija_u_Excel-u\"><\/span>SORTBY funkcija u Excel-u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nam omogu\u0107ava da sam redosled izaberemo na osnovu drugog opsega ili niza vrednosti. Taj niz npr. mo\u017ee biti redosled dana u nedelji ili meseci u godini i ne mora se pojavljivati u sortiranoj tabeli. Najbolje je pogledati slede\u0107i primer.<\/p>\n<figure id=\"attachment_3336\" aria-describedby=\"caption-attachment-3336\" style=\"width: 504px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3336 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby.png\" alt=\"Upotreba SORTBY funkcije\" width=\"504\" height=\"454\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby.png 504w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby-300x270.png 300w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><figcaption id=\"caption-attachment-3336\" class=\"wp-caption-text\">Upotreba SORTBY funkcije<\/figcaption><\/figure>\n<p>Iz primera mo\u017eemo videti da nije neophodno u sortiranoj tabeli da se vidi redosled po kojem su sortirani revodi u tabeli.[:en]As of version 2021, new SORT and SORTBY functions have been added in Excel that sort the data in the table by the selected column, or otherwise sort the data by a defined sequence.<\/p>\n<p>In\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/\">versions<\/a>\u00a0:\u00a0<strong>2021, 365, for\u00a0<span class=\"appliesToItem\">\u00a0Mac<\/span>\u00a0\u00a0and for\u00a0\u00a0<span class=\"appliesToItem\">the web<\/span><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"SORT_and_SORTBY_functions_in_Excel\"><\/span><span id=\"SORT_i_SORTBY_funkcije_u_Excel-u\" class=\"ez-toc-section\"><\/span>SORT and SORTBY functions in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As I stated in a previous article\u00a0<a href=\"https:\/\/kalkulacija.com\/sort\/\">sorting the contents of<\/a> a range and\/or string of values \u200b\u200bwe have seen a standardized approach to sorting data. The range of values \u200b\u200bin the form of a table (not\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/kreirati-excel-tabele\/\">a table object<\/a>\u00a0) can be sorted by selecting a column in ascending or descending order from AZ or ZA, as well as from the smallest to the largest number and vice versa.<\/p>\n<p>The SORT function sorts the contents of a range or sequence in ascending or descending order.\u00a0Values \u200b\u200bcan be sorted by one or more columns.\u00a0SORT returns\u00a0<a href=\"https:\/\/theexcelclub.com\/excel-dynamic-arrays-a-new-way-to-model-your-excel-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">a dynamic sequence of<\/a>\u00a0results.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"SORTBY_function_in_Excel\"><\/span><span id=\"SORTBY_funkcija_u_Excel-u\" class=\"ez-toc-section\"><\/span>SORTBY function in Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It allows us to choose the order itself based on another range or set of values.\u00a0That series e.g.\u00a0it can be the order of the days of the week or months of the year and does not have to appear in the sorted table.\u00a0It is best to look at the following example.<\/p>\n<figure id=\"attachment_3336\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3336\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3336 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby.png\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby.png 504w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby-300x270.png 300w\" alt=\"Using the SORTBY function\" width=\"504\" height=\"454\" \/><figcaption id=\"caption-attachment-3336\" class=\"wp-caption-text\">Using the SORTBY function<\/figcaption><\/figure>\n<p>From the example we can see that it is not necessary to see in the sorted table the order in which the translations are sorted in the table.[:]\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;3329&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u[:en]What is the difference between SORT and SORTBY function in Excel[:]&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (3 votes)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Od verzije 2021 dodate su nove SORT i SORTBY funkcije u Excel-u koje sortiraju podatke u tabeli po odabranoj koloni,<\/p>\n","protected":false},"author":1,"featured_media":3338,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,42],"tags":[],"class_list":["post-3329","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","category-napredni-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u<\/title>\n<meta name=\"description\" content=\"SORT i SORTBY funkcije u Excel-u sortira podatke u tabeli po odabranoj koloni, kao i sortiranje podataka po definisanom nizu, respektivno.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u\" \/>\n<meta property=\"og:description\" content=\"SORT i SORTBY funkcije u Excel-u sortira podatke u tabeli po odabranoj koloni, kao i sortiranje podataka po definisanom nizu, respektivno.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-30T12:27:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-30T12:35:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby00.png\" \/>\n\t<meta property=\"og:image:width\" content=\"805\" \/>\n\t<meta property=\"og:image:height\" content=\"226\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u[:en]What is the difference between SORT and SORTBY function in Excel[:]\",\"datePublished\":\"2022-06-30T12:27:14+00:00\",\"dateModified\":\"2022-06-30T12:35:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/\"},\"wordCount\":474,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/sortby00.png\",\"articleSection\":[\"Microsoft\u00ae Excel\",\"Napredni Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/\",\"name\":\"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/sortby00.png\",\"datePublished\":\"2022-06-30T12:27:14+00:00\",\"dateModified\":\"2022-06-30T12:35:39+00:00\",\"description\":\"SORT i SORTBY funkcije u Excel-u sortira podatke u tabeli po odabranoj koloni, kao i sortiranje podataka po definisanom nizu, respektivno.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/sortby00.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/sortby00.png\",\"width\":805,\"height\":226,\"caption\":\"KOJA JE RAZLIKA IZME\u0110U SORT I SORTBY FUNKCIJE U EXCEL-U\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/sort-i-sortby-funkcije-u-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u","description":"SORT i SORTBY funkcije u Excel-u sortira podatke u tabeli po odabranoj koloni, kao i sortiranje podataka po definisanom nizu, respektivno.","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:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/","og_locale":"en_US","og_type":"article","og_title":"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u","og_description":"SORT i SORTBY funkcije u Excel-u sortira podatke u tabeli po odabranoj koloni, kao i sortiranje podataka po definisanom nizu, respektivno.","og_url":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-06-30T12:27:14+00:00","article_modified_time":"2022-06-30T12:35:39+00:00","og_image":[{"width":805,"height":226,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby00.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u[:en]What is the difference between SORT and SORTBY function in Excel[:]","datePublished":"2022-06-30T12:27:14+00:00","dateModified":"2022-06-30T12:35:39+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/"},"wordCount":474,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby00.png","articleSection":["Microsoft\u00ae Excel","Napredni Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/","url":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/","name":"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby00.png","datePublished":"2022-06-30T12:27:14+00:00","dateModified":"2022-06-30T12:35:39+00:00","description":"SORT i SORTBY funkcije u Excel-u sortira podatke u tabeli po odabranoj koloni, kao i sortiranje podataka po definisanom nizu, respektivno.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby00.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/06\/sortby00.png","width":805,"height":226,"caption":"KOJA JE RAZLIKA IZME\u0110U SORT I SORTBY FUNKCIJE U EXCEL-U"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/sort-i-sortby-funkcije-u-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Koja je razlika izme\u0111u SORT i SORTBY funkcije u Excel-u"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=3329"}],"version-history":[{"count":8,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3329\/revisions"}],"predecessor-version":[{"id":3339,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3329\/revisions\/3339"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/3338"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}