{"id":4749,"date":"2025-02-11T14:06:21","date_gmt":"2025-02-11T13:06:21","guid":{"rendered":"https:\/\/intelstudios.com\/?p=4749"},"modified":"2025-05-09T08:37:25","modified_gmt":"2025-05-09T07:37:25","slug":"excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech","status":"publish","type":"post","link":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/","title":{"rendered":"Excel funkce &#8211; Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1372.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-blend:overlay;--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-video fusion-youtube\" style=\"--awb-max-width:600px;--awb-max-height:360px;--awb-align-self:center;--awb-width:100%;--awb-margin-bottom:40px;\"><div class=\"video-shortcode\"><lite-youtube videoid=\"p123vi5BBUk\" class=\"landscape\" params=\"wmode=transparent&autoplay=1&amp;enablejsapi=1\" title=\"YouTube video player 1\" data-button-label=\"Play Video\" width=\"600\" height=\"360\" data-thumbnail-size=\"auto\" data-no-cookie=\"on\"><\/lite-youtube><\/div><\/div><div class=\"fusion-text fusion-text-1\"><h3 class=\"p1\"><b>Excelovsk\u00e9 funkce v monday.com: P\u0159ehled kl\u00ed\u010dov\u00fdch mo\u017enost\u00ed<\/b><b><\/b><\/h3>\n<p class=\"p3\">Michal Jurn\u00edk z Intelligent Studios ve sv\u00e9m nejnov\u011bj\u0161\u00edm videu p\u0159edstavuje vyu\u017eit\u00ed Excelovsk\u00fdch funkc\u00ed v platform\u011b monday.com. Vysv\u011btluje, jak lze efektivn\u011b pracovat s textov\u00fdmi a \u010d\u00edseln\u00fdmi hodnotami, vyhled\u00e1vat shody mezi polo\u017ekami nebo odstra\u0148ovat duplicity. V\u0161echny uk\u00e1zky jsou demonstrov\u00e1ny v r\u00e1mci sloupce \u201eFormula\u201c, kter\u00fd umo\u017e\u0148uje prov\u00e1d\u011bt r\u016fzn\u00e9 v\u00fdpo\u010dty a manipulace s daty.<\/p>\n<h4 class=\"p4\"><b>Spojov\u00e1n\u00ed textov\u00fdch \u0159et\u011bzc\u016f pomoc\u00ed CONCATENATE<\/b><b><\/b><\/h4>\n<p class=\"p3\">Prvn\u00ed uk\u00e1zan\u00e1 funkce je <span class=\"s1\"><b>CONCATENATE<\/b><\/span> (nebo jej\u00ed zkr\u00e1cen\u00e1 verze <span class=\"s1\"><b>CONCAT<\/b><\/span>), kter\u00e1 umo\u017e\u0148uje spojov\u00e1n\u00ed v\u00edce textov\u00fdch \u0159et\u011bzc\u016f do jednoho. Michal ukazuje, jak lze kombinovat n\u00e1zvy polo\u017eek s dal\u0161\u00edmi textov\u00fdmi sloupci a vytv\u00e1\u0159et tak srozumiteln\u00e9 v\u00fdsledky.<\/p>\n<h4 class=\"p4\"><b>Sou\u010det \u010d\u00edseln\u00fdch hodnot<\/b><b><\/b><\/h4>\n<p class=\"p3\">Dal\u0161\u00ed funkc\u00ed je <span class=\"s1\"><b>SUM<\/b><\/span>, kter\u00e1 se vyu\u017e\u00edv\u00e1 pro s\u010d\u00edt\u00e1n\u00ed \u010d\u00edseln\u00fdch hodnot. Michal demonstruje dva p\u0159\u00edstupy:<\/p>\n<p class=\"p5\">\u2022Pou\u017eit\u00ed jednoduch\u00e9ho sou\u010dtu pomoc\u00ed oper\u00e1toru \u201e+\u201c.<\/p>\n<p class=\"p5\">\u2022Vyu\u017eit\u00ed funkce <span class=\"s1\"><b>SUM<\/b><\/span>, kter\u00e1 p\u0159ij\u00edm\u00e1 jako parametry n\u00e1zvy jednotliv\u00fdch \u010d\u00edseln\u00fdch sloupc\u016f.<\/p>\n<h4 class=\"p4\"><b>Porovn\u00e1n\u00ed textov\u00fdch hodnot pomoc\u00ed MATCH<\/b><b><\/b><\/h4>\n<p class=\"p3\">Funkce <span class=\"s1\"><b>MATCH<\/b><\/span> umo\u017e\u0148uje porovn\u00e1vat textov\u00e9 hodnoty a zjistit, zda jsou shodn\u00e9. Michal zde vyu\u017e\u00edv\u00e1 kombinaci funkc\u00ed:<\/p>\n<p class=\"p5\">\u2022<span class=\"s1\"><b>EXACT<\/b><\/span>, kter\u00e1 vrac\u00ed <span class=\"s1\"><b>TRUE<\/b><\/span> nebo <span class=\"s1\"><b>FALSE<\/b><\/span> na z\u00e1klad\u011b p\u0159esn\u00e9ho porovn\u00e1n\u00ed dvou text\u016f.<\/p>\n<p class=\"p5\">\u2022<span class=\"s1\"><b>IF<\/b><\/span>, kter\u00e1 na z\u00e1klad\u011b v\u00fdsledku funkce EXACT vrac\u00ed \u201eMATCH\u201c, pokud jsou texty stejn\u00e9, nebo \u201eNO MATCH\u201c, pokud se li\u0161\u00ed.<\/p>\n<h4 class=\"p4\"><b>V\u00fdpo\u010det rozd\u00edlu mezi daty a hodinami<\/b><b><\/b><\/h4>\n<p class=\"p3\">V dal\u0161\u00ed \u010d\u00e1sti videa Michal ukazuje, jak lze po\u010d\u00edtat rozd\u00edl mezi dv\u011bma daty nebo \u010dasy. K tomu vyu\u017e\u00edv\u00e1 funkci:<\/p>\n<p class=\"p5\">\u2022<span class=\"s1\"><b>DAYS<\/b><\/span> pro v\u00fdpo\u010det rozd\u00edlu mezi dv\u011bma daty.<\/p>\n<p class=\"p5\">\u2022<span class=\"s1\"><b>HOURS<\/b><\/span> pro v\u00fdpo\u010det rozd\u00edlu mezi dv\u011bma \u010dasov\u00fdmi hodnotami.<\/p>\n<h4 class=\"p4\"><b>Odstran\u011bn\u00ed duplicitn\u00edch polo\u017eek<\/b><b><\/b><\/h4>\n<p class=\"p3\">Jednou z u\u017eite\u010dn\u00fdch funkc\u00ed v <span class=\"s1\"><b>monday.com<\/b><\/span> je tak\u00e9 <span class=\"s1\"><b>Remove Duplicity<\/b><\/span>, kter\u00e1 umo\u017e\u0148uje identifikovat a p\u0159\u00edpadn\u011b odstranit duplicitn\u00ed polo\u017eky. Tento proces je zalo\u017een na sloupci <span class=\"s1\"><b>Connected Columns<\/b><\/span>, kter\u00fd automaticky vyhled\u00e1v\u00e1 odpov\u00eddaj\u00edc\u00ed polo\u017eky na z\u00e1klad\u011b textov\u00e9 hodnoty.<\/p>\n<p class=\"p3\">Pro detekci duplicit je pou\u017eita <span class=\"s1\"><b>automatizace<\/b><\/span>, kter\u00e1 propoj\u00ed polo\u017eky se stejnou hodnotou ve sloupci \u201eText1\u201c. Pokud je nalezena shoda, syst\u00e9m tuto polo\u017eku zv\u00fdrazn\u00ed. Dal\u0161\u00ed automatizace pak umo\u017e\u0148uje automatick\u00e9 odstran\u011bn\u00ed polo\u017eky, pokud je detekov\u00e1na jako duplicitn\u00ed.<\/p>\n<h4 class=\"p1\"><b>Z\u00e1v\u011br<\/b><b><\/b><\/h4>\n<p class=\"p3\">Michal ve videu n\u00e1zorn\u011b demonstruje, jak lze vyu\u017e\u00edt pokro\u010dil\u00e9 funkce pro pr\u00e1ci s daty v <span class=\"s1\"><b>monday.com<\/b><\/span>, co\u017e umo\u017e\u0148uje efektivn\u011bj\u0161\u00ed spr\u00e1vu informac\u00ed v r\u00e1mci projekt\u016f. Pokud v\u00e1s tato t\u00e9matika zaj\u00edm\u00e1, doporu\u010duje se sledovat dal\u0161\u00ed videa na kan\u00e1lu <span class=\"s1\"><b>Intelligent Studios<\/b><\/span>, kde se pravideln\u011b objevuj\u00ed n\u00e1vody na zefektivn\u011bn\u00ed pr\u00e1ce s <span class=\"s1\"><b>monday.com<\/b><\/span>.<\/p>\n<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":7,"featured_media":4750,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[75,80,31],"tags":[],"class_list":["post-4749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-monday-com-navody","category-monday-com-navody-cs","category-uncategorized-cs"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel funkce - Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu - Intelligent Studios s.r.o.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel funkce - Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu - Intelligent Studios s.r.o.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\" \/>\n<meta property=\"og:site_name\" content=\"Intelligent Studios s.r.o.\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-11T13:06:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-09T07:37:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Michal Jurn\u00edk\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michal Jurn\u00edk\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\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\":\"Article\",\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\"},\"author\":{\"name\":\"Michal Jurn\u00edk\",\"@id\":\"https:\/\/intelstudios.com\/cs\/#\/schema\/person\/364f332196292755055f62699ecfe947\"},\"headline\":\"Excel funkce &#8211; Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu\",\"datePublished\":\"2025-02-11T13:06:21+00:00\",\"dateModified\":\"2025-05-09T07:37:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\"},\"wordCount\":647,\"publisher\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/#organization\"},\"image\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png\",\"articleSection\":[\"Monday.com n\u00e1vody\",\"Monday.com n\u00e1vody\",\"Uncategorized @cs\"],\"inLanguage\":\"cs\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\",\"url\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\",\"name\":\"Excel funkce - Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu - Intelligent Studios s.r.o.\",\"isPartOf\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png\",\"datePublished\":\"2025-02-11T13:06:21+00:00\",\"dateModified\":\"2025-05-09T07:37:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage\",\"url\":\"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png\",\"contentUrl\":\"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/intelstudios.com\/cs\/uvod\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel funkce &#8211; Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/intelstudios.com\/cs\/#website\",\"url\":\"https:\/\/intelstudios.com\/cs\/\",\"name\":\"Intelligent Studios s.r.o.\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/intelstudios.com\/cs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/intelstudios.com\/cs\/#organization\",\"name\":\"Intelligent Studios s.r.o.\",\"url\":\"https:\/\/intelstudios.com\/cs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/intelstudios.com\/cs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/intelstudios.com\/wp-content\/uploads\/2022\/09\/logo-full.png\",\"contentUrl\":\"https:\/\/intelstudios.com\/wp-content\/uploads\/2022\/09\/logo-full.png\",\"width\":673,\"height\":233,\"caption\":\"Intelligent Studios s.r.o.\"},\"image\":{\"@id\":\"https:\/\/intelstudios.com\/cs\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/intelstudios.com\/cs\/#\/schema\/person\/364f332196292755055f62699ecfe947\",\"name\":\"Michal Jurn\u00edk\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/intelstudios.com\/cs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/85772fa9a7913b62019c51e42dd726ed4531369ebc1e211d434f68f49c215b62?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/85772fa9a7913b62019c51e42dd726ed4531369ebc1e211d434f68f49c215b62?s=96&d=mm&r=g\",\"caption\":\"Michal Jurn\u00edk\"},\"url\":\"https:\/\/intelstudios.com\/cs\/author\/michal-jurnik\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel funkce - Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu - Intelligent Studios s.r.o.","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:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/","og_locale":"cs_CZ","og_type":"article","og_title":"Excel funkce - Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu - Intelligent Studios s.r.o.","og_url":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/","og_site_name":"Intelligent Studios s.r.o.","article_published_time":"2025-02-11T13:06:21+00:00","article_modified_time":"2025-05-09T07:37:25+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png","type":"image\/png"}],"author":"Michal Jurn\u00edk","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Michal Jurn\u00edk","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#article","isPartOf":{"@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/"},"author":{"name":"Michal Jurn\u00edk","@id":"https:\/\/intelstudios.com\/cs\/#\/schema\/person\/364f332196292755055f62699ecfe947"},"headline":"Excel funkce &#8211; Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu","datePublished":"2025-02-11T13:06:21+00:00","dateModified":"2025-05-09T07:37:25+00:00","mainEntityOfPage":{"@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/"},"wordCount":647,"publisher":{"@id":"https:\/\/intelstudios.com\/cs\/#organization"},"image":{"@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage"},"thumbnailUrl":"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png","articleSection":["Monday.com n\u00e1vody","Monday.com n\u00e1vody","Uncategorized @cs"],"inLanguage":"cs"},{"@type":"WebPage","@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/","url":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/","name":"Excel funkce - Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu - Intelligent Studios s.r.o.","isPartOf":{"@id":"https:\/\/intelstudios.com\/cs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage"},"image":{"@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage"},"thumbnailUrl":"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png","datePublished":"2025-02-11T13:06:21+00:00","dateModified":"2025-05-09T07:37:25+00:00","breadcrumb":{"@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#primaryimage","url":"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png","contentUrl":"https:\/\/intelstudios.com\/wp-content\/uploads\/2025\/02\/Slide-16_9-1-11.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/intelstudios.com\/cs\/excel-funkce-odstraneni-duplicit-spojeni-retezcu-suma-match-rozdil-v-datumech\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/intelstudios.com\/cs\/uvod\/"},{"@type":"ListItem","position":2,"name":"Excel funkce &#8211; Odstran\u011bn\u00ed duplicit, concat, suma, match, rozd\u00edl v datumu"}]},{"@type":"WebSite","@id":"https:\/\/intelstudios.com\/cs\/#website","url":"https:\/\/intelstudios.com\/cs\/","name":"Intelligent Studios s.r.o.","description":"","publisher":{"@id":"https:\/\/intelstudios.com\/cs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/intelstudios.com\/cs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/intelstudios.com\/cs\/#organization","name":"Intelligent Studios s.r.o.","url":"https:\/\/intelstudios.com\/cs\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/intelstudios.com\/cs\/#\/schema\/logo\/image\/","url":"https:\/\/intelstudios.com\/wp-content\/uploads\/2022\/09\/logo-full.png","contentUrl":"https:\/\/intelstudios.com\/wp-content\/uploads\/2022\/09\/logo-full.png","width":673,"height":233,"caption":"Intelligent Studios s.r.o."},"image":{"@id":"https:\/\/intelstudios.com\/cs\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/intelstudios.com\/cs\/#\/schema\/person\/364f332196292755055f62699ecfe947","name":"Michal Jurn\u00edk","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/intelstudios.com\/cs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/85772fa9a7913b62019c51e42dd726ed4531369ebc1e211d434f68f49c215b62?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/85772fa9a7913b62019c51e42dd726ed4531369ebc1e211d434f68f49c215b62?s=96&d=mm&r=g","caption":"Michal Jurn\u00edk"},"url":"https:\/\/intelstudios.com\/cs\/author\/michal-jurnik\/"}]}},"_links":{"self":[{"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/posts\/4749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/comments?post=4749"}],"version-history":[{"count":3,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/posts\/4749\/revisions"}],"predecessor-version":[{"id":5209,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/posts\/4749\/revisions\/5209"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/media\/4750"}],"wp:attachment":[{"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/media?parent=4749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/categories?post=4749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/intelstudios.com\/cs\/wp-json\/wp\/v2\/tags?post=4749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}