{"id":877,"date":"2020-05-28T15:30:42","date_gmt":"2020-05-28T13:30:42","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=877"},"modified":"2024-11-06T00:09:55","modified_gmt":"2024-11-05T22:09:55","slug":"formule-za-rad-sa-tekstom","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=877","title":{"rendered":"Formule za rad sa tekstom"},"content":{"rendered":"<p><strong>Broj \u0107elija s tekstom<\/strong><\/p>\n<p>Da biste dobili broj \u0107elija s tekstom u podru\u010dju, morate upotrebiti matri\u010dnu formulu. Evo primera matri\u010dne formule kojom \u0107ete dobiti broj \u0107elija s tekstom u podru\u010dju Podaci:<\/p>\n<p>{=SUM(IF(ISTEXT(Podaci);1))}<\/p>\n<p><strong>Broj \u0107elija koje ne sadr\u017ee tekst<\/strong><\/p>\n<p>Naredna matri\u010dna formula koristi funkciju ISNONTEXT koja daje TRUE ako je njen argument bilo koja \u0107elija koja ne sadr\u017ei tekst (uklju\u010duju\u0107i i praznu \u0107eliju). Rezultat je broj \u0107elija koje ne sadr\u017ee tekst:<\/p>\n<p>{=SUM(IF(ISNONTEXT(Podaci);1))}<\/p>\n<p><strong>Unos koji se naj\u010de\u0161\u0107e ponavlja<\/strong><\/p>\n<p>Funkcija MODE daje vrednost koja se naj\u010de\u0161\u0107e ponavlja u podru\u010dju. Na slici prikazan je radni list koji sadr\u017ei vrednosti u podru\u010dju B9:C20. Naredna formula daje rezultat 10 jer se ta vrednost naj\u010de\u0161\u0107e ponavlja u podru\u010dju B9:C20:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-879 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/formulezatekst311.jpg\" alt=\"formulezatekst311\" width=\"929\" height=\"606\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/formulezatekst311.jpg 929w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/formulezatekst311-300x196.jpg 300w\" sizes=\"auto, (max-width: 929px) 100vw, 929px\" \/><\/p>\n<p>=MODE(B9:C20)<\/p>\n<p>Da biste saznali koliko se puta naj\u010de\u0161\u0107a vrednost ponavlja u podru\u010dju (drugim recima, kolika je u\u010destalost), poslu\u017eite se slede\u0107om formulom:<\/p>\n<p>=COUNTIF(B9:C20,MODE(B9:C20))<\/p>\n<p>Ova formula daje 5 kao rezultat jer se vrednost 10 ponavlja pet puta u podru\u010dju B9:C20.<\/p>\n<p>Funkcija MODE se primenjuje samo na numeri\u010dke vrednosti, dok \u0107elije s tekstom ignori\u0161e. Da biste dobili broj ponavljanja naj\u010de\u0161\u0107eg tekstualnog unosa, morate da koristite matri\u010dnu formulu.<\/p>\n<p><video controls=\"controls\" width=\"600\" height=\"400\"><source src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/31.-Formule-za-rad-sa-tekstom.mp4\" type=\"video\/mp4\" \/><\/video><\/p>\n<p><strong>Broj ponavljanja odre\u0111enog teksta<\/strong><\/p>\n<p>Primeri u ovom odeljku prikazuju razne na\u010dine da se prebroji koliko puta se ponavlja znak ili tekstualni niz u podru\u010dju \u0107elija. Na slici prikazan je radni list s tim primerima. Podru\u010dje\u00a0 B9:C20 sadr\u017ei razli\u010dite tekstualne nizove; \u0107elija K15 prikazuje koliko se puta pominje re\u010d januar u datom podru\u010dju.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-880 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/formulezatekst312.jpg\" alt=\"formulezatekst312\" width=\"928\" height=\"484\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/formulezatekst312.jpg 928w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/formulezatekst312-300x156.jpg 300w\" sizes=\"auto, (max-width: 928px) 100vw, 928px\" \/><\/p>\n<p>Da biste dobili broj \u0107elija koje imaju isti sadr\u017eaj kao \u0107elijaK15, koristite funkciju COUNTIF, kao u slede\u0107oj formuli:<\/p>\n<p>=COUNTIF(B9:C20,&#8221;januar&#8221;)<\/p>\n<p>U primeru, \u0107elija K15 sadr\u017ei broj 4, pa formula daje vrednost 4 jer se re\u010d januar u datom podru\u010dju pominje 4 puta.<\/p>\n<p><strong><a href=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/03\/31.-Formule-za-rad-sa-tekstom.xlsx\">Ve\u017eba<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"Broj \u0107elija s tekstom Da biste dobili broj \u0107elija s tekstom u<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=877\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":396,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-877","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=877"}],"version-history":[{"count":2,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/877\/revisions"}],"predecessor-version":[{"id":1512,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/877\/revisions\/1512"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/396"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}