{"id":8360,"date":"2024-12-22T10:14:16","date_gmt":"2024-12-22T10:14:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/cong-thuc-mang-dong-va-vung-tran-trong-excel\/"},"modified":"2024-12-22T10:14:16","modified_gmt":"2024-12-22T10:14:16","slug":"cong-thuc-mang-dong-va-vung-tran-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/cong-thuc-mang-dong-va-vung-tran-trong-excel\/","title":{"rendered":"C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng v\u00e0 v\u00f9ng tr\u00e0n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc \u0111\u00e2y, trong h\u1ea7u h\u1ebft c\u00e1c c\u00f4ng th\u1ee9c ta ch\u1ec9 c\u00f3 th\u1ec3 th\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ea3ng d\u1eef li\u1ec7u. Hi\u1ec7n t\u1ea1i, Microsoft \u0111\u00e3 cho ra m\u1eaft <strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\">c\u00f4ng th\u1ee9c m\u1ea3ng<\/a> \u0111\u1ed9ng<\/strong> v\u00e0 v\u00f9ng tr\u00e0n trong Excel. T\u00ednh n\u0103ng n\u00e0y \u0111em l\u1ea1i nh\u1eefng thay \u0111\u1ed5i v\u00e0 hi\u1ec7u qu\u1ea3 ra sao, h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u nh\u00e9.<\/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-6767e677495e9\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#Cong_thuc_mang_dong_va_vung_tran_trong_Excel\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng v\u00e0 v\u00f9ng tr\u00e0n trong Excel\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng v\u00e0 v\u00f9ng tr\u00e0n trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#Chung_ta_se_tam_biet_Ctrl_Shift_Enter\" title=\"Ch\u00fang ta s\u1ebd t\u1ea1m bi\u1ec7t Ctrl + Shift + Enter\">Ch\u00fang ta s\u1ebd t\u1ea1m bi\u1ec7t Ctrl + Shift + Enter<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#Ham_UNIQUE\" title=\"H\u00e0m UNIQUE\">H\u00e0m UNIQUE<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#SPILL_RANGE\" title=\"SPILL RANGE\">SPILL RANGE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#LOI_SPILL\" title=\"L\u1ed6I #SPILL\">L\u1ed6I #SPILL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#HAM_SORT\" title=\"H\u00c0M SORT\">H\u00c0M SORT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#KY_HIEU_CHO_THAM_CHIEU_VUNG_TRAN\" title=\"K\u00dd HI\u1ec6U CHO THAM CHI\u1ebeU V\u00d9NG TR\u00c0N\">K\u00dd HI\u1ec6U CHO THAM CHI\u1ebeU V\u00d9NG TR\u00c0N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#KET_HOP_CONG_THUC_MANG_DONG\" title=\"K\u1ebeT H\u1ee2P C\u00d4NG TH\u1ee8C M\u1ea2NG \u0110\u1ed8NG\">K\u1ebeT H\u1ee2P C\u00d4NG TH\u1ee8C M\u1ea2NG \u0110\u1ed8NG<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#SU_DUNG_MANG_DONG_CHO_DATA_VALIDATION\" title=\"S\u1eec D\u1ee4NG M\u1ea2NG \u0110\u1ed8NG CHO DATA VALIDATION\">S\u1eec D\u1ee4NG M\u1ea2NG \u0110\u1ed8NG CHO DATA VALIDATION<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#NHUNG_HAM_HIEN_TAI_CUNG_CO_THE_HIEN_THI_VUNG_TRAN\" title=\"NH\u1eeeNG H\u00c0M HI\u1ec6N T\u1ea0I C\u0168NG C\u00d3 TH\u1ec2 HI\u1ec2N TH\u1eca V\u00d9NG TR\u00c0N\">NH\u1eeeNG H\u00c0M HI\u1ec6N T\u1ea0I C\u0168NG C\u00d3 TH\u1ec2 HI\u1ec2N TH\u1eca V\u00d9NG TR\u00c0N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-mang-dong-vung-tran-trong-excel.html#KET_LUAN\" title=\"K\u1ebeT LU\u1eacN\">K\u1ebeT LU\u1eacN<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_dong_va_vung_tran_trong_Excel\"><\/span>C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng v\u00e0 v\u00f9ng tr\u00e0n trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Microsoft v\u1eeba tr\u00ecnh l\u00e0ng m\u1ed9t t\u00ednh n\u0103ng m\u1edbi cho Excel. T\u00ednh n\u0103ng n\u00e0y s\u1ebd thay \u0111\u1ed5i c\u00e1ch ta l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c sau n\u00e0y: C\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng (Dynamic array formula)<br \/>\nT\u00ednh n\u0103ng n\u00e0y cho ph\u00e9p tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 tr\u00ean m\u1ed9t v\u00f9ng th\u00f4ng qua ch\u1ec9 m\u1ed9t c\u00f4ng th\u1ee9c. N\u00f3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 v\u00f9ng tr\u00e0n (spill range).<br \/>\nHi\u1ec7n t\u1ea1i Excel \u0111ang c\u00f3 7 h\u00e0m m\u1ea3ng \u0111\u1ed9ng m\u00e0 sau n\u00e0y ch\u1eafc ch\u1eafn s\u1ebd nhi\u1ec1u h\u01a1n. Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o 1 list c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ed9c nh\u1ea5t (lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p), s\u1eafp x\u1ebfp danh s\u00e1ch, l\u1ecdc d\u1eef li\u1ec7u\u2026 M\u1ed9t \u0111i\u1ec3m n\u1eefa l\u00e0 nh\u1eefng h\u00e0m c\u0169 c\u0169ng \u0111\u01b0\u1ee3c c\u1ea3i ti\u1ebfn \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00f9ng tr\u00e0n n\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-1.png\" width=\"410\" height=\"246\" title=\"cong-thuc-mang-dong-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chung_ta_se_tam_biet_Ctrl_Shift_Enter\"><\/span>Ch\u00fang ta s\u1ebd t\u1ea1m bi\u1ec7t Ctrl + Shift + Enter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ee5c \u0111\u00edch c\u1ee7a t\u00ednh n\u0103ng m\u1edbi n\u00e0y l\u00e0 thay th\u1ebf nh\u1eefng c\u00f4ng th\u1ee9c m\u1ea3ng m\u00e0 ta \u0111\u01b0a v\u00e0o Excel th\u00f4ng qua Ctrl + Shift + Enter (CSE). Nh\u1eefng c\u00f4ng th\u1ee9c CSE ph\u1ee9c t\u1ea1p v\u00e0 kh\u00f3 \u0111o\u00e1n s\u1ed1 l\u01b0\u1ee3ng, gi\u1edd th\u00ec bai bai nh\u00e9. H\u00e3y c\u00f9ng \u0111i v\u00e0o nh\u1eefng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ham_UNIQUE\"><\/span>H\u00e0m UNIQUE<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi h\u00e0m UNIQUE ta c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t list \u0111\u1ed9c nh\u1ea5t (hay c\u00f2n g\u1ecdi l\u00e0 thao t\u00e1c x\u00f3a tr\u00f9ng). \u0110\u1ec3 d\u00f9ng h\u00e0m n\u00e0y, ch\u1ec9 c\u1ea7n nh\u1eadp nh\u01b0 trong h\u00ecnh tr\u00ean th\u00f4i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"SPILL_RANGE\"><\/span>SPILL RANGE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e3y c\u00f9ng l\u00e0m quen v\u1edbi thu\u1eadt ng\u1eef \u201cspill\u201d nh\u00e9. C\u00e1i \u201cv\u00f9ng tr\u00e0n\u201d n\u00e0y l\u00e0 v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ee7a nh\u1eefng h\u00e0m m\u1ea3ng \u0111\u1ed9ng m\u1edbi. N\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t h\u00e0ng\/c\u1ed9t\/h\u00e0ng &amp; c\u1ed9t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28309\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-2.png\" width=\"368\" height=\"249\" title=\"cong-thuc-mang-dong-2\"><\/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\/2024\/12\/ex101_92019-nho-763.gif\" title=\"ex101_92019-nho-763\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"LOI_SPILL\"><\/span>L\u1ed6I #SPILL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi trong v\u00f9ng tr\u00e0n ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u d\u1eef b\u00ean ngo\u00e0i. Khi g\u1eb7p l\u1ed7i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u1ea5n v\u00e0o \u201cSelect Obstructing Cells\u201d \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 nh\u1eefng \u00f4 c\u1ea3n tr\u1edf vi\u1ec7c hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, sau \u0111\u00f3 di chuy\u1ec3n ho\u1eb7c x\u00f3a \u0111\u1ec3 c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28310\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-3.png\" width=\"393\" height=\"265\" title=\"cong-thuc-mang-dong-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"HAM_SORT\"><\/span>H\u00c0M SORT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 UNIQUE, h\u00e0m SORT c\u0169ng l\u00e0 m\u1ed9t h\u00e0m m\u1ea3ng \u0111\u1ed9ng m\u1edbi. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 h\u00e0m n\u00e0y l\u00e0 danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28311\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-4.png\" width=\"393\" height=\"249\" title=\"cong-thuc-mang-dong-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"KY_HIEU_CHO_THAM_CHIEU_VUNG_TRAN\"><\/span>K\u00dd HI\u1ec6U CHO THAM CHI\u1ebeU V\u00d9NG TR\u00c0N<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi c\u00f4ng th\u1ee9c tr\u00ean ch\u00fang ta s\u1eed d\u1ee5ng d\u1ea5u <strong>#<\/strong> \u2013 \u0111\u00e2y l\u00e0 tham chi\u1ebfu t\u1edbi v\u00f9ng tr\u00e0n. K\u00fd hi\u1ec7u n\u00e0y cho ph\u00e9p ta tham chi\u1ebfu to\u00e0n b\u1ed9 v\u00f9ng b\u1eb1ng c\u00e1ch \u0111\u1eb7t n\u00f3 sau \u0111\u1ecba ch\u1ec9 \u0111\u1ea7u ti\u00ean c\u1ee7a \u00f4 thu\u1ed9c v\u00f9ng tr\u00e0n \u0111\u00f3.<br \/>\n\u0110\u00e2y l\u00e0 m\u1ed9t k\u00fd hi\u1ec7u v\u00f4 c\u00f9ng h\u1eefu d\u1ee5ng. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t tham chi\u1ebfu t\u1edbi ngu\u1ed3n d\u1eef li\u1ec7u cho c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng kh\u00e1c nh\u01b0 v\u00ed d\u1ee5 s\u1eed d\u1ee5ng SORT. \u0110\u1ed3ng th\u1eddi b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng nh\u01b0 SUM, COUNT,\u2026 ho\u1eb7c tham chi\u1ebfu nh\u01b0 VLOOKUP, INDEX, MATCH\u2026<br \/>\nK\u1ec3 c\u1ea3 \u0111\u1eb7t t\u00ean v\u00f9ng hay data validation c\u0169ng kh\u00f4ng lo\u1ea1i l\u1ec7 \u2013 ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng # \u0111\u1ec3 tham chi\u1ebfu.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"KET_HOP_CONG_THUC_MANG_DONG\"><\/span>K\u1ebeT H\u1ee2P C\u00d4NG TH\u1ee8C M\u1ea2NG \u0110\u1ed8NG<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhau. Ch\u1eb3ng h\u1ea1n nh\u01b0 ta c\u00f3 th\u1ec3 r\u00fat ng\u1eafn v\u00ed d\u1ee5 tr\u00ean b\u1eb1ng vi\u1ec7c \u0111\u01b0a SORT v\u00e0 UNIQUE v\u00e0o c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28312\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-5.png\" width=\"427\" height=\"267\" title=\"cong-thuc-mang-dong-5\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"SU_DUNG_MANG_DONG_CHO_DATA_VALIDATION\"><\/span>S\u1eec D\u1ee4NG M\u1ea2NG \u0110\u1ed8NG CHO DATA VALIDATION<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thay v\u00ec ch\u1ecdn c\u1ea3 v\u00f9ng nh\u01b0 tr\u01b0\u1edbc, ta c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t danh s\u00e1ch cho data validation b\u1eb1ng c\u00e1ch \u0111\u01b0a d\u1ea5u # v\u00e0o sau tham chi\u1ebfu t\u1edbi \u00f4 \u0111\u1ea7u ti\u00ean trong v\u00f9ng tr\u00e0n:<br \/>\nPh\u1ea7n th\u00fa v\u1ecb nh\u1ea5t \u1edf \u0111\u00e2y l\u00e0 v\u00f9ng tr\u00e0n lu\u00f4n t\u1ef1 \u0111\u1ed9ng update. M\u1ecdi th\u1ee9 \u0111\u1ec1u \u201c\u0111\u1ed9ng\u201d, c\u00f3 ngh\u0129a l\u00e0 ta kh\u00f4ng ph\u1ea3i lo t\u1edbi vi\u1ec7c ki\u1ec3m so\u00e1t v\u00f9ng ho\u1eb7c update l\u1ea1i c\u00f4ng th\u1ee9c. K\u00fd hi\u1ec7u tham chi\u1ebfu lu\u00f4n bao g\u1ed3m t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec \u0111\u01b0\u1ee3c th\u00eam v\u00e0o v\u00f9ng tr\u00e0n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28313\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-6.png\" width=\"660\" height=\"371\" title=\"cong-thuc-mang-dong-6\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"NHUNG_HAM_HIEN_TAI_CUNG_CO_THE_HIEN_THI_VUNG_TRAN\"><\/span>NH\u1eeeNG H\u00c0M HI\u1ec6N T\u1ea0I C\u0168NG C\u00d3 TH\u1ec2 HI\u1ec2N TH\u1eca V\u00d9NG TR\u00c0N<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i nh\u1eefng h\u00e0m m\u1ea3ng \u0111\u1ed9ng m\u1edbi, ngay c\u1ea3 nh\u1eefng h\u00e0m \u0111ang hi\u1ec7n h\u1eefu trong Excel c\u0169ng c\u00f3 th\u1ec3 th\u1ec3 hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng \u0111\u1ed9ng v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 trong v\u00f9ng tr\u00e0n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28314\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-mang-dong-7.png\" width=\"271\" height=\"128\" title=\"cong-thuc-mang-dong-7\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"KET_LUAN\"><\/span>K\u1ebeT LU\u1eacN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ea3ng \u0111\u1ed9ng s\u1ebd s\u1edbm ph\u1ed5 bi\u1ebfn trong Excel v\u00e0 s\u1ebd l\u00e0 m\u1ed9t b\u01b0\u1edbc chuy\u1ec3n \u0111\u1ed5i quan tr\u1ecdng trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c. N\u1ebfu b\u1ea1n t\u1eebng s\u1eed d\u1ee5ng Google Sheets, b\u1ea1n s\u1ebd bi\u1ebft r\u1eb1ng \u0111\u00e2y kh\u00f4ng h\u1eb3n l\u00e0 c\u00f4ng ngh\u1ec7 m\u1edbi m\u1ebb g\u00ec. Tuy nhi\u00ean v\u1edbi vi\u1ec7c cho ra m\u1eaft v\u00f9ng tr\u00e0n v\u00e0 tham chi\u1ebfu, \u0111\u00e2y l\u00e0 m\u1ed9t b\u01b0\u1edbc ti\u1ebfn l\u1edbn trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng t\u00ednh n\u0103ng kh\u00e1c.<\/p>\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\/2024\/12\/ex101_92019-nho-763.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8361,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8360","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\/8360","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=8360"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8360\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8361"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}