{"id":12132,"date":"2025-01-15T07:17:27","date_gmt":"2025-01-15T07:17:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/chuc-nang-va-cu-phap-ham-frequency-trong-excel\/"},"modified":"2025-01-15T07:17:27","modified_gmt":"2025-01-15T07:17:27","slug":"chuc-nang-va-cu-phap-ham-frequency-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/chuc-nang-va-cu-phap-ham-frequency-trong-excel\/","title":{"rendered":"Ch\u1ee9c n\u0103ng v\u00e0 c\u00fa ph\u00e1p h\u00e0m FREQUENCY trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: left\"><em><strong>H\u00e0m FREQUENCY trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t m\u1ea3ng s\u1ed1 h\u1ecdc, \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3.<\/strong><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-678761048d405\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chuc-nang-va-cu-phap-ham-frequency-trong-excel.html#Cu_phap_FREQUENCYData_arrayBins_array\" title=\"C\u00fa ph\u00e1p: =FREQUENCY(Data_array,Bins_array)\">C\u00fa ph\u00e1p: =FREQUENCY(Data_array,Bins_array)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chuc-nang-va-cu-phap-ham-frequency-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_FREQUENCYData_arrayBins_array\"><\/span><em><strong>C\u00fa ph\u00e1p<\/strong><\/em>: =<strong>FREQUENCY(Data_array,Bins_array)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3<\/em><strong>: <\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li><em><strong>Data_array<\/strong>:<\/em> M\u1ea3ng d\u1eef li\u1ec7u cho tr\u01b0\u1edbc.<strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/strong><\/li>\n<li><em><strong>Bins_array<\/strong>:<\/em> M\u1ea3ng ch\u1ee9a c\u00e1c kho\u1ea3ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ea7n su\u1ea5t.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Do k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m <strong>FREQUENCY<\/strong> l\u00e0 m\u1ed9t m\u1ea3ng s\u1ed1 h\u1ecdc n\u00ean tr\u01b0\u1edbc khi d\u00f9ng h\u00e0m ta ph\u1ea3i ch\u1ecdn m\u1ea3ng s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 v\u00e0 \u0111\u1ec3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 hi\u1ec3n th\u1ecb tr\u00ean c\u00e1c \u00f4 \u0111\u00f3 th\u00ec sau khi nh\u1eadp c\u00fa ph\u00e1p xong ta nh\u1ea5n <em>CTRL+SHIFT+ENTER<\/em>.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Trong b\u1ea3ng s\u1ed1 li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y, t\u00ecm t\u1ea7n s\u1ed1 xu\u1ea5t hi\u1ec7n c\u1ee7a d\u1eef li\u1ec7u \u1edf m\u1ea3ng <em>\u0110i\u1ec1u ki\u1ec7n<\/em> trong m\u1ea3ng <em>\u0110TB.<\/em><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4164 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel-5.png\" width=\"600\" height=\"471\" title=\"tao-list-excel-5\"><\/p>\n<ul style=\"text-align: justify\">\n<li>D\u00f9ng c\u00f4ng th\u1ee9c: =<strong>FREQUENCY(C4:C8;D4:D8)<\/strong><strong>,\u00a0<\/strong>thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4165 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel-6.png\" width=\"600\" height=\"402\" title=\"tao-list-excel-6\"><\/p>\n<p style=\"text-align: justify\">\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-355.gif\" title=\"ex101_92019-nho-355\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-355.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12133,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12132"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12133"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}