{"id":979,"date":"2017-10-16T11:11:24","date_gmt":"2017-10-16T09:11:24","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=979"},"modified":"2017-10-16T11:11:24","modified_gmt":"2017-10-16T09:11:24","slug":"napredni-filter-izdvajanje-unikata","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/","title":{"rendered":"[:sr]Napredni filter &#8211; izdvajanje unikata[:en]Advanced Filter[:]"},"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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#Napredni_filter_%E2%80%93_izdvajanje_unikata\" >Napredni filter &#8211; izdvajanje unikata<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#Advanced_Filter_%E2%80%93_Uniqueness_Separation\" >Advanced Filter &#8211; Uniqueness Separation<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Napredni filter omogu\u0107ava izdvajanje (prikazivanje) samo onih podataka koji ispunjavaju neki kriterijum. Filter i Napredni filter su osnovne funkcije koje omogu\u0107avaju filtriranje. Ovde \u0107emo se baviti naprednim filtriranjem i to samo jednom specifi\u010dnom situacijom, kada \u017eelimo izdvojiti jedinstvene i unikatne vrednosti.<\/p>\n<p>Naravno, da u ekselu je mogu\u0107e posao zavr\u0161iti na vi\u0161e na\u010dina i ovo je verovatno najjednostavniji.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Napredni_filter_%E2%80%93_izdvajanje_unikata\"><\/span>Napredni filter &#8211; izdvajanje unikata<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Upotrebi\u0107emo listu sa imenima koja se ponavljaju.\u00a0 Na prvoj slici mo\u017eemo videti razliku izme\u0111u jedinstvenih razli\u010ditih vrednosti i unikatnih vrednosti. Jedinstvene razli\u010dite vrednosti se mogu vi\u0161e puta pojavljivati u tabeli, i \u010desto su nam potrebne. Tu excel ima ograni\u010denja kod standardne opcije filtriranja da mo\u017ee prikazati samo 5000 jedinstvenih vrednosti.<\/p>\n<figure id=\"attachment_982\" aria-describedby=\"caption-attachment-982\" style=\"width: 626px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-982 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png\" alt=\"Napredni filter - izdvajanje unikata\" width=\"626\" height=\"443\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png 626w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1-350x248.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1-300x212.png 300w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><figcaption id=\"caption-attachment-982\" class=\"wp-caption-text\">Napredni filter &#8211; izdvajanje unikata<\/figcaption><\/figure>\n<p>Da bi izdvojili sve jedinstvene razli\u010dite vrednosti upotrebi\u0107emo napredni filter &#8211; <strong>Advanced filter<\/strong> koji se nalazi na traci sa alatima <strong>Data<\/strong>.<\/p>\n<ol>\n<li>Prvo selektujte kolonu u kojoj se nalaze podaci koje \u017eelite obraditi.<\/li>\n<li>Pokrenite napredni filter (<strong>Data\/Advanced<\/strong> u delu alata\u00a0<strong>Sort&amp;filter<\/strong>)<\/li>\n<li>Izaberite opciju za kopiranje (<strong>Copy to another location<\/strong>)<\/li>\n<li>Izaberite lokaciju gde \u017eelite da kopirate vrednosti (<strong>Copy to:<\/strong>)<\/li>\n<li>\u0160tiklirajte opciju <strong>Unique records only<\/strong> i poslednje je<strong> OK<\/strong>.<\/li>\n<\/ol>\n<figure id=\"attachment_983\" aria-describedby=\"caption-attachment-983\" style=\"width: 554px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-983 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2.png\" alt=\"Napredni filter - izdvajanje unikata\" width=\"554\" height=\"420\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2.png 554w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2-350x265.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2-300x227.png 300w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><figcaption id=\"caption-attachment-983\" class=\"wp-caption-text\">Napredni filter &#8211; izdvajanje unikata<\/figcaption><\/figure>\n<p>Kada ste to zavr\u0161ili dobi\u0107ete rezultat kao na prethodnoj slici u koloni Razli\u010dite vrednosti.<\/p>\n<p>Sada je ostalo da upotrebom formule COUNTIF prebrojite jedinstvene razli\u010dite vrednosti u po\u010detnoj tabeli i da ih filtrirate opcijom filter.<\/p>\n<p>U konkretnom slu\u010daju formula u koloni broj pojavljivanja izgleda ovako:<\/p>\n<p style=\"text-align: center;\"><strong>=COUNTIF(F5:F9,G5)<\/strong><\/p>\n<p>Prvi podatak u funciji su sva ona polja koja \u0107emo prebrojavati, a drugi parametar je uslov ko \u0107e u\u0107i u kona\u010dan zbir. Kada je uslov jednakost sa sadr\u017eajem u \u0107eliji tada je dovoljno navesti samo o kojoj se \u0107eliji radi. U ovom slu\u010daju je sadr\u017eaj u \u0107eliji G5.[:en]Advanced filter allows you to extract (display) only those data that meet some criteria. Filter and Advanced filter are basic functions that allow filtering. Here we will deal with advanced filtering, and only by a specific situation, when we want to single out unique and unique values.<\/p>\n<p>Of course, in a Excel, it&#8217;s possible to end the job in many ways and this is probably the simplest.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_%E2%80%93_Uniqueness_Separation\"><\/span>Advanced Filter &#8211; Uniqueness Separation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We&#8217;ll use a list of repetitive names. In the first picture we can see the difference between unique different values and unique values. Unique different values can appear several times in the table, and we often need them. Excel has limitations in standard filtering options that can only display 5000 unique values.<\/p>\n<figure id=\"attachment_982\" aria-describedby=\"caption-attachment-982\" style=\"width: 626px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-982 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png\" alt=\"Napredni filter - izdvajanje unikata\" width=\"626\" height=\"443\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png 626w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1-350x248.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1-300x212.png 300w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><figcaption id=\"caption-attachment-982\" class=\"wp-caption-text\">Napredni filter &#8211; izdvajanje unikata<\/figcaption><\/figure>\n<p>To extract all unique different values, we will use an advanced filter &#8211; the <strong>Advanced filter<\/strong> located on the <strong>Data toolbar<\/strong>.<\/p>\n<ol>\n<li>First, select the column that contains the information you want to process.<\/li>\n<li>Start an advanced filter (<strong>Data<\/strong> \/<strong> Advanced<\/strong> in the <strong>Sort &amp; Filter<\/strong> toolpart)<\/li>\n<li>Select the copy option (<strong>Copy to another location<\/strong>)<\/li>\n<li>Select the location where you want to copy the values (<strong>Copy to :<\/strong>)<\/li>\n<li>Select the <strong>Unique records only<\/strong> option and the last one is <strong>OK<\/strong>.<\/li>\n<\/ol>\n<figure id=\"attachment_983\" aria-describedby=\"caption-attachment-983\" style=\"width: 554px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-983 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2.png\" alt=\"Napredni filter - izdvajanje unikata\" width=\"554\" height=\"420\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2.png 554w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2-350x265.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati2-300x227.png 300w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><figcaption id=\"caption-attachment-983\" class=\"wp-caption-text\">Napredni filter &#8211; izdvajanje unikata<\/figcaption><\/figure>\n<p>When finished, you will get the result as in the previous figure in the Various values column.<\/p>\n<p>Now it is left to use the formula COUNTIF to count the unique different values in the initial table and filter them with the filter option.<\/p>\n<p>In the concrete case, the formula in the column shows the number of impressions:<\/p>\n<p><strong>=COUNTIF(F5:F9,G5)<\/strong><\/p>\n<p>The first data in the function are all those fields that we will count, and the second parameter is the condition that will enter the final sum. When the condition is equal to the content in the cell then it is sufficient to state only which cell is involved. In this case, the content is in the G5 cell.[:]\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;979&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;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&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;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:]&quot;,&quot;width&quot;:&quot;0&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: 0px;\">\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            <span class=\"kksr-muted\">[:sr] Ocenite [:en]Rate this [:]post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Napredni filter omogu\u0107ava izdvajanje (prikazivanje) samo onih podataka koji ispunjavaju neki kriterijum. Filter i Napredni filter su osnovne funkcije koje<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,19,49,50],"tags":[],"class_list":["post-979","post","type-post","status-publish","format-standard","hentry","category-napredni-excel","category-ekscel","category-saveti-napredni-excel","category-saveti-poslovni-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:] - Kalkulacija u osnovi svega!<\/title>\n<meta name=\"description\" content=\"Napredni filter podataka je postupak izdvajanja (prikazivanja) samo onih podataka koji ispunjavaju neki kriterijum. Filter i napredni filter su osnovne\" \/>\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\/napredni-filter-izdvajanje-unikata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:] - Kalkulacija u osnovi svega!\" \/>\n<meta property=\"og:description\" content=\"Napredni filter podataka je postupak izdvajanja (prikazivanja) samo onih podataka koji ispunjavaju neki kriterijum. Filter i napredni filter su osnovne\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-16T09:11:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Napredni filter &#8211; izdvajanje unikata[:en]Advanced Filter[:]\",\"datePublished\":\"2017-10-16T09:11:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/\"},\"wordCount\":685,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/inukati1.png\",\"articleSection\":[\"Napredni Excel\",\"Poslovni Excel\",\"Saveti za napredni excel\",\"Saveti za poslovni excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/\",\"name\":\"[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:] - Kalkulacija u osnovi svega!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/inukati1.png\",\"datePublished\":\"2017-10-16T09:11:24+00:00\",\"description\":\"Napredni filter podataka je postupak izdvajanja (prikazivanja) samo onih podataka koji ispunjavaju neki kriterijum. Filter i napredni filter su osnovne\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#primaryimage\",\"url\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/inukati1.png\",\"contentUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/inukati1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/napredni-filter-izdvajanje-unikata\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Napredni filter &#8211; izdvajanje unikata\"}]},{\"@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":"[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:] - Kalkulacija u osnovi svega!","description":"Napredni filter podataka je postupak izdvajanja (prikazivanja) samo onih podataka koji ispunjavaju neki kriterijum. Filter i napredni filter su osnovne","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\/napredni-filter-izdvajanje-unikata\/","og_locale":"en_US","og_type":"article","og_title":"[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:] - Kalkulacija u osnovi svega!","og_description":"Napredni filter podataka je postupak izdvajanja (prikazivanja) samo onih podataka koji ispunjavaju neki kriterijum. Filter i napredni filter su osnovne","og_url":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2017-10-16T09:11:24+00:00","og_image":[{"url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Napredni filter &#8211; izdvajanje unikata[:en]Advanced Filter[:]","datePublished":"2017-10-16T09:11:24+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/"},"wordCount":685,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png","articleSection":["Napredni Excel","Poslovni Excel","Saveti za napredni excel","Saveti za poslovni excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/","url":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/","name":"[:sr]Napredni filter - izdvajanje unikata[:en]Advanced Filter[:] - Kalkulacija u osnovi svega!","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png","datePublished":"2017-10-16T09:11:24+00:00","description":"Napredni filter podataka je postupak izdvajanja (prikazivanja) samo onih podataka koji ispunjavaju neki kriterijum. Filter i napredni filter su osnovne","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#primaryimage","url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png","contentUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/10\/inukati1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/napredni-filter-izdvajanje-unikata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Napredni filter &#8211; izdvajanje unikata"}]},{"@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\/979","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=979"}],"version-history":[{"count":16,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/979\/revisions"}],"predecessor-version":[{"id":997,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/979\/revisions\/997"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}