{"id":8230,"date":"2024-12-22T04:18:15","date_gmt":"2024-12-22T04:18:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/gioi-thieu-cac-ham-tu-tinh-toan-lai-volatile-function-trong-excel\/"},"modified":"2024-12-22T04:18:15","modified_gmt":"2024-12-22T04:18:15","slug":"gioi-thieu-cac-ham-tu-tinh-toan-lai-volatile-function-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/gioi-thieu-cac-ham-tu-tinh-toan-lai-volatile-function-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u c\u00e1c h\u00e0m t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i (Volatile Function) trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel c\u00f3 m\u1ed9t s\u1ed1\u00a0h\u00e0m\u00a0\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 \u201cvolatile function\u201d, c\u00f3 ngh\u0129a l\u00e0 h\u00e0m s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i m\u1ed7i khi c\u00f3 s\u1ef1 thay \u0111\u1ed5i trong trang t\u00ednh. \u0110\u1ed1i v\u1edbi d\u1eef li\u1ec7u nh\u1ecf, vi\u1ec7c xu\u1ea5t hi\u1ec7n nh\u1eefng h\u00e0m n\u00e0y kh\u00f4ng \u1ea3nh h\u01b0\u1edfng g\u00ec. Tuy nhi\u00ean v\u1edbi s\u1ed5 t\u00ednh ch\u1ee9a nh\u1eefng b\u1ed9 d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng volatile function s\u1ebd g\u00e2y \u1ea3nh h\u01b0\u1edfng l\u1edbn \u2013 nh\u1eb9: l\u00e0m ch\u1eadm file, n\u1eb7ng: treo file, g\u1ea7n nh\u01b0 kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c. V\u1eady h\u00e0m t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i bao g\u1ed3m nh\u1eefng h\u00e0m n\u00e0o? H\u00e3y t\u00ecm hi\u1ec3u ngay trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/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-67679306a0d5d\" 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\/ham-tinh-lai-tu-dong-volatile-functions.html#Volatile_Function\" title=\"Volatile Function\">Volatile Function<\/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\/ham-tinh-lai-tu-dong-volatile-functions.html#Tham_chieu_phu_thuoc_ham_Volatile\" title=\"Tham chi\u1ebfu ph\u1ee5 thu\u1ed9c h\u00e0m Volatile\">Tham chi\u1ebfu ph\u1ee5 thu\u1ed9c h\u00e0m Volatile<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Conditional_Formatting_cung_la_%E2%80%9Cvolatile%E2%80%9D\" title=\"Conditional Formatting c\u0169ng l\u00e0 \u201cvolatile\u201d\">Conditional Formatting c\u0169ng l\u00e0 \u201cvolatile\u201d<\/a><\/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\/ham-tinh-lai-tu-dong-volatile-functions.html#Nhung_thao_tac_tac_dong_toi_viec_tu_tinh_toan_lai\" title=\"Nh\u1eefng thao t\u00e1c t\u00e1c \u0111\u1ed9ng t\u1edbi vi\u1ec7c t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i\">Nh\u1eefng thao t\u00e1c t\u00e1c \u0111\u1ed9ng t\u1edbi vi\u1ec7c t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Autofilter\" title=\"Autofilter\">Autofilter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#AutofitDieu_chinh_do_rong_hangcot\" title=\"Autofit\/\u0110i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng h\u00e0ng\/c\u1ed9t\">Autofit\/\u0110i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng h\u00e0ng\/c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Themxoadi_chuyen_hangcoto\" title=\"Th\u00eam\/x\u00f3a\/di chuy\u1ec3n h\u00e0ng\/c\u1ed9t\/\u00f4\">Th\u00eam\/x\u00f3a\/di chuy\u1ec3n h\u00e0ng\/c\u1ed9t\/\u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#ThemSuaXoa_ten\" title=\"Th\u00eam\/S\u1eeda\/X\u00f3a t\u00ean\">Th\u00eam\/S\u1eeda\/X\u00f3a t\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Thay_doi_tenvi_tri_cua_trang_tinh\" title=\"Thay \u0111\u1ed5i t\u00ean\/v\u1ecb tr\u00ed c\u1ee7a trang t\u00ednh\">Thay \u0111\u1ed5i t\u00ean\/v\u1ecb tr\u00ed c\u1ee7a trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Xoa_trang_tinh\" title=\"X\u00f3a trang t\u00ednh\">X\u00f3a trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Anhien_hang_trong_Excel_2003\" title=\"\u1ea8n\/hi\u1ec7n h\u00e0ng trong Excel 2003\">\u1ea8n\/hi\u1ec7n h\u00e0ng trong Excel 2003<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Mo_file_CSV\" title=\"M\u1edf file .CSV\">M\u1edf file .CSV<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/ham-tinh-lai-tu-dong-volatile-functions.html#Goal_Seek\" title=\"Goal Seek\">Goal Seek<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Volatile_Function\"><\/span>Volatile Function<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_28955\" aria-describedby=\"caption-attachment-28955\" style=\"width: 519px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-28955\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/volatile-functions-2.png\" width=\"519\" height=\"370\" title=\"volatile-functions-2\"><figcaption id=\"caption-attachment-28955\" class=\"wp-caption-text\">1 s\u1ed1 h\u00e0m t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i<\/figcaption><\/figure>\n<p>M\u1ed9t s\u1ed1 h\u00e0m trong Excel hi\u1ec3n nhi\u00ean l\u00e0 h\u00e0m t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i: RAND(), NOW(), TODAY()<\/p>\n<p>1 s\u1ed1 \u201c\u00edt hi\u1ec3n nhi\u00ean\u201d h\u01a1n: OFFSET(), CELL(), INDIRECT(), INFO()<\/p>\n<p>1 s\u1ed1 t\u1ef1 t\u00ednh to\u00e1n trong phi\u00ean b\u1ea3n n\u00e0y, nh\u01b0ng kh\u00f4ng ph\u1ea3i trong phi\u00ean b\u1ea3n kh\u00e1c: INDEX() t\u1eeb Excel 97 l\u00e0 m\u1ed9t h\u00e0m non-volatile.<\/p>\n<p>Nh\u1eefng h\u00e0m t\u01b0\u1edfng l\u00e0 h\u00e0m t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i nh\u01b0ng th\u1ef1c ch\u1ea5t l\u00e0 kh\u00f4ng: INDEX(), ROWS(), COLUMNS(), AREAS().<\/p>\n<p><strong>CELL(\u201cfilename\u201d)\u00a0<\/strong>l\u00e0 m\u1ed9t h\u00e0m volatile d\u00f9 cho Microsoft kh\u00f4ng c\u00f4ng nh\u1eadn.<\/p>\n<p>M\u1ed9t c\u00fa ph\u00e1p c\u1ee5 th\u1ec3 trong h\u00e0m SUMIF c\u0169ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 m\u1ed9t h\u00e0m t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i. \u0110i\u1ec1u n\u00e0y x\u1ea3y ra khi k\u00edch c\u1ee1 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng gi\u1ed1ng v\u1edbi v\u00f9ng t\u00ednh t\u1ed5ng. V\u00ed d\u1ee5:\u00a0<em>=SUMIF(A1:A4,\u201d&gt;0\u2033,B1)\u00a0<\/em>l\u00e0 volatile, trong khi\u00a0<em>=SUMIF(A1:A4,\u201d&gt;0\u2033,B1:B4)<\/em> th\u00ec kh\u00f4ng, d\u00f9 cho c\u1ea3 2 \u0111\u1ec1u s\u1ebd tham chi\u1ebfu \u0111\u1ebfn v\u00f9ng B1:B4.<\/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-746.gif\" title=\"ex101_92019-nho-746\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>S\u1eed d\u1ee5ng volatile function trong c\u00f4ng th\u1ee9c s\u1ebd bi\u1ebfn c\u1ea3 c\u00f4ng th\u1ee9c \u0111\u00f3 th\u00e0nh\u00a0<em>volatile<\/em>, d\u00f9 cho c\u00f3 th\u1ec3 ph\u1ea7n c\u00f4ng th\u1ee9c \u0111\u00f3 kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n. V\u00ed d\u1ee5:\u00a0<em>=IF(1&lt;2,99,NOW())<\/em> s\u1ebd lu\u00f4n tr\u1ea3 v\u1ec1 99, c\u00f2n ph\u1ea7n h\u00e0m t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i\u00a0<em>NOW()<\/em> kh\u00f4ng bao gi\u1edd \u0111\u01b0\u1ee3c g\u1ecdi ra. Tuy nhi\u00ean \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m IF n\u00e0y s\u1ebd lu\u00f4n \u0111\u01b0\u1ee3c coi l\u00e0\u00a0<em>volatile<\/em>.<\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p ngo\u1ea1i l\u1ec7:<\/p>\n<p><em>N\u1ebfu \u00f4 A1 ch\u1ee9a c\u00f4ng th\u1ee9c =NOW(), v\u00e0 \u00f4 B1 ch\u1ee9a c\u00f4ng th\u1ee9c =IF(1&lt;2,99,A1), th\u00ec B1 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t volatile.<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tham_chieu_phu_thuoc_ham_Volatile\"><\/span>Tham chi\u1ebfu ph\u1ee5 thu\u1ed9c h\u00e0m Volatile<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 2 ki\u1ec3u tham chi\u1ebfu ph\u1ee5 thu\u1ed9c: tr\u1ef1c ti\u1ebfp v\u00e0 gi\u00e1n ti\u1ebfp.<\/p>\n<p><strong>Ph\u1ee5 thu\u1ed9c tr\u1ef1c ti\u1ebfp (Direct dependents)<\/strong> s\u1ebd lu\u00f4n \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i:<\/p>\n<p>N\u1ebfu \u00f4 A1 ch\u1ee9a c\u00f4ng th\u1ee9c =NOW() v\u00e0 A2 ch\u1ee9a =A1, A3 = A2\u2026 th\u00ec to\u00e0n b\u1ed9 \u00f4 A2 v\u00e0 A3 s\u1ebd lu\u00f4n \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i theo A1.<\/p>\n<p><strong>Ph\u1ee5 thu\u1ed9c gi\u00e1n ti\u1ebfp (Indirect dependents)<\/strong> kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i:<\/p>\n<p>N\u1ebfu \u00f4 A1 ch\u1ee9a c\u00f4ng th\u1ee9c =NOW(), A2:A5 ch\u1ee9a s\u1ed1 t\u1eeb 2 t\u1edbi 5<\/p>\n<p><strong>=INDEX(A1:A5, 1, 1)\u00a0<\/strong>s\u1ebd ph\u1ee5 thu\u1ed9c tr\u1ef1c ti\u1ebfp v\u00e0 lu\u00f4n t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<p><strong>=INDEX(A1:A5, 3, 1)\u00a0<\/strong>ph\u1ee5 thu\u1ed9c gi\u00e1n ti\u1ebfp v\u00e0o \u00f4 A1 v\u00e0 s\u1ebd ch\u1ec9 t\u00ednh to\u00e1n l\u1ea1i m\u1ed9t khi gi\u00e1 tr\u1ecb \u1edf c\u00e1c \u00f4 trong m\u1ea3ng INDEX v\u00e0o thay \u0111\u1ed5i (ch\u1eb3ng h\u1ea1n nh\u01b0 thay \u0111\u1ed5i gi\u00e1 tr\u1ecb \u00f4 A5).<\/p>\n<p><em>L\u01b0u \u00fd: INDEX s\u1ebd t\u00ednh to\u00e1n l\u1ea1i khi c\u00f3 gi\u00e1 tr\u1ecb trong m\u1ea3ng nh\u1eadp v\u00e0o thay \u0111\u1ed5i. B\u1edfi v\u1eady, kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i thay \u0111\u1ed5i gi\u00e1 tr\u1ecb \u00f4 A3.<\/em><\/p>\n<h3><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Conditional_Formatting_cung_la_%E2%80%9Cvolatile%E2%80%9D\"><\/span>Conditional Formatting c\u0169ng l\u00e0 \u201cvolatile\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1edfi\u00a0<strong>Conditional Formatting<\/strong> lu\u00f4n c\u1ea7n \u0111\u01b0\u1ee3c ki\u1ec3m tra l\u1ea1i trong m\u1ed7i ph\u00e9p t\u00ednh, b\u1edfi v\u1eady nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong \u0111\u00f3 l\u00e0 volatile. \u0110\u1eb7c bi\u1ec7t, \u0111\u00e2y l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p t\u00ednh to\u00e1n l\u1ea1i m\u1ed9t c\u00e1ch li\u00ean t\u1ee5c trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u01b0 s\u1ef1 thay \u0111\u1ed5i m\u00e0u trong c\u00e1c \u00f4, k\u1ec3 c\u1ea3 trong ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n Manual, hay s\u1ef1 thay \u0111\u1ed5i \u0111\u01b0\u1ee3c t\u1ea1o n\u00ean b\u1edfi h\u00e0m trong VBA (m\u00e0 s\u1ebd kh\u00f4ng t\u00e1c \u0111\u1ed9ng t\u1edbi vi\u1ec7c t\u00ednh to\u00e1n) \u2013 Conditional formatting v\u1eabn s\u1ebd th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nhung_thao_tac_tac_dong_toi_viec_tu_tinh_toan_lai\"><\/span>Nh\u1eefng thao t\u00e1c t\u00e1c \u0111\u1ed9ng t\u1edbi vi\u1ec7c t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Autofilter\"><\/span>Autofilter<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1ea5t c\u1ee9 \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u01b0\u1ee3c ch\u1ecdn b\u1eb1ng Autofilter s\u1ebd \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 nh\u1eefng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111\u00f3 \u201cch\u01b0a t\u00ednh to\u00e1n l\u1ea1i\u201d d\u00f9 cho b\u1ea1n c\u00f3 s\u1eed d\u1ee5ng l\u1ea1i \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc, ho\u1eb7c ch\u01b0a c\u00f3 g\u00ec thay \u0111\u1ed5i trong v\u00f9ng Autofilter. Vi\u1ec7c n\u00e0y s\u1ebd khi\u1ebfn Autofilter r\u1ea5t ch\u1eadm v\u1ec1 l\u00e2u d\u00e0i.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"AutofitDieu_chinh_do_rong_hangcot\"><\/span>Autofit\/\u0110i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng h\u00e0ng\/c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n \u0111ang l\u00e0\u00a0<strong>Automatic,<\/strong> vi\u1ec7c click ho\u1eb7c click \u0111\u00fap v\u00e0o l\u1ec1 gi\u1eefa 2 c\u1ed9t ho\u1eb7c h\u00e0ng s\u1ebd t\u00e1c \u0111\u1ed9ng t\u1edbi t\u00ednh to\u00e1n l\u1ea1i. Tuy nhi\u00ean thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng h\u00e0ng\/c\u1ed9t th\u1ee7 c\u00f4ng s\u1ebd kh\u00f4ng t\u1ea1o n\u00ean t\u00e1c \u0111\u1ed9ng n\u00e0o.<\/p>\n<p>Trong ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n\u00a0<strong>Manual<\/strong>, vi\u1ec7c \u0111i\u1ec1u ch\u1ec9nh n\u00e0y d\u00f9 th\u1ee7 c\u00f4ng hay t\u1ef1 \u0111\u1ed9ng \u0111\u1ec1u kh\u00f4ng \u1ea3nh h\u01b0\u1edfng t\u1edbi t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Themxoadi_chuyen_hangcoto\"><\/span>Th\u00eam\/x\u00f3a\/di chuy\u1ec3n h\u00e0ng\/c\u1ed9t\/\u00f4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Vi\u1ec7c th\u00eam\/x\u00f3a\/di chuy\u1ec3n h\u00e0ng\/c\u1ed9t\/\u00f4 (s\u1eed d\u1ee5ng thao t\u00e1c k\u00e9o th\u1ea3, cut paste), \u0111\u1ed3ng th\u1eddi \u00f4 \u0111\u00f3 ch\u1ee9a 1 trong nh\u1eefng \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<ul>\n<li>\u0110\u01b0\u1ee3c \u0111\u1eb7t t\u00ean<\/li>\n<li>Ch\u1ee9a c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi \u0111\u1ecba ch\u1ec9 kh\u00e1c\/\u0111\u01b0\u1ee3c tham chi\u1ebfu t\u1eeb \u0111\u1ecba ch\u1ec9 kh\u00e1c<\/li>\n<\/ul>\n<p>S\u1ebd khi\u1ebfn nh\u1eefng \u00f4 \u0111\u00f3 \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"ThemSuaXoa_ten\"><\/span>Th\u00eam\/S\u1eeda\/X\u00f3a t\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi vi\u1ec7c \u0111\u1eb7t t\u00ean cho v\u00f9ng (Name range), m\u1ecdi h\u00e0nh \u0111\u1ed9ng nh\u01b0 th\u00eam\/s\u1eeda\/x\u00f3a t\u00ean s\u1ebd t\u00e1c \u0111\u1ed9ng t\u1edbi vi\u1ec7c t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thay_doi_tenvi_tri_cua_trang_tinh\"><\/span>Thay \u0111\u1ed5i t\u00ean\/v\u1ecb tr\u00ed c\u1ee7a trang t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed5i t\u00ean m\u1ed9t trang t\u00ednh ho\u1eb7c di chuy\u1ec3n n\u00f3 s\u1ebd t\u00e1c \u0111\u1ed9ng t\u1edbi vi\u1ec7c t\u00ednh to\u00e1n l\u1ea1i trong ch\u1ebf \u0111\u1ed9\u00a0<strong>Automatic.<\/strong><\/p>\n<p>\u0110\u1ed1i v\u1edbi ch\u1ebf \u0111\u1ed9\u00a0<strong>Manual<\/strong>, ch\u1ec9 khi c\u00f3 b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c trong trang t\u00ednh kh\u00e1c tham chi\u1ebfu t\u1edbi trang t\u00ednh \u0111\u00f3 m\u1edbi t\u00e1c \u0111\u1ed9ng t\u1edbi t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Xoa_trang_tinh\"><\/span>X\u00f3a trang t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong ch\u1ebf \u0111\u1ed9\u00a0<strong>Automatic<\/strong>, vi\u1ec7c x\u00f3a 1 trang t\u00ednh s\u1ebd t\u00e1c \u0111\u1ed9ng t\u1edbi t\u00ednh to\u00e1n l\u1ea1i, tuy nhi\u00ean th\u00eam trang t\u00ednh m\u1edbi th\u00ec kh\u00f4ng.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Anhien_hang_trong_Excel_2003\"><\/span>\u1ea8n\/hi\u1ec7n h\u00e0ng trong Excel 2003<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi ri\u00eang Excel 2003, vi\u1ec7c \u1ea9n\/hi\u1ec7n h\u00e0ng s\u1ebd \u0111\u00e1nh d\u1ea5u h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn \u201cch\u01b0a t\u00ednh to\u00e1n l\u1ea1i\u201d, trong ch\u1ebf \u0111\u1ed9\u00a0<strong>automatic<\/strong> \u0111\u01b0\u1ee3c hi\u1ec3u r\u1eb1ng n\u00f3 \u0111\u00e3 t\u00e1c \u0111\u1ed9ng t\u1edbi t\u00ednh to\u00e1n l\u1ea1i. Tuy nhi\u00ean, \u0111\u1ed1i v\u1edbi c\u1ed9t th\u00ec kh\u00f4ng.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Mo_file_CSV\"><\/span>M\u1edf file .CSV<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed7i khi b\u1ea1n m\u1edf 1 file .CSV, d\u00f9 cho qua VBA ho\u1eb7c tr\u1ef1c ti\u1ebfp qua t\u00ednh n\u0103ng\u00a0<strong>Open<\/strong>, vi\u1ec7c t\u00ednh to\u00e1n l\u1ea1i tr\u00ean to\u00e0n b\u1ed9 c\u00e1c s\u1ed5 t\u00ednh \u0111ang m\u1edf s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n. Vi\u1ec7c t\u1eaft l\u1ec7nh .<strong>EnableEvent<\/strong> kh\u00f4ng th\u1ec3 ng\u01b0ng \u0111\u01b0\u1ee3c t\u1ef1 t\u00ednh to\u00e1n. \u0110\u1ec3 kh\u00f4ng t\u00ednh to\u00e1n l\u1ea1i, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng VBA \u0111\u1ec3 thay \u0111\u1ed5i\u00a0<strong>Worksheet.EnableCalculation<\/strong> sang\u00a0<strong>False<\/strong> cho t\u1eebng trang tr\u00ednh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Goal_Seek\"><\/span>Goal Seek<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>S\u1eed d\u1ee5ng Goal Seek c\u0169ng t\u00e1c \u0111\u1ed9ng t\u1edbi t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<p>\u00a0<\/p>\n<p><em>Ngu\u1ed3n l\u01b0\u1ee3c d\u1ecbch:\u00a0<a href=\"http:\/\/www.decisionmodels.com\/calcsecretsb.htm\">http:\/\/www.decisionmodels.com\/calcsecretsb.htm<\/a><\/em><\/p>\n<hr>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong>C\u00e1c tr\u01b0\u1eddng h\u1ee3p khi\u1ebfn cho c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n (Evaluate) l\u1ea1i.<\/strong><\/p>\n<p><strong>C\u00e1ch m\u00e0 Excel t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i (hay v\u00ec sao m\u00e0 file c\u1ee7a b\u1ea1n l\u1ea1i ch\u1eadm \u0111\u1ebfn nh\u01b0 th\u1ebf?)<\/strong><\/p>\n<p>\u00a0<\/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-746.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8230","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\/8230","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=8230"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8230\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8231"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}