{"id":9200,"date":"2025-01-01T21:09:02","date_gmt":"2025-01-01T21:09:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/cach-dung-ham-row-tra-ve-vi-tri-hang-cua-tham-chieu-trong-excel\/"},"modified":"2025-01-01T21:09:02","modified_gmt":"2025-01-01T21:09:02","slug":"cach-dung-ham-row-tra-ve-vi-tri-hang-cua-tham-chieu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/cach-dung-ham-row-tra-ve-vi-tri-hang-cua-tham-chieu-trong-excel\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m ROW tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a tham chi\u1ebfu trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc v\u1ec1 h\u00e0m COLUMN, H\u1ecdc Excel Online \u0111\u00e3 gi\u1edbi thi\u1ec7u b\u1ea1n c\u00e1ch \u0111\u1ec3 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a tham chi\u1ebfu trong Excel. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, ta s\u1ebd t\u00ecm hi\u1ec3u m\u1ed9t h\u00e0m t\u01b0\u01a1ng t\u1ef1: h\u00e0m ROW \u2013 tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed h\u00e0ng 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-6775aeeda8426\" 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-row-tra-ve-vi-tri-hang-cua-tham-chieu.html#Ham_ROW_cong_dung_va_cu_phap\" title=\"H\u00e0m ROW, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m ROW, 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-row-tra-ve-vi-tri-hang-cua-tham-chieu.html#Cong_thuc_ham_ROW\" title=\"C\u00f4ng th\u1ee9c h\u00e0m ROW\">C\u00f4ng th\u1ee9c h\u00e0m ROW<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-row-tra-ve-vi-tri-hang-cua-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_ROW_cong_dung_va_cu_phap\"><\/span>H\u00e0m ROW, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m ROW r\u1ea3 v\u1ec1 v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a tham chi\u00ea\u0301u nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_ROW\"><\/span>C\u00f4ng th\u1ee9c h\u00e0m ROW<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROW nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=ROW(tham chi\u1ebfu)<\/strong><\/p>\n<\/blockquote>\n<p>N\u1ebfu\u00a0<strong>tham chi\u1ebfu<\/strong>\u00a0r\u1ed7ng,\u00a0ROW\u00a0s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed\u00a0h\u00e0ng\u00a0t\u1ea1i \u00f4 nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o<\/p>\n<p><strong>Tham chi\u1ebfu<\/strong>\u00a0l\u00e0 m\u1ed9t \u00f4,\u00a0ROW\u00a0s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a \u00f4 \u0111\u00f3<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p\u00a0<strong>tham chi\u1ebfu<\/strong>\u00a0l\u00e0 m\u1ed9t v\u00f9ng,\u00a0ROW\u00a0s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed h\u00e0ng 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 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o d\u01b0\u1edbi d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng\u00a0d\u1ecdc\u00a0cho 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\u00a0d\u00f2ng\u00a0c\u1ee7a v\u00f9ng \u0111\u00f3. V\u00ed d\u1ee5:<\/em><\/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-21.gif\" title=\"ex101_92019-nho-21\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25312\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-row-1.png\" width=\"369\" height=\"370\" title=\"ham-row-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>C\u0169ng nh\u01b0 h\u00e0m\u00a0<strong>COLUMN<\/strong>, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROW thi\u1ebft l\u1eadp d\u00e3y gi\u00e1 tr\u1ecb t\u0103ng ti\u1ebfn theo h\u00e0ng d\u1ecdc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25313\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-row-2.png\" width=\"372\" height=\"332\" title=\"ham-row-2\"><\/p>\n<p>C\u00f4ng th\u1ee9c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, t\u1ea1i \u00f4 A3 l\u00e0:<\/p>\n<p>=$A$2*(ROW()-1)<\/p>\n<p>\u00a0<\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-cell-thong-tin-o.html\"><strong>H\u01b0\u1edbng d\u1eabn h\u00e0m CELL tra c\u1ee9u th\u00f4ng tin \u00f4 trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-column-titles-va-row-titles.html\"><strong>Thi\u1ebft l\u1eadp Column Titles v\u00e0 Row Titles<\/strong><\/a><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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\/2025\/01\/ex101_92019-nho-21.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9201,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9200","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\/9200","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=9200"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9200\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9201"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}