{"id":4590,"date":"2024-12-06T13:16:55","date_gmt":"2024-12-06T13:16:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/huong-dan-ham-column-tra-ve-vi-tri-cot-cua-tham-chieu-trong-excel\/"},"modified":"2024-12-06T13:16:55","modified_gmt":"2024-12-06T13:16:55","slug":"huong-dan-ham-column-tra-ve-vi-tri-cot-cua-tham-chieu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/huong-dan-ham-column-tra-ve-vi-tri-cot-cua-tham-chieu-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn h\u00e0m COLUMN tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a tham chi\u1ebfu trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n mu\u1ed1n bi\u1ebft tham chi\u1ebfu c\u1ee7a m\u00ecnh thu\u1ed9c c\u1ed9t n\u00e0o? B\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n d\u1ef1a tr\u00ean t\u1ecda \u0111\u1ed9 c\u1ed9t c\u1ee7a \u00f4 \u0111\u00f3? Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n s\u01a1 l\u01b0\u1ee3c nh\u1ea5t v\u1ec1 h\u00e0m COLUMN tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a tham chi\u1ebfu.<\/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-6752f946bbfa9\" 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-column-tra-ve-vi-tri-cot-tham-chieu.html#Ham_COLUMN_cong_dung_va_cu_phap\" title=\"H\u00e0m COLUMN, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m COLUMN, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/ham-column-tra-ve-vi-tri-cot-tham-chieu.html#Cong_dung_ham_COLUMN\" title=\"C\u00f4ng d\u1ee5ng h\u00e0m COLUMN\">C\u00f4ng d\u1ee5ng h\u00e0m COLUMN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-column-tra-ve-vi-tri-cot-tham-chieu.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/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\/ham-column-tra-ve-vi-tri-cot-tham-chieu.html#Ung_dung\" title=\"\u1ee8ng d\u1ee5ng\">\u1ee8ng d\u1ee5ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_COLUMN_cong_dung_va_cu_phap\"><\/span>H\u00e0m COLUMN, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_dung_ham_COLUMN\"><\/span>C\u00f4ng d\u1ee5ng h\u00e0m COLUMN<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m COLUMN tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a tham chi\u00ea\u0301u nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COLUMN nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=COLUMN(tham chi\u1ebfu)<\/strong><\/p>\n<\/blockquote>\n<p>N\u1ebfu\u00a0<strong>tham chi\u1ebfu<\/strong> r\u1ed7ng, COLUMN s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t t\u1ea1i \u00f4 nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o<\/p>\n<p><strong>Tham chi\u1ebfu<\/strong> l\u00e0 m\u1ed9t \u00f4, COLUMN s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a \u00f4 \u0111\u00f3<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p\u00a0<strong>tham chi\u1ebfu<\/strong> l\u00e0 m\u1ed9t v\u00f9ng, COLUMN s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean trong v\u00f9ng \u0111\u00f3<\/p>\n<p><em>L\u01b0u \u00fd: Trong tr\u01b0\u1eddng h\u1ee3p h\u00e0m COLUMN \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng ngang cho m\u1ed9t v\u00f9ng, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd t\u0103ng ti\u1ebfn d\u1ea7n t\u1edbi h\u1ebft v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a v\u00f9ng \u0111\u00f3. V\u00ed d\u1ee5:<\/em><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-157.gif\" title=\"vba101_92019-nho-157\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-370.gif\" title=\"ex101_92019-nho-370\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25306\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-column-1.png\" width=\"894\" height=\"208\" title=\"ham-column-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung\"><\/span>\u1ee8ng d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u1ee8ng d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t c\u1ee7a h\u00e0m COLUMN \u0111\u00f3 l\u00e0 t\u1ea1o ra danh s\u00e1ch d\u1eef li\u1ec7u s\u1ed1 t\u0103ng ti\u1ebfn theo h\u00e0ng ngang.<\/p>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 t\u1ea1o d\u1eef li\u1ec7u t\u0103ng ti\u1ebfn theo c\u1ea5p s\u1ed1 c\u1ed9ng 2 \u0111\u01a1n v\u1ecb, ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>1. Nh\u1eadp \u0111i\u1ec3m \u0111\u1ea7u<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25307\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-column-2.png\" width=\"226\" height=\"68\" title=\"ham-column-2\"><\/p>\n<p>2. T\u1ea1i \u00f4 C1, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p><em>=$B$1*(COLUMN()-1)<\/em><\/p>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng thao t\u00e1c fill \u0111\u1ec3 t\u1ea1o ra d\u00e3y s\u1ed1 t\u0103ng ti\u1ebfn<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-column-3.png\" width=\"566\" height=\"128\" title=\"ham-column-3\"><\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-mot-cot-thanh-nhieu-cot-bang-cong-thuc.html\"><strong>Chuy\u1ec3n m\u1ed9t c\u1ed9t th\u00e0nh nhi\u1ec1u c\u1ed9t trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c \u2013 Ph\u1ea7n 1<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-mot-cot-thanh-nhieu-cot-bang-cong-thuc-phan-2.html\"><strong>Chuy\u1ec3n m\u1ed9t c\u1ed9t th\u00e0nh nhi\u1ec1u c\u1ed9t trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c \u2013 Ph\u1ea7n 2<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/co-dinh-cot-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-157.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4591,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4590","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\/4590","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=4590"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4590\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4591"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}