{"id":8249,"date":"2024-12-22T04:24:23","date_gmt":"2024-12-22T04:24:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/bieu-do-dong-voi-ham-index-row-va-scroll-bar-control\/"},"modified":"2024-12-22T04:24:23","modified_gmt":"2024-12-22T04:24:23","slug":"bieu-do-dong-voi-ham-index-row-va-scroll-bar-control","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/bieu-do-dong-voi-ham-index-row-va-scroll-bar-control\/","title":{"rendered":"Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng v\u1edbi h\u00e0m Index, Row v\u00e0 Scroll bar control"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Tr\u01b0\u1edbc khi b\u1eaft tay v\u00e0o l\u00e0m theo b\u00e0i vi\u1ebft n\u00e0y, \u0111\u00e2y l\u00e0 s\u1ea3n ph\u1ea9m m\u00e0 c\u00e1c b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c sau khi ho\u00e0n th\u00e0nh<\/p>\n<p style=\"text-align: center\"><\/p>\n<p>K\u0129 thu\u1eadt \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u00e0i vi\u1ebft n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 \u201cSliding Windows\u201d \u2013 hay l\u00e0 c\u1eeda s\u1ed5 tr\u01b0\u1ee3t *, b\u1edfi v\u00ec ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u t\u1eeb n\u0103m 1950 \u0111\u1ebfn 2017, tuy nhi\u00ean ch\u00fang ta s\u1ebd kh\u00f4ng v\u1ebd bi\u1ec3u \u0111\u1ed3 d\u00e2n s\u1ed1 th\u1ebf gi\u1edbi cho t\u1ea5t c\u1ea3 c\u00e1c n\u0103m \u1ea5y, ch\u00fang ta s\u1ebd ch\u1ec9 nh\u00ecn v\u00e0o 5 \u0111\u1ebfn 10 n\u0103m m\u00e0 th\u00f4i. T\u1eeb suy ngh\u0129 \u0111\u00f3, ta h\u00ecnh dung ra k\u0129 thu\u1eadt n\u00e0y gi\u1ed1ng nh\u01b0 1 c\u1eeda s\u1ed5 tr\u01b0\u1ee3t.<\/p>\n<p>*Nhi\u1ec1u k\u0129 thu\u1eadt kh\u00e1c \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong kho\u00e1 h\u1ecdc <a href=\"https:\/\/blog.hocexcel.online\/dv101\" target=\"_blank\">DV101 \u2013 Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u qua bi\u1ec3u \u0111\u1ed3 Excel<\/a><\/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-6767947661c79\" 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\/bieu-do-dong-ham-index-row-scrollbar-control.html#Buoc_1_Chuan_bi_du_lieu\" title=\"B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u\">B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<\/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\/bieu-do-dong-ham-index-row-scrollbar-control.html#Buoc_2_Xu_ly_du_lieu_trong_Excel\" title=\"B\u01b0\u1edbc 2: X\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel\">B\u01b0\u1edbc 2: X\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel<\/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\/bieu-do-dong-ham-index-row-scrollbar-control.html#Buoc_3_ve_do_thi_dua_tren_du_lieu_da_duoc_xu_ly\" title=\"B\u01b0\u1edbc 3: v\u1ebd \u0111\u1ed3 th\u1ecb d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd\">B\u01b0\u1edbc 3: v\u1ebd \u0111\u1ed3 th\u1ecb d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/bieu-do-dong-ham-index-row-scrollbar-control.html#Download_tai_lieu_Excel_kem_theo_bai_viet\" title=\"Download t\u00e0i li\u1ec7u Excel k\u00e8m theo b\u00e0i vi\u1ebft\">Download t\u00e0i li\u1ec7u Excel k\u00e8m theo b\u00e0i vi\u1ebft<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/bieu-do-dong-ham-index-row-scrollbar-control.html#Kham_pha_them_that_nhieu_kien_thuc_voi_Hoc_Excel_Online\" title=\"Kh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:\">Kh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Chuan_bi_du_lieu\"><\/span>B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta l\u00e0 d\u1eef li\u1ec7u d\u00e2n s\u1ed1 th\u1ebf gi\u1edbi t\u1eeb n\u0103m 1950 \u0111\u1ebfn 2017, \u0111\u01b0\u1ee3c l\u01b0u trong b\u1ea3ng t\u00ednh <strong>raw data\u00a0<\/strong>ngh\u0129a l\u00e0 d\u1eef li\u1ec7u th\u00f4. Trong b\u1ea3ng d\u1eef li\u1ec7u th\u00f4 n\u00e0y, ch\u00fang ta s\u1ebd \u0111\u1eb7t 2 name ranges v\u1edbi v\u00f9ng tham chi\u1ebfu nh\u01b0 sau:<\/p>\n<ol>\n<li>year: A2:A69<\/li>\n<li>population: B2:B69<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2566\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-07-at-08-54-22-300x173-1.png\" width=\"300\" height=\"173\" title=\"screen-shot-2017-01-07-at-08-54-22-300x173-1\"><\/p>\n<p>\u00a0<\/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-749.gif\" title=\"ex101_92019-nho-749\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Xu_ly_du_lieu_trong_Excel\"><\/span>B\u01b0\u1edbc 2: X\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta s\u1ebd kh\u00f4ng v\u1ebd ngay bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u th\u00f4, do \u0111\u00f3 t\u1eeb d\u1eef li\u1ec7u th\u00f4, ch\u00fang ta s\u1ebd x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean 1 b\u1ea3ng t\u00ednh m\u1edbi g\u1ecdi l\u00e0 <strong>processed data<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-2567\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-07-at-09-18-21-copy-300x108-1.png\" width=\"300\" height=\"108\" title=\"screen-shot-2017-01-07-at-09-18-21-copy-300x108-1\"><\/p>\n<p>C\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u n\u00e0y:<\/p>\n<ul>\n<li><strong>A2=INDEX(year,$C$1 + ROW() \u2013 2)<\/strong><\/li>\n<li><strong>B2=ROUND(Index(year,$C$1 + ROW() \u2013 2)\/1000000,0)<\/strong><\/li>\n<li><strong>C2=\u201dWorld Population \u201c&amp;A2&amp;\u201d \u2013 \u201c&amp;A6<\/strong><\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Ho\u0323c Excel k\u1ebf to\u00e1n b\u00e1n h\u00e0ng<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_ve_do_thi_dua_tren_du_lieu_da_duoc_xu_ly\"><\/span>B\u01b0\u1edbc 3: v\u1ebd \u0111\u1ed3 th\u1ecb d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n n\u00e0y m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i video<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/BRMvHMjMsPE\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Download_tai_lieu_Excel_kem_theo_bai_viet\"><\/span>Download t\u00e0i li\u1ec7u Excel k\u00e8m theo b\u00e0i vi\u1ebft<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>[sociallocker id=2748]<\/p>\n<p><a href=\"https:\/\/goo.gl\/c8SW2Z\" target=\"_blank\">https:\/\/goo.gl\/c8SW2Z<\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Kham_pha_them_that_nhieu_kien_thuc_voi_Hoc_Excel_Online\"><\/span>Kh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ol>\n<li>H\u1ecdc Excel, C\u00f3 Vi\u1ec7c Ngay: <a href=\"https:\/\/blog.hocexcel.online\/ex101\" target=\"_blank\">https:\/\/www.hocexcel.online\/ex101<\/a><\/li>\n<li>H\u00e3y \u0111\u1ec3 VBA gi\u00fap b\u1ea1n: <a href=\"https:\/\/blog.hocexcel.online\/vba101\" target=\"_blank\">https:\/\/www.hocexcel.online\/vba101<\/a><\/li>\n<li>Hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u1edbi Excel: <a href=\"https:\/\/blog.hocexcel.online\/dv101\" target=\"_blank\">https:\/\/www.hocexcel.online\/dv101<\/a><\/li>\n<li>H\u00e3y l\u00e0m k\u1ebf to\u00e1n v\u1edbi VBA: <a href=\"https:\/\/blog.hocexcel.online\/im101\" target=\"_blank\">https:\/\/www.hocexcel.online\/im101<\/a><\/li>\n<li>Qu\u1ea3n l\u00fd kho h\u00e0ng trong Excel: <a href=\"https:\/\/blog.hocexcel.online\/im201\" target=\"_blank\">https:\/\/www.hocexcel.online\/im201<\/a><\/li>\n<\/ol>\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-749.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8250,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8249","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=8249"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8250"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}