{"id":2929,"date":"2020-04-09T11:09:06","date_gmt":"2020-04-09T09:09:06","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2929"},"modified":"2021-10-30T10:54:48","modified_gmt":"2021-10-30T08:54:48","slug":"darab-es-a-darab2-fuggveny-193","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2929","title":{"rendered":"A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny (#193)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2929\" class=\"elementor elementor-2929\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2f1b186 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f1b186\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31da85e\" data-id=\"31da85e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-099718a elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"099718a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0 Friss\u00edtve: 2020 m\u00e1jus 10.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fd755f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd755f4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9a51d69\" data-id=\"9a51d69\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a4c96cc elementor-widget elementor-widget-text-editor\" data-id=\"a4c96cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Mir\u0151l sz\u00f3l ez a cikk?<br \/>A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny szint\u00e9n gyakori l\u00e1togat\u00f3ja az Excel t\u00e1bl\u00e1zatoknak. Minden olyan feladatban hasznosak, amelyben meg kell sz\u00e1molni bizonyos adatt\u00edpus\u00fa \u00e9rt\u00e9keket, egy\u00e1ltal\u00e1n az \u00e9rt\u00e9kek megl\u00e9t\u00e9t. Ebben a cikkben ezt a k\u00e9t, m\u00e9g mindig egyszer\u0171 Excel f\u00fcggv\u00e9nyt mutatjuk be.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-712e491 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"712e491\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-69f8c96\" data-id=\"69f8c96\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-65e4137 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"65e4137\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;fas fa-file-excel&quot;,&quot;library&quot;:&quot;fa-solid&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;no_headings_message&quot;:&quot;Ezen az oldalon nem tal\\u00e1lhat\\u00f3 c\\u00edmsor.&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTartalomjegyz\u00e9k\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__65e4137\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__65e4137\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__65e4137\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-456de44 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"456de44\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-be800d0\" data-id=\"be800d0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8a05172 elementor-widget elementor-widget-text-editor\" data-id=\"8a05172\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A cikkben eml\u00edtett egy\u00e9b Excel f\u00fcggv\u00e9nyek a k\u00f6vetkez\u0151k: <\/strong>D\u00c1TUM\u00c9RT\u00c9K, HAMIS, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">HI\u00c1NYZIK<\/a>, ID\u0150\u00c9RT\u00c9K, IGAZ, SZ\u00d6VEG.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9bb91a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9bb91a3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d221ae8\" data-id=\"d221ae8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-47fb05d elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"47fb05d\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. A DARAB \\u00e9s a DARAB2 f\\u00fcggv\\u00e9ny bemutat\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">1. A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny bemutat\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f1c610a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f1c610a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f5917f6\" data-id=\"f5917f6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6bfd4f elementor-widget elementor-widget-text-editor\" data-id=\"b6bfd4f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny a statisztikai f\u00fcggv\u00e9nyek k\u00f6z\u00e9 tartozik. A\u00a0DARAB f\u00fcggv\u00e9ny az argumentumaik\u00e9nt megadott \u00e9rt\u00e9kek k\u00f6z\u00fcl a numerikus, m\u00edg a DARAB2 a nem \u00fcres, teh\u00e1t b\u00e1rmilyen t\u00edpus\u00fa adatok sz\u00e1m\u00e1t adja eredm\u00e9ny\u00fcl<\/strong>.<\/p>\n\n<p>A k\u00e9t f\u00fcggv\u00e9ny szintaxisa a k\u00f6vetkez\u0151:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-07a9620 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"07a9620\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e6557ab\" data-id=\"e6557ab\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c16636 elementor-widget elementor-widget-text-editor\" data-id=\"5c16636\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>DARAB<em>(arg1[;arg2\u2026])<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86861f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86861f4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-73af754\" data-id=\"73af754\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76bfd9a elementor-widget elementor-widget-text-editor\" data-id=\"76bfd9a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>DARAB2(<em>arg1[;arg2\u2026]<\/em>)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a17670e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a17670e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d225e87\" data-id=\"d225e87\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16714c0 elementor-widget elementor-widget-text-editor\" data-id=\"16714c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>ahol <em>arg1<\/em> \u00e9s <em>arg2 <\/em>az argumentumokat jelenti. A f\u00fcggv\u00e9ny legal\u00e1bb egy, legfeljebb 255 darab argumentum megad\u00e1s\u00e1t v\u00e1rja. Argumentum lehet konstans (5), cellahivatkoz\u00e1s (A1), tartom\u00e1nyhivatkoz\u00e1s (A1:C10), tartom\u00e1nyn\u00e9v (Oszt\u00e1ly), t\u00f6mb \u00e9s k\u00e9plet is, ak\u00e1r vegyesen is.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5390680 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5390680\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-51c446d\" data-id=\"51c446d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-79b5f37 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"79b5f37\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A DARAB \\u00e9s a DARAB2 f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2. A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny alkalmaz\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3fd754d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3fd754d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8de8401\" data-id=\"8de8401\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2002ba2 elementor-widget elementor-widget-text-editor\" data-id=\"2002ba2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>N\u00e9zz\u00fcnk n\u00e9h\u00e1ny p\u00e9ld\u00e1t:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5857ec8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5857ec8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-18276a2\" data-id=\"18276a2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5d9d8f8 elementor-widget elementor-widget-text-editor\" data-id=\"5d9d8f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(5;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b571036 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b571036\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a50a28e\" data-id=\"a50a28e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f52f059 elementor-widget elementor-widget-text-editor\" data-id=\"f52f059\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB2(5;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d0aa00 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d0aa00\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-559238c\" data-id=\"559238c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-df5e23f elementor-widget elementor-widget-text-editor\" data-id=\"df5e23f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mindk\u00e9t k\u00e9plet eredm\u00e9nye 2. Ezt egyszer\u0171 bel\u00e1tnunk, mert mindk\u00e9t argumentum numerikus, illetve nem \u00fcres \u00e9rt\u00e9k. N\u00e9zz\u00fcnk k\u00e9t p\u00e9ld\u00e1t \u00fcres karakterl\u00e1ncra!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c80c796 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c80c796\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fc452d4\" data-id=\"fc452d4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-eb0c8c4 elementor-widget elementor-widget-text-editor\" data-id=\"eb0c8c4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(&#8222;&#8221;;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-703a4d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"703a4d1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-780d262\" data-id=\"780d262\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2696fd4 elementor-widget elementor-widget-text-editor\" data-id=\"2696fd4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB2(&#8222;&#8221;;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-17820b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"17820b2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f4cea82\" data-id=\"f4cea82\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a6d75ea elementor-widget elementor-widget-text-editor\" data-id=\"a6d75ea\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A DARAB f\u00fcggv\u00e9nyt tartalmaz\u00f3 k\u00e9plet eredm\u00e9nye 1, mert az \u00fcres karakterl\u00e1nc nem numerikus \u00e9rt\u00e9k. Ezzel szemben a DARAB2 k\u00e9plet m\u00e1r figyelembe veszi az \u00fcres sztringet, mint nem \u00fcres adatot, \u00edgy a k\u00e9plet eredm\u00e9nye 2.<\/p>\n\n<p>N\u00e9zz\u00fcnk egy kicsit ravaszabb p\u00e9ld\u00e1t! Az al\u00e1bbi k\u00e9t k\u00e9plet numerikus \u00e9rt\u00e9keket sz\u00f6vegk\u00e9nt ad \u00e1t a k\u00e9t f\u00fcggv\u00e9nynek. A DARAB2 eset\u00e9n nem lehet k\u00e9ts\u00e9g\u00fcnk \u2013 az eredm\u00e9ny 2, hiszen b\u00e1rmi is az \u00e1tadott adatok t\u00edpusa, megsz\u00e1molja azokat. A DARAB azonban meglepet\u00e9ssel szolg\u00e1l: az eredm\u00e9ny szint\u00e9n 2. Ennek oka, hogy az Excel felismeri, ha egy karakterl\u00e1nc sz\u00e1mk\u00e9nt \u00e9rtelmezhet\u0151 adat.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2e3b37d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2e3b37d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-02e7ac3\" data-id=\"02e7ac3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fd6ffce elementor-widget elementor-widget-text-editor\" data-id=\"fd6ffce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(&#8222;5&#8243;;SZ\u00d6VEG(5;&#8221;00&#8221;))<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-215d64e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"215d64e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-710ff80\" data-id=\"710ff80\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8ef2a99 elementor-widget elementor-widget-text-editor\" data-id=\"8ef2a99\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB2(&#8222;5&#8243;;SZ\u00d6VEG(5;&#8221;00&#8221;))<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0c6572a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0c6572a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d7de7ac\" data-id=\"d7de7ac\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e8c6c78 elementor-widget elementor-widget-text-editor\" data-id=\"e8c6c78\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az IGAZ \u00e9s a HAMIS logikai \u00e9rt\u00e9kek viselked\u00e9se \u00f3vatoss\u00e1gra int: ha logikai \u00e9rt\u00e9ket tartalmaz\u00f3 cell\u00e1ra mutat\u00f3 hivatkoz\u00e1st adunk \u00e1t argumentumk\u00e9nt a DARAB f\u00fcggv\u00e9nynek, akkor azt nem tekinti numerikus adatnak, ha viszont k\u00e9pletben konstansk\u00e9nt, f\u00fcggv\u00e9nyk\u00e9nt vagy felt\u00e9telvizsg\u00e1lat eredm\u00e9nyek\u00e9nt jelenik meg, akkor igen. N\u00e9zz\u00fcnk n\u00e9h\u00e1ny p\u00e9ld\u00e1t!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-000e27a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"000e27a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5801673\" data-id=\"5801673\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-47a6eb1 elementor-widget elementor-widget-text-editor\" data-id=\"47a6eb1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(A1;B1)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-316f3d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"316f3d1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb2e219\" data-id=\"bb2e219\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-676b055 elementor-widget elementor-widget-text-editor\" data-id=\"676b055\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha az A1 \u00e9s a B1 cell\u00e1k tartalma IGAZ vagy HAMIS, akkor a fenti k\u00e9plet eredm\u00e9nye nulla. A k\u00f6vetkez\u0151 k\u00e9pletek eredm\u00e9nye azonban 2.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8d595da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d595da\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-02221a2\" data-id=\"02221a2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-989d50f elementor-widget elementor-widget-text-editor\" data-id=\"989d50f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(IGAZ;HAMIS)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-94d94e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94d94e8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-02892c0\" data-id=\"02892c0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-274c5cb elementor-widget elementor-widget-text-editor\" data-id=\"274c5cb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(IGAZ();HAMIS())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0d9cfa4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0d9cfa4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4d0b5b1\" data-id=\"4d0b5b1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-09da26d elementor-widget elementor-widget-text-editor\" data-id=\"09da26d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(5&gt;3;5&lt;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4048725 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4048725\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-281b453\" data-id=\"281b453\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2f1029f elementor-widget elementor-widget-text-editor\" data-id=\"2f1029f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A h\u00e1rom k\u00e9plet csak abban k\u00fcl\u00f6nb\u00f6zik egym\u00e1st\u00f3l, hogy a logikai \u00e9rt\u00e9kek konstansk\u00e9nt, f\u00fcggv\u00e9nyk\u00e9nt \u00e9s egy felt\u00e9telvizsg\u00e1lat eredm\u00e9nyek\u00e9nt jelennek meg argumentumk\u00e9nt a z\u00e1r\u00f3jelek k\u00f6z\u00f6tt.<\/p>\n\n<p>Ezzel szemben a DARAB2 nem \u00fcres adatnak tekinti a k\u00e9t logikai \u00e9rt\u00e9ket, \u00edgy b\u00e1rmilyen form\u00e1ban is adjuk meg argumentumk\u00e9nt, megsz\u00e1molja.<\/p>\n\n<p>A k\u00f6vetkez\u0151 k\u00e9t k\u00e9plet d\u00e1tum \u00e9s id\u0151\u00e9rt\u00e9kekkel sz\u00e1mol. Mivel a d\u00e1tum \u00e9s id\u0151 adatt\u00edpusa is numerikus, a k\u00e9pletek eredm\u00e9nye nem k\u00e9ts\u00e9ges: 2.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f2d6564 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f2d6564\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e502b8b\" data-id=\"e502b8b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f505216 elementor-widget elementor-widget-text-editor\" data-id=\"f505216\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(D\u00c1TUM\u00c9RT\u00c9K(&#8222;20\/4\/13&#8221;);ID\u0150\u00c9RT\u00c9K(&#8222;8:4&#8221;))<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-72aac0b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72aac0b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-44ee3fe\" data-id=\"44ee3fe\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4abdc97 elementor-widget elementor-widget-text-editor\" data-id=\"4abdc97\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB2(D\u00c1TUM\u00c9RT\u00c9K(&#8222;20\/4\/13&#8221;);ID\u0150\u00c9RT\u00c9K(&#8222;8:4&#8221;))<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1fe9e1f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1fe9e1f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7596e6d\" data-id=\"7596e6d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cee695b elementor-widget elementor-widget-text-editor\" data-id=\"cee695b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Vajon mi lehet az eredm\u00e9nye az al\u00e1bbi k\u00e9t k\u00e9pletnek? A hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9s\u00e9re haszn\u00e1lt #HI\u00c1NYZIK hiba\u00e9rt\u00e9k \u00e9s HI\u00c1NYZIK f\u00fcggv\u00e9ny egyr\u00e9szt nem numerikus \u00e9rt\u00e9k, m\u00e1sr\u00e9szt nem \u00fcres adat. V\u00e1rhat\u00f3an a DARAB f\u00fcggv\u00e9ny null\u00e1t, m\u00edg a DARAB2 kett\u0151t ad eredm\u00e9ny\u00fcl.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ed56ffb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ed56ffb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d80e784\" data-id=\"d80e784\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2f560ee elementor-widget elementor-widget-text-editor\" data-id=\"2f560ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB(#HI\u00c1NYZIK;HI\u00c1NYZIK())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-275f1ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"275f1ed\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-46e630e\" data-id=\"46e630e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-914d2fe elementor-widget elementor-widget-text-editor\" data-id=\"914d2fe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=DARAB2(#HI\u00c1NYZIK;HI\u00c1NYZIK())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64cf34a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64cf34a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-db70b02\" data-id=\"db70b02\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ea70e71 elementor-widget elementor-widget-text-editor\" data-id=\"ea70e71\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A fentiek \u00e9rtelmez\u00e9s\u00e9hez tov\u00e1bbi seg\u00edts\u00e9g\u00fcnkre lehet az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>, amely a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">193-K-Excel-DARAB, DARAB2 f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka1 munkalapj\u00e1t mutatja:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c10a166 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c10a166\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4846b2a\" data-id=\"4846b2a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0d8191a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"0d8191a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Az A oszlop \u00e9rt\u00e9keinek adatt\u00edpusa sz\u00f6veg. A DARAB f\u00fcggv\u00e9ny eredm\u00e9nye nulla, a DARAB2 f\u00fcggv\u00e9ny\u00e9 2.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A DARAB f\u00fcggv\u00e9ny a B1 cell\u00e1ban elhelyezett sz\u00f6veg t\u00edpus\u00fa 1-es sz\u00e1mot sz\u00e1mnak, m\u00edg a B7 cell\u00e1ban tal\u00e1lhat\u00f3 \u00e9rt\u00e9ket sz\u00f6vegnek tekinti.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A C oszlopban tal\u00e1lhat\u00f3 logikai \u00e9rt\u00e9kek \u00e9s \u00fcres cell\u00e1k DARAB eset\u00e9n null\u00e1t, DARAB2 eset\u00e9n 2-t adnak eredm\u00e9ny\u00fcl.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A D:G oszlopok \u00e9rt\u00e9kei mind numerikus adatnak sz\u00e1m\u00edtanak, \u00edgy mindk\u00e9t f\u00fcggv\u00e9ny eredm\u00e9nye 7.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A H2 cell\u00e1ban \u00fcres karakterl\u00e1nc (\"\") tal\u00e1lhat\u00f3, \u00edgy a DARAB2 eredm\u00e9nye 7. A DARAB azonban csak a H4:H7 tartom\u00e1ny cell\u00e1inak tartalm\u00e1t tekinti numerikus \u00e9rt\u00e9knek, \u00edgy az eredm\u00e9ny 4.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dbc25eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbc25eb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-de790ea\" data-id=\"de790ea\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9f1e76b elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"9f1e76b\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-1024x576.jpg\" class=\"attachment-large size-large wp-image-2974\" alt=\"1. \u00e1bra: A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9nyek \u00e1ltal kezelt adatt\u00edpusok.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_1_Munka1.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: A <strong>DARAB <\/strong>\u00e9s a <strong>DARAB2 <\/strong>f\u00fcggv\u00e9nyek \u00e1ltal kezelt adatt\u00edpusok.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6c0e247 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c0e247\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-15430b1\" data-id=\"15430b1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0e16563 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"0e16563\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. K\\u00e9rd\\u00e9sek \\u00e9s v\\u00e1laszok&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3. K\u00e9rd\u00e9sek \u00e9s v\u00e1laszok<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ac1b831 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ac1b831\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a7e9366\" data-id=\"a7e9366\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-98467c7 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"98467c7\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.1. Mi a f\\u00fcggv\\u00e9nyek angol nyelv\\u0171 Excelben haszn\\u00e1lhat\\u00f3 neve?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.1. Mi a f\u00fcggv\u00e9nyek angol nyelv\u0171 Excelben haszn\u00e1lhat\u00f3 neve?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0e836b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0e836b2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9820fb3\" data-id=\"9820fb3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b7b6bd2 elementor-widget elementor-widget-text-editor\" data-id=\"b7b6bd2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A DARAB f\u00fcggv\u00e9ny neve COUNT, a DARAB2 f\u00fcggv\u00e9ny neve COUNTA.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7658973 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7658973\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31aff6c\" data-id=\"31aff6c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3410db4 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"3410db4\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.2. Hogyan haszn\\u00e1lom ezt a k\\u00e9t f\\u00fcggv\\u00e9nyt egy \\u00f6sszef\\u00fcgg\\u0151 t\\u00e1bl\\u00e1zat sorainak \\u00e9s oszlopainak kisz\\u00e1m\\u00edt\\u00e1s\\u00e1ra?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.2. Hogyan haszn\u00e1lom ezt a k\u00e9t f\u00fcggv\u00e9nyt egy \u00f6sszef\u00fcgg\u0151 t\u00e1bl\u00e1zat sorainak \u00e9s oszlopainak kisz\u00e1m\u00edt\u00e1s\u00e1ra?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9dd8782 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9dd8782\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d1258f4\" data-id=\"d1258f4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2c78a0f elementor-widget elementor-widget-text-editor\" data-id=\"2c78a0f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Gyakori feladat, amikor egy \u00f6sszef\u00fcgg\u0151, t\u00e9glalap alak\u00fa t\u00e1bl\u00e1zat adatsoraiban \u00e9s adatoszlopaiban kell a k\u00e9t f\u00fcggv\u00e9nnyel megjelen\u00edten\u00fcnk adatt\u00edpust\u00f3l f\u00fcgg\u0151en az \u00e9rt\u00e9kek sz\u00e1m\u00e1t. Az ilyen feladatokban \u00e1ltal\u00e1ban az a k\u00e9r\u00e9s, hogy sz\u00e1moljuk meg az \u00e9rt\u00e9keket az ilyen-olyan oszlopokban vagy sorokban, \u00e9s jelen\u00edts\u00fck meg azokat az oszlopok alatti sorban, illetve a sorok melletti oszlopban. A\u00a0megfogalmaz\u00e1s els\u0151 hall\u00e1sra bonyolult, pedig csup\u00e1n arr\u00f3l van sz\u00f3, hogy:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4885da5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4885da5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a1bb593\" data-id=\"a1bb593\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2cd8a83 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"2cd8a83\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Az oszlopokban l\u00e9v\u0151 \u00e9rt\u00e9keket az oszlopok alatti sorban kell megjelen\u00edten\u00fcnk.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A sorokban tal\u00e1lhat\u00f3 \u00e9rt\u00e9keket a sorok melletti oszlopban kell megjelen\u00edten\u00fcnk.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0cef261 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0cef261\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2d4f612\" data-id=\"2d4f612\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0a37bf8 elementor-widget elementor-widget-text-editor\" data-id=\"0a37bf8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>N\u00e9zz\u00fcnk a k\u00e9t f\u00fcggv\u00e9ny haszn\u00e1lat\u00e1ra egy tipikus p\u00e9ld\u00e1t a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">193-K-Excel-DARAB, DARAB2 f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka2 munkalapj\u00e1n <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2.jpg\" target=\"_blank\" rel=\"noopener\">(2. \u00e1bra)<\/a>! Az A1:F14 t\u00e1bl\u00e1zatban a numerikus \u00e9rt\u00e9kek mellett \u00fcres cella (C4), \u00fcres karakterl\u00e1nc (D4), sz\u00e1mnak l\u00e1tsz\u00f3 karakterl\u00e1nc (B7), hi\u00e1nyz\u00f3 adat (C9, D6), logikai \u00e9rt\u00e9k (B11), \u00e9s a hi\u00e1nyz\u00f3 adatot tipikusan jelz\u0151 nulla \u00e9rt\u00e9k (D11) is van! (Vizsg\u00e1ljuk meg a t\u00e1bl\u00e1zatot, miel\u0151tt tov\u00e1bb olvasunk!)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1a1c2fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a1c2fa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d34f680\" data-id=\"d34f680\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7a4aa25 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"7a4aa25\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-1024x576.jpg\" class=\"attachment-large size-large wp-image-2975\" alt=\"2. \u00e1bra: A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_2_Munka2.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: A <strong>DARAB <\/strong>\u00e9s a <strong>DARAB2 <\/strong>f\u00fcggv\u00e9ny tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0d24cc2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0d24cc2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cfea464\" data-id=\"cfea464\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5ad0a40 elementor-widget elementor-widget-text-editor\" data-id=\"5ad0a40\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az oszlopokban tal\u00e1lhat\u00f3 numerikus \u00e9rt\u00e9kek sz\u00e1m\u00e1t a 13. sorban kellett kisz\u00e1molnunk. Ehhez kijel\u00f6lt\u00fck az oszlopok alatti, 13. sorban l\u00e9v\u0151 cell\u00e1kat, vagyis a B13:D13 tartom\u00e1nyt. A tartom\u00e1ny els\u0151, akt\u00edv cell\u00e1j\u00e1ba, vagyis a B13 cell\u00e1ba beg\u00e9pelt\u00fck a felette l\u00e9v\u0151 oszlop adataival sz\u00e1mol\u00f3 k\u00e9pletet: <strong>=DARAB(B3:B12)<\/strong>, majd le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t. Ezzel a billenty\u0171kombin\u00e1ci\u00f3val mindh\u00e1rom cell\u00e1ba a megfelel\u0151 k\u00e9pletet tudtuk bevinni. A DARAB2 f\u00fcggv\u00e9nnyel m\u00e1r k\u00f6nnyen boldogultunk: kijel\u00f6lt\u00fck a B14:D14 tartom\u00e1nyt, a B14 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=DARAB2(B3:B12)<\/strong> k\u00e9pletet, majd le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t.<\/p>\n<p>L\u00e1ssuk, hogyan j\u00e1rtunk el a sorok eset\u00e9ben: a t\u00edz term\u00e9k sorai melletti E oszlopban kellett \u00f6sszesz\u00e1molnunk az egyes sorokban tal\u00e1lhat\u00f3 \u00e9rt\u00e9keket. Ezen t\u00edz cella tartom\u00e1nyhivatkoz\u00e1sa E3:E12. Kijel\u00f6lt\u00fck ezt a tartom\u00e1nyt, majd az E3 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=DARAB(B3:D3)<\/strong> k\u00e9pletet, v\u00e9g\u00fcl le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! \u00cdgy minden sorhoz siker\u00fclt megjelen\u00edten\u00fcnk az \u00e9rt\u00e9kek sz\u00e1m\u00e1t. A DARAB2 f\u00fcggv\u00e9nnyel szint\u00e9n k\u00f6nnyen boldogultunk: kijel\u00f6lt\u00fck az F3:F12 tartom\u00e1nyt, az F3 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=DARAB2(B3:D3)<\/strong> k\u00e9pletet, majd le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t.<\/p>\n<p>A c\u00edmben feltett \u201eHogyan haszn\u00e1lom ezt a k\u00e9t f\u00fcggv\u00e9nyt egy \u00f6sszef\u00fcgg\u0151 t\u00e1bl\u00e1zat sorainak \u00e9s oszlopainak kisz\u00e1m\u00edt\u00e1s\u00e1ra?\u201d k\u00e9rd\u00e9sre a v\u00e1lasz teh\u00e1t az, hogy \u00edgy.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-09fcfd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"09fcfd9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ae14d9f\" data-id=\"ae14d9f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fa03063 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"fa03063\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.3. Van valami gyorsabb m\\u00f3dszer az ilyen jelleg\\u0171 feladatokban a DARAB f\\u00fcggv\\u00e9ny bevitel\\u00e9re?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.3. Van valami gyorsabb m\u00f3dszer az ilyen jelleg\u0171 feladatokban a DARAB f\u00fcggv\u00e9ny bevitel\u00e9re?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4704034 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4704034\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9e4e26f\" data-id=\"9e4e26f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5e1486f elementor-widget elementor-widget-text-editor\" data-id=\"5e1486f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Van, de nagyon kell \u00fcgyeln\u00fcnk arra, hogy az al\u00e1bbi m\u00f3dszerek a DARAB f\u00fcggv\u00e9nnyel \u00e9s csak abban az esetben m\u0171k\u00f6dnek, ha a k\u00e9plet oszlopa, illetve sora azonos adatt\u00edpus\u00fa \u00e9rt\u00e9keket tartalmaz (csupa sz\u00e1m, d\u00e1tum stb.) \u2013 v\u00e1ltoz\u00f3 adatt\u00edpus\u00fa adatok eset\u00e9ben a DARAB f\u00fcggv\u00e9ny nem megfelel\u0151 <\/strong><strong>tartom\u00e1nyhivatkoz\u00e1st<\/strong> <strong>kaphat.<\/strong> Ezen term\u00e9szetesen ut\u00f3lag jav\u00edthatunk.<\/p>\n<p>\u00c9ppen emiatt a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">193-K-Excel-DARAB, DARAB2 f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka2 munkalapj\u00e1n elhelyezett t\u00e1bl\u00e1zaton nem tudjuk kipr\u00f3b\u00e1lni a le\u00edrtakat. Ez\u00e9rt k\u00e9sz\u00edtett\u00fcnk egy Munka3 munkalapot, amely csak sz\u00e1mokat tartalmaz <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3.jpg\" target=\"_blank\" rel=\"noopener\">(3. \u00e1bra)<\/a>.<\/p>\n<p>L\u00e1ssuk a k\u00e9t m\u00f3dszert:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b69a382 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b69a382\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-da3b545\" data-id=\"da3b545\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5a2dfdb elementor-widget elementor-widget-text-editor\" data-id=\"5a2dfdb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol>\n<li>m\u00f3dszer: jel\u00f6lj\u00fck ki ism\u00e9t a B13:D13 tartom\u00e1nyt az oszlopok numerikus \u00e9rt\u00e9keinek kisz\u00e1m\u00edt\u00e1s\u00e1hoz, majd a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Sz\u00e1mok darabsz\u00e1ma <\/strong><em>(Alt+\u0150, D, S)<\/em> parancsot! Jel\u00f6lj\u00fck ki a E3:E12 tartom\u00e1nyt a sorok numerikus \u00e9rt\u00e9keinek kisz\u00e1m\u00edt\u00e1s\u00e1hoz, majd a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Sz\u00e1mok darabsz\u00e1ma <\/strong><em>(Alt+\u0150, D, S)<\/em> parancsot!<\/li>\n<li>m\u00f3dszer: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171vel megjelen\u00edthet\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablakkal az el\u0151z\u0151 pontban eml\u00edtett k\u00e9t tartom\u00e1nyt, a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be beg\u00e9pelve a B13:D13;E3:E12 tartom\u00e1nyhivatkoz\u00e1sokat. Ezut\u00e1n a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Sz\u00e1mok darabsz\u00e1ma <\/strong><em>(Alt+\u0150, D, S)<\/em> parancsot! Minden cell\u00e1ba a megfelel\u0151 k\u00e9plet ker\u00fcl a megfelel\u0151 oszlop, illetve sorhivatkoz\u00e1ssal.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1054edc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1054edc\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1e680e2\" data-id=\"1e680e2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c828bb elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"5c828bb\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-1024x576.jpg\" class=\"attachment-large size-large wp-image-2980\" alt=\"3. \u00e1bra: P\u00e9lda a DARAB f\u00fcggv\u00e9ny gyors alkalmaz\u00e1s\u00e1ra.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/193-K-Excel-DARAB-DARAB2-f\u00fcggv\u00e9nyek_3_Munka3.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">3. \u00e1bra: P\u00e9lda a <strong>DARAB <\/strong>f\u00fcggv\u00e9ny gyors alkalmaz\u00e1s\u00e1ra.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-74f58ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"74f58ab\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-22b9feb\" data-id=\"22b9feb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-50a513f elementor-widget elementor-widget-text-editor\" data-id=\"50a513f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A fenti m\u00f3dszerek alkalmazhat\u00f3s\u00e1g\u00e1nak az az oka, hogy az Excelt felk\u00e9sz\u00edtett\u00e9k a szokv\u00e1nyos t\u00e1bl\u00e1zatelrendez\u00e9sekre \u00e9s a tipikus sz\u00e1m\u00edt\u00e1si feladatokra.<br \/>Ennek ellen\u00e9re a fenti m\u00f3dszerek korl\u00e1tozottan, csak abban az esetben haszn\u00e1lhat\u00f3k, ha a k\u00e9pletet k\u00f6zvetlen\u00fcl az adatsorok mell\u00e9, illetve az adatoszlopok al\u00e1 akarjuk bevinni. Teh\u00e1t, ha az F oszlopban, illetve a 14. sorban akarjuk a DARAB f\u00fcggv\u00e9nyt r\u00f6gz\u00edteni a fenti m\u00f3dszerek egyik\u00e9vel, nem lesz j\u00f3 a tartom\u00e1nyhivatkoz\u00e1s. Ennek oka, hogy az Excel beleveszi az E oszlopot \u00e9s a 13. sort is a tartom\u00e1nyba.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a433e2c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a433e2c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-51b379b\" data-id=\"51b379b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6c95a6 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"b6c95a6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.4. A hi\\u00e1nyz\\u00f3 adatok jel\\u00f6l\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.4. A hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0447588 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0447588\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cfa72de\" data-id=\"cfa72de\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4324eaf elementor-widget elementor-widget-text-editor\" data-id=\"4324eaf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Aki nem ismeri a #HI\u00c1NYZIK hiba\u00e9rt\u00e9ket \u00e9s a HI\u00c1NYZIK f\u00fcggv\u00e9nyt, az a hi\u00e1nyz\u00f3 adatait \u00fcres cell\u00e1val, vagy valamilyen m\u00e1s, megegyez\u00e9sen alapul\u00f3 \u00e9rt\u00e9kkel helyettes\u00edti. Ezt nem szabad, mert t\u00f6bb f\u00fcggv\u00e9ny szolg\u00e1ltathat hib\u00e1s, nem v\u00e1rt, f\u00e9lrevezet\u0151 eredm\u00e9nyt, okozhat nehezen felder\u00edthet\u0151 hib\u00e1t, illetve az ilyen adatsorok diagramon \u00e1br\u00e1zol\u00e1sa is f\u00e9lre\u00e9rthet\u0151. Olvassuk el <a href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">A # hiba\u00e9rt\u00e9kek (#169)<\/a> cikk <a href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888#3_HIANYZIK_-_hianyzo_adat_jelzese\">3. #HI\u00c1NYZIK \u2013 hi\u00e1nyz\u00f3 adat jelz\u00e9se<\/a> fejezet\u00e9t, hogy meg\u00e9rts\u00fck, hogyan kell helyesen jel\u00f6lni egy t\u00e1bl\u00e1zatban a hi\u00e1nyz\u00f3 adatot!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6c0be8a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c0be8a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e897d77\" data-id=\"e897d77\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c91d289 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"c91d289\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>V\u00c9GE.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8c872b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8c872b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-49a8152\" data-id=\"49a8152\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fba49e6 elementor-widget elementor-widget-text-editor\" data-id=\"fba49e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 \u00e1prilis 9.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (19H2, 1909b18363)<br \/>Irodai programcsomag: Microsoft Office 2016 v2003b12624.20382, Havi csatorna<br \/>Szint: kezd\u0151, ECDL: M04\/S6\/4.2.1<br \/>Kateg\u00f3ria: T\u00e1bl\u00e1zatkezel\u00e9s \u2192 K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek \u2192 F\u00fcggv\u00e9nyek haszn\u00e1lata<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5582948 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5582948\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8caeb00\" data-id=\"8caeb00\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6e6b7e8 elementor-widget elementor-widget-shortcode\" data-id=\"6e6b7e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><!-- FeedbackWP Plugin --><div        class=\"rmp-widgets-container rmp-wp-plugin rmp-main-container js-rmp-widgets-container js-rmp-widgets-container--2929 \"        data-post-id=\"2929\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2929\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2929\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dcddca8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dcddca8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a9c6b0d\" data-id=\"a9c6b0d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-87d0376 elementor-share-buttons--skin-flat elementor-share-buttons--view-icon-text elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-global elementor-global-15485 elementor-widget-share-buttons\" data-id=\"87d0376\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0 Friss\u00edtve: 2020 m\u00e1jus 10. Mir\u0151l sz\u00f3l ez a cikk?A DARAB \u00e9s a DARAB2 f\u00fcggv\u00e9ny szint\u00e9n gyakori l\u00e1togat\u00f3ja az Excel t\u00e1bl\u00e1zatoknak. Minden olyan feladatban hasznosak, amelyben meg kell sz\u00e1molni bizonyos adatt\u00edpus\u00fa \u00e9rt\u00e9keket, egy\u00e1ltal\u00e1n az \u00e9rt\u00e9kek megl\u00e9t\u00e9t. Ebben a cikkben ezt a k\u00e9t, m\u00e9g mindig egyszer\u0171 Excel f\u00fcggv\u00e9nyt mutatjuk be. Tartalomjegyz\u00e9k \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2929\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":962,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-2929","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2929"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2929\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/962"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}