{"id":12298,"date":"2022-03-24T16:32:04","date_gmt":"2022-03-24T09:32:04","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12298"},"modified":"2022-03-24T16:32:04","modified_gmt":"2022-03-24T09:32:04","slug":"nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/","title":{"rendered":"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12298&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400\">.Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel, h\u1eb3n l\u00e0 b\u1ea1n c\u0169ng t\u1eebng ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn h\u00e0m ROW. V\u00ec n\u00f3 s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian cho b\u1ea1n. Th\u1ebf nh\u01b0ng, n\u1ebfu b\u1ea1n m\u1edbi ch\u1ec9 \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/\"><b>h\u00e0m ROW trong Excel<\/b><\/a><span style=\"font-weight: 400\"> th\u00ec c\u0169ng \u0111\u1eebng lo l\u1eafng. B\u00e0i vi\u1ebft n\u00e0y kh\u00f4ng ch\u1ec9 cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch m\u00e0 c\u00f2n r\u1ea5t ph\u00f9 h\u1ee3p cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u.\u00a0<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#Dinh_nghia_va_cu_phap_cua_ham_ROW_trong_Excel\" >\u0110\u1ecbnh ngh\u0129a v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m ROW trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#Cach_danh_so_thu_tu_thong_qua_ham_ROW\" >C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 th\u00f4ng qua h\u00e0m ROW\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#Phan_biet_ham_ROW_voi_ham_ROWS_va_cach_su_dung_cong_thuc_mang_trong_Excel\" >Ph\u00e2n bi\u1ec7t h\u00e0m ROW v\u1edbi h\u00e0m ROWS v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#Phan_biet_ham_ROWS_voi_ham_ROW_trong_Excel\" >Ph\u00e2n bi\u1ec7t h\u00e0m ROWS v\u1edbi h\u00e0m ROW trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#Cach_su_dung_cong_thuc_mang\" >C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dinh_nghia_va_cu_phap_cua_ham_ROW_trong_Excel\"><\/span><span style=\"font-weight: 400\">\u0110\u1ecbnh ngh\u0129a v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m ROW trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>H\u00e0m ROW trong Excel<\/b><span style=\"font-weight: 400\"> \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a m\u1ed9t tham chi\u1ebfu. Ngh\u0129a l\u00e0 b\u1ea1n s\u1ebd d\u00f9ng h\u00e0m n\u00e0y khi b\u1ea1n mu\u1ed1n l\u1ea5y s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng c\u1ee7a m\u1ed9t \u00f4 hay m\u1ed9t ph\u1ea1m vi \u00f4 nh\u1ea5t \u0111\u1ecbnh. H\u00e0m ROW s\u1ebd tr\u1ea3 v\u1ec1 cho b\u1ea1n m\u1ed9t s\u1ed1 c\u1ee5 th\u1ec3 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi v\u1ecb tr\u00ed \u1edf tr\u00ean c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m ROW \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center\"><b>=ROW([reference])<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3, reference l\u00e0 \u0111\u1ed1i s\u1ed1 kh\u00f4ng b\u1eaft bu\u1ed9c, c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng. \u1ede \u0111\u00e2y b\u1ea1n s\u1ebd \u0111i\u1ec1n \u00f4 ho\u1eb7c ph\u1ea1m vi \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 h\u00e0ng c\u1ee7a ch\u00fang.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean, c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu reference l\u00e0 ph\u1ea1m vi \u00f4 v\u00e0 h\u00e0m ROW \u0111\u01b0\u1ee3c nh\u1eadp theo m\u1ea3ng d\u1ecdc. Th\u00ec h\u00e0m ROW s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a tham chi\u1ebfu d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng d\u1ecdc.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu nh\u01b0 b\u1ea1n b\u1ecf qua kh\u00f4ng nh\u1eadp \u0111\u1ed1i s\u1ed1 reference. N\u00f3 s\u1ebd m\u1eb7c \u0111\u1ecbnh tham chi\u1ebfu l\u00e0 \u00f4 m\u00e0 b\u1ea1n \u0111ang nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m ROW.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Reference kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng tham chi\u1ebfu \u0111\u1ebfn nhi\u1ec1u khu v\u1ef1c. H\u00e0m ROW s\u1ebd kh\u00f4ng cho ra k\u1ebft qu\u1ea3 n\u1ebfu nh\u01b0 b\u1ea1n nh\u1eadp v\u00e0o c\u00e1c h\u00e0ng, c\u00e1c c\u1ed9t kh\u00e1c nhau trong c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng<\/span><b> h\u00e0m ROW trong Excel<\/b><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh th\u1ee9 t\u1ef1 h\u00e0ng c\u1ee7a m\u1ed9t \u00f4\/ph\u1ea1m vi \u00f4 n\u00e0o \u0111\u00f3 ch\u1ec9 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m ROW c\u00f9ng v\u1edbi t\u00ean \u00f4.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12314 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-2-3.jpg\" alt=\"\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-2-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-2-3-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, khi kh\u00f4ng nh\u1eadp reference k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 h\u00e0ng m\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp h\u00e0m ROW. C\u00f2n 2 v\u00ed d\u1ee5 tr\u00ean th\u00ec hi\u1ec7n ra k\u1ebft qu\u1ea3 l\u00e0 h\u00e0ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu. \u00d4 H5 n\u1eb1m \u1edf h\u00e0ng 5 v\u00e0 \u00f4 A120 n\u1eb1m \u1edf h\u00e0ng 120.<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\"><em><strong>H\u00e0m th\u1ed1ng k\u00ea trong Excel<\/strong><\/em><\/a><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_danh_so_thu_tu_thong_qua_ham_ROW\"><\/span><span style=\"font-weight: 400\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 th\u00f4ng qua h\u00e0m ROW\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1:<\/span><\/p>\n<p style=\"text-align: center\"><b>=ROW(A1)<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12312 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-18.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-18.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-18-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/5-18-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Sau \u0111\u00f3, k\u00e9o ph\u1ea7n g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi c\u1ee7a \u00f4 A1 xu\u1ed1ng \u0111\u1ebfn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12310 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-24.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-24.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-24-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-24-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><i><span style=\"font-weight: 400\">L\u01b0u \u00fd:<\/span><\/i><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng <\/span><b>h\u00e0m ROW trong Excel<\/b><span style=\"font-weight: 400\"> \u0111\u1ec3 \u0111\u00e1nh s\u1ed1. Nh\u01b0ng mu\u1ed1n c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c t\u01b0\u0323 \u0111\u00f4\u0323ng ch\u00e8n v\u00e0o khi th\u00eam c\u00e1c h\u00e0ng d\u1eef li\u1ec7u m\u1edbi. H\u00e3y chuy\u1ec3n pha\u0323m vi d\u1eef li\u1ec7u n\u00e0y th\u00e0nh b\u1ea3ng Excel. Khi \u0111\u00f3 c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o cu\u1ed1i b\u1ea3ng se\u0303 \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 theo \u0111u\u0301ng th\u01b0\u0301 t\u1ef1.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Khi \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng h\u00e0m ROW, b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 nh\u1eefng h\u1ea1n ch\u1ebf. Nh\u1eefng s\u1ed1 n\u00e0y ch\u1ec9 \u0111\u01b0\u1ee3c \u0111\u00e1nh th\u1ee9 t\u1ef1 \u0111\u1ebfn ph\u1ea7n m\u00e0 b\u1ea1n k\u00e9o xu\u1ed1ng. Khi b\u1ea1n xu\u1ed1ng d\u00f2ng s\u1ed1 s\u1ebd kh\u00f4ng t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh xu\u1ed1ng theo n\u1eefa. V\u00ec v\u1eady, c\u00e1ch n\u00e0y s\u1ebd kh\u00f4ng linh \u0111\u1ed9ng l\u1eafm v\u1edbi nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111\u00e1nh s\u1ed1 t\u1eeb 1 \u0111\u1ebfn h\u00e0ng tr\u0103m, h\u00e0ng ngh\u00ecn.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 nh\u1eadp c\u00e1c m\u00e3 s\u1ed1 th\u01b0\u0301 t\u1ef1 theo c\u00e1ch ri\u00eang, ch\u0103\u0309ng ha\u0323n nh\u01b0 s\u00f4\u0301 cu\u0309a \u0111\u01a1n \u0111\u0103\u0323t ha\u0300ng. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROW c\u00f9ng v\u1edbi h\u00e0m TEXT. Gi\u1ea3 s\u1eed nh\u01b0 b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u m\u1ed9t danh s\u00e1ch v\u1edbi s\u1ed1 0000-0001. B\u1ea1n ha\u0303y nh\u1eadp c\u00f4ng th\u1ee9c <\/span><b>=TEXT(ROW(A1),&#8221;0000-0001&#8243;)<\/b><span style=\"font-weight: 400\"> trong \u00f4 th\u01b0\u0301 nh\u00e2\u0301t c\u1ee7a pha\u0323m vi b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1. R\u00f4\u0300i k\u00e9o \u0111i\u00ea\u0300u khi\u00ea\u0309n \u0111i\u00ea\u0300n \u0111\u1ebfn cu\u1ed1i pha\u0323m vi.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Phan_biet_ham_ROW_voi_ham_ROWS_va_cach_su_dung_cong_thuc_mang_trong_Excel\"><\/span><span style=\"font-weight: 400\">Ph\u00e2n bi\u1ec7t h\u00e0m ROW v\u1edbi h\u00e0m ROWS v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Phan_biet_ham_ROWS_voi_ham_ROW_trong_Excel\"><\/span><span style=\"font-weight: 400\">Ph\u00e2n bi\u1ec7t h\u00e0m ROWS v\u1edbi h\u00e0m ROW trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m ROWS l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ee7a c\u00e1c h\u00e0ng trong m\u1ed9t tham chi\u1ebfu ho\u1eb7c m\u1ed9t m\u1ea3ng. Trong khi h\u00e0m ROW ch\u1ec9 tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng c\u1ee7a m\u1ed9t tham chi\u1ebfu.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 v\u1eady, h\u00e0m ROWS s\u1ebd c\u00f3 ph\u1ea1m vi tham chi\u1ebfu r\u1ed9ng h\u01a1n <\/span><b>h\u00e0m ROW trong Excel<\/b><span style=\"font-weight: 400\">. V\u00e0 th\u1ef1c ch\u1ea5t, trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m ROW. B\u1ea1n c\u0169ng s\u1ebd c\u1ea7n \u0111\u1ebfn s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a h\u00e0m ROWS. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i s\u1ed1 reference trong h\u00e0m ROW ch\u1ec9 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c theo 2 c\u00e1ch l\u00e0 d\u00e0nh cho 1 \u00f4 ho\u1eb7c 1 ph\u1ea1m vi \u00f4 gi\u1ed1ng nh\u01b0 h\u00ecnh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12313 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-19.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-19.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-19-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-19-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0ng n\u1ebfu b\u1ea1n \u0111\u1ec3 \u00fd k\u1ef9 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 trong c\u00f4ng th\u1ee9c \u0111\u1ea7u ch\u00ednh l\u00e0 h\u00e0ng c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean. T\u1ee9c l\u00e0 c\u0169ng kh\u00f4ng c\u00f3 g\u00ec kh\u00e1c so v\u1edbi khi b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c cho \u00f4 E3. M\u1eb7t kh\u00e1c, b\u1ea1n c\u0169ng kh\u00f4ng th\u1ec3 vi\u1ebft \u0111\u01b0\u1ee3c theo c\u00e1ch: ROW(E3,I3) hay ROW(H3:H9,T3:T9).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">L\u00fac n\u00e0y, b\u1ea1n c\u1ea7n d\u00f9ng \u0111\u1ebfn h\u00e0m ROWS. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c vi\u1ebft l\u00e0:<\/span><\/p>\n<p style=\"text-align: center\"><b>=ROWS(array)\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3, array l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, l\u00e0 m\u1ed9t m\u1ea3ng, c\u00f4ng th\u1ee9c m\u1ea3ng ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn ph\u1ea1m vi \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y s\u1ed1 h\u00e0ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 h\u00e0ng trong ph\u1ea1m vi t\u1eeb \u00f4 A2 \u0111\u1ebfn \u00f4 E11, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp:<\/span><\/p>\n<p style=\"text-align: center\"><b>=ROWS(A2:E11)<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12311 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-21.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-21.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-21-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-21-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 cho ra l\u00e0 10 t\u01b0\u01a1ng \u1ee9ng v\u1edbi 10 h\u00e0ng t\u1eeb A2 cho \u0111\u1ebfn E11.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y ch\u00ednh l\u00e0 c\u00e1ch \u0111\u1ec3 b\u1ea1n th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng c\u00e1c h\u00e0ng c\u00f3 trong m\u1ed9t m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_su_dung_cong_thuc_mang\"><\/span><span style=\"font-weight: 400\">C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 hi\u1ec3u d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng th\u00ec b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c thao t\u00e1c sau \u0111\u00e2y:<\/span><\/p>\n<p><i><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t ph\u1ea1m vi m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y m\u1ea3ng d\u1eef li\u1ec7u.\u00a0<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n Excel tr\u1ea3 v\u1ec1 m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng c\u1ee7a m\u1ea3ng C4:G13. B\u1ea1n s\u1ebd t\u1ea1o m\u1ed9t kh\u00f4ng gian bao g\u1ed3m 10 \u00f4 li\u00ean ti\u1ebfp trong 1 c\u1ed9t \u0111\u1ec3 h\u00e0m ROW tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 cho b\u1ea1n. <\/span><span style=\"font-weight: 400\">V\u1eady c\u00f3 th\u1ec3 ch\u1ecdn 10 \u00f4 li\u00ean ti\u1ebfp t\u1eeb A1 \u0111\u1ebfn A10 trong c\u1ed9t A. Sau \u0111\u00f3, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 A1:<\/span><\/p>\n<p style=\"text-align: center\"><b>=ROW(C4:G13)<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12307 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-5.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-5-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><i><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: X\u00e1c nh\u1eadn \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">Sau b\u01b0\u1edbc nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n <\/span><i><span style=\"font-weight: 400\">Enter<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u1ed1i v\u1edbi m\u00e1y \u0111\u00e3 c\u00f3 s\u1eb5n phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t c\u1ee7a Microsoft 365. Ho\u1eb7c b\u1ea1n ph\u1ea3i nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <\/span><i><span style=\"font-weight: 400\">Ctrl + Shift + Enter<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u1ed1i v\u1edbi m\u00e1y c\u00e0i \u0111\u1eb7t c\u00e1c phi\u00ean c\u00f2n l\u1ea1i. Vi\u1ec7c l\u00e0m n\u00e0y c\u00f3 m\u1ee5c \u0111\u00edch \u0111\u1ec3 x\u00e1c nh\u1eadn s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t, c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng ngay sau khi nh\u1ea5n Enter. C\u00f2n \u0111\u1ed1i v\u1edbi phi\u00ean b\u1ea3n kh\u00e1c, b\u1ea1n s\u1ebd th\u1ea5y 2 d\u1ea5u ngo\u1eb7c nh\u1ecdn \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o ph\u1ea7n \u0111\u1ea7u v\u00e0 ph\u1ea7n cu\u1ed1i c\u00f4ng th\u1ee9c.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c s\u1ed1 th\u1ee9 t\u1ef1 c\u00e1c h\u00e0ng trong m\u1ea3ng g\u1ed1c \u0111\u01b0\u1ee3c \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 trong ph\u1ea1m vi b\u1ea1n v\u1eeba ch\u1ec9 \u0111\u1ecbnh.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12306 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-6.jpg\" alt=\"\" width=\"600\" height=\"300\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-6-400x200.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 n\u00f3i r\u1eb1ng, <\/span><b>h\u00e0m ROW trong Exce<\/b><span style=\"font-weight: 400\">l l\u00e0 h\u00e0m t\u01b0\u01a1ng \u0111\u1ed1i d\u1ec5 \u0111\u1ec3 s\u1eed d\u1ee5ng v\u00e0 c\u0169ng kh\u00f4ng c\u00f3 qu\u00e1 nhi\u1ec1u ki\u1ebfn th\u1ee9c.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00e0 \u0111\u00f3 l\u00e0 t\u1ea5t c\u1ea3 nh\u1eefng ki\u1ebfn th\u1ee9c \u0111i k\u00e8m v\u00ed d\u1ee5 v\u1ec1 <\/span><b>h\u00e0m ROW trong Excel<\/b><span style=\"font-weight: 400\">. Hy v\u1ecdng b\u1ea1n s\u1ebd h\u1ecdc h\u1ecfi \u0111\u01b0\u1ee3c trong b\u00e0i vi\u1ebft v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m n\u00e0y. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam:\u00a0<span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\"><em><strong>C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel<\/strong><\/em><\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>.Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel, h\u1eb3n l\u00e0 b\u1ea1n c\u0169ng t\u1eebng ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn h\u00e0m ROW. V\u00ec n\u00f3 s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian cho b\u1ea1n. Th\u1ebf nh\u01b0ng, n\u1ebfu b\u1ea1n m\u1edbi ch\u1ec9 \u0111ang trong qu\u00e1 tr\u00ecnh &hellip;<\/p>\n","protected":false},"author":26,"featured_media":12308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12298","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel<\/title>\n<meta name=\"description\" content=\"N\u1ebfu b\u1ea1n \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m ROW trong Excel. Th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho b\u1ea1n.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel\" \/>\n<meta property=\"og:description\" content=\"N\u1ebfu b\u1ea1n \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m ROW trong Excel. Th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho b\u1ea1n.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-24T09:32:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel\",\"datePublished\":\"2022-03-24T09:32:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\"},\"wordCount\":1812,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\",\"name\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg\",\"datePublished\":\"2022-03-24T09:32:04+00:00\",\"description\":\"N\u1ebfu b\u1ea1n \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m ROW trong Excel. Th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho b\u1ea1n.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel","description":"N\u1ebfu b\u1ea1n \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m ROW trong Excel. Th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho b\u1ea1n.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel","og_description":"N\u1ebfu b\u1ea1n \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m ROW trong Excel. Th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho b\u1ea1n.\u00a0","og_url":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-24T09:32:04+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel","datePublished":"2022-03-24T09:32:04+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/"},"wordCount":1812,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/","name":"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg","datePublished":"2022-03-24T09:32:04+00:00","description":"N\u1ebfu b\u1ea1n \u0111ang trong qu\u00e1 tr\u00ecnh b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m ROW trong Excel. Th\u00ec b\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch cho b\u1ea1n.\u00a0","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/nhung-kien-thuc-bo-ich-ve-ham-row-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch v\u1ec1 h\u00e0m ROW trong Excel"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-24-400x267.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12298"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12298\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12308"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}