{"id":11706,"date":"2023-11-21T16:09:40","date_gmt":"2023-11-21T09:09:40","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11706"},"modified":"2023-11-23T16:15:16","modified_gmt":"2023-11-23T09:15:16","slug":"ham-offset-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]"},"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;11706&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;S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]&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;\">H\u00e0m Offset l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t d\u00e3y hay m\u1ed9t \u00f4 trong b\u1ea3ng t\u00ednh d\u1ef1a v\u00e0o m\u1ed9t v\u00f9ng tham chi\u1ebfu \u0111\u00e3 c\u00f3 s\u1eb5n. Trong b\u00e0i vi\u1ebft n\u00e0y, h\u00e3y c\u00f9ng teky.edu.vn t\u00ecm hi\u1ec3u h\u00e0m offset trong excel v\u00e0 nh\u1eefng \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m offset. M\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o n\u1ed9i dung b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/span><\/p>\n<p><!--more--><\/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\/ham-offset-trong-excel\/#Ham_OFFSET_dung_de_lam_gi\" >H\u00e0m OFFSET d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Dinh_nghia_ham_offset_la_gi\" >\u0110\u1ecbnh ngh\u0129a h\u00e0m offset l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Muc_dich\" >M\u1ee5c \u0111\u00edch<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Cu_phap_va_mot_so_luu_y_cua_ham_OFFSET_trong_excel\" >C\u00fa ph\u00e1p v\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd c\u1ee7a h\u00e0m OFFSET 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-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Cu_phap_ham_OFFSET_trong_excel\" >C\u00fa ph\u00e1p h\u00e0m OFFSET trong excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Mot_so_luu_y_khi_dung_ham_Offset_trong_excel\" >M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m Offset trong excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Vi_du_ve_cach_dung_ham_offset_trong_excel\" >V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m offset trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Ham_OFFSET_thuong_duoc_ket_hop_voi_ham_nao\" >H\u00e0m OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m n\u00e0o?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Ham_offset_ket_hop_voi_ham_Sum\" >H\u00e0m offset k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Ham_offset_ket_hop_voi_ham_Average_Min_Max\" >H\u00e0m offset k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Average, Min, Max\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#Su_dung_ham_Offset_thay_the_cac_ham_Vlookup_trong_excel\" >S\u1eed d\u1ee5ng h\u00e0m Offset thay th\u1ebf c\u00e1c h\u00e0m Vlookup trong excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_OFFSET_dung_de_lam_gi\"><\/span><span style=\"font-weight: 400;\">H\u00e0m OFFSET d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_nghia_ham_offset_la_gi\"><\/span><span style=\"font-weight: 400;\">\u0110\u1ecbnh ngh\u0129a h\u00e0m offset l\u00e0 g\u00ec?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m offset trong excel l\u00e0 h\u00e0m cho ph\u00e9p tr\u1ea3 v\u1ec1 ph\u1ea1m vi \u00f4 ho\u1eb7c m\u1ed9t \u00f4 l\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t v\u00e0 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh t\u1eeb m\u1ed9t ph\u1ea1m vi \u00f4 ho\u1eb7c m\u1ed9t \u00f4.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Muc_dich\"><\/span><span style=\"font-weight: 400;\">M\u1ee5c \u0111\u00edch<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m offset excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi m\u1ee5c \u0111\u00edch.<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Ti\u1ebft ki\u1ec7m th\u1eddi gian cho ng\u01b0\u1eddi d\u00f9ng trong vi\u1ec7c t\u00ednh to\u00e1n b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t \u00f4.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c khi k\u1ebft h\u1ee3p h\u00e0m offset v\u1edbi c\u00e1c h\u00e0m kh\u00e1c.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Gi\u00fap b\u1ea1n tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p h\u01a1n, bi\u1ebft s\u1eed d\u1ee5ng h\u00e0m offset n\u00f3i ri\u00eang v\u00e0 c\u00e1c h\u00e0m excel kh\u00e1c n\u00f3i chung, gi\u00fap b\u1ea1n c\u00f3 c\u01a1 h\u1ed9i th\u0103ng ti\u1ebfn trong c\u00f4ng vi\u1ec7c.<\/span><\/li>\n<\/ul>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/ham-sumifs-trong-excel\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16185335},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> T\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m sumifs trong excel? C\u00e1ch d\u00f9ng, nh\u1eefng \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd?<\/span><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_va_mot_so_luu_y_cua_ham_OFFSET_trong_excel\"><\/span><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p v\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd c\u1ee7a h\u00e0m OFFSET trong excel?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_ham_OFFSET_trong_excel\"><\/span><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p h\u00e0m <\/span><span style=\"font-weight: 400;\">OFFSET<\/span><span style=\"font-weight: 400;\"> trong excel?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>=OFFSET<\/b><span style=\"font-weight: 400;\">(reference, rows, cols, [height], [width]<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hay: <\/span><b>=OFFSET <\/b><span style=\"font-weight: 400;\">(tham chi\u1ebfu, h\u00e0ng, cols, chi\u1ec1u cao, chi\u1ec1u r\u1ed9ng).<\/span><\/p>\n<p><b>Trong \u0111\u00f3:\u00a0<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Reference:<\/b><span style=\"font-weight: 400;\"> \u0110\u01b0\u1ee3c xem l\u00e0 v\u00f9ng c\u01a1 s\u1edf tham chi\u1ebfu \u0111\u1ec3 t\u1ea1o ra v\u00f9ng tham chi\u1ebfu m\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Rows:<\/b><span style=\"font-weight: 400;\"> S\u1ed1 d\u00f2ng b\u00ean d\u01b0\u1edbi b\u00ean tr\u00ean ho\u1eb7c reference, t\u00ednh t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a reference \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Cols: <\/b><span style=\"font-weight: 400;\">L\u00e0 s\u1ed1 c\u1ed9t b\u00ean ph\u1ea3i ho\u1eb7c b\u00ean tr\u00e1i c\u1ee7a reference, t\u00ednh t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a reference \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Height: <\/b><span style=\"font-weight: 400;\">S\u1ed1 l\u01b0\u1ee3ng d\u00f2ng c\u1ee7a v\u00f9ng tham chi\u1ebfu c\u1ea7n \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Width:<\/b><span style=\"font-weight: 400;\"> S\u1ed1 c\u1ed9t c\u1ee7a v\u00f9ng tham chi\u1ebfu c\u1ea7n \u0111\u01b0\u1ee3c\u00a0 tr\u1ea3 v\u1ec1 (Width ph\u1ea3i lu\u00f4n l\u00e0 s\u1ed1 d\u01b0\u01a1ng).<\/span><\/li>\n<\/ul>\n<p><b>L\u01b0u \u00fd:<\/b><span style=\"font-weight: 400;\"> 3 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, c\u00f2n 2 c\u00e1i sau th\u00ec kh\u00f4ng b\u1eaft bu\u1ed9c. T\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c c\u00f4ng th\u1ee9c <a href=\"https:\/\/www.microsoft.com\/vi-vn\/microsoft-365\/excel\" rel=\"nofollow noreferrer\">Excel<\/a> kh\u00e1c ho\u1eb7c l\u00e0 c\u00e1c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_dung_ham_Offset_trong_excel\"><\/span><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m Offset trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u00ea\u0301u \u0111\u00f4\u0301i s\u00f4\u0301 c\u00f4\u0323t v\u00e0 s\u1ed1 ha\u0300ng la\u0300m cho vu\u0300ng tham chi\u00ea\u0301u tra\u0309 v\u00ea\u0300, v\u01b0\u01a1\u0323t qu\u00e1 ngoa\u0300i \u0111\u01b0\u01a1\u0300ng bi\u00ean cu\u0309a trang ti\u0301nh L\u00fac n\u00e0y, ha\u0300m OFFSET s\u1ebd tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 l\u00f4\u0303i <\/span><b>#REF! .<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u00ea\u0301u \u0111\u00f4\u0301i s\u00f4\u0301 \u0111\u00f4\u0323 r\u00f4\u0323ng v\u00e0 chi\u00ea\u0300u cao \u0111\u01b0\u01a1\u0323c bo\u0309 qua, thi\u0300 no\u0301 \u0111\u01b0\u01a1\u0323c gia\u0309 \u0111i\u0323nh co\u0301 cu\u0300ng \u0111\u00f4\u0323 r\u00f4\u0323ng\u00a0 va\u0300 chi\u00ea\u0300u cao v\u01a1\u0301i vu\u0300ng tham chi\u00ea\u0301u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu c\u00e1c \u0111\u1ed1i s\u1ed1\u00a0 chi\u00ea\u0300u cao v\u00e0 \u0111\u00f4\u0323 r\u00f4\u0323ng &gt;1 ngh\u0129a l\u00e0 h\u00e0m ph\u1ea3i tr\u1ea3 v\u1ec1 nhi\u1ec1u h\u01a1n 1 \u00f4 th\u00ec l\u00fac n\u00e0y, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng h\u00e0m OFFSET n\u1ebfu kh\u00f4ng s\u1ebd tr\u1ea3 v\u1ec1 gia\u0301 tri\u0323 l\u1ed7i <\/span><b>#VALUE!<\/b><b>.<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m OFFSET kh\u00f4ng l\u00e0m thay \u0111\u1ed5i hay di chuy\u1ec3n hay b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o \u0111\u01b0\u1ee3c ch\u1ecdn b\u1edfi v\u00ec h\u00e0m\u00a0 OFFSET ch\u1ec9 tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi c\u00e1c m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c c\u1ea7n \u0111\u1ebfn m\u1ed9t \u0111\u1ed1i s\u1ed1 tham chi\u1ebfu.<\/span><\/li>\n<\/ul>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/hinh-nen-powerpoint-dep\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot; H\u01b0\u1edbng d\u1eabn t\u1ea1o h\u00ecnh n\u1ec1n Powerpoint \u0111\u1eb9p cho b\u00e0i thuy\u1ebft tr\u00ecnh&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\"> H\u01b0\u1edbng d\u1eabn t\u1ea1o h\u00ecnh n\u1ec1n Powerpoint \u0111\u1eb9p cho b\u00e0i thuy\u1ebft tr\u00ecnh<\/span><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_ve_cach_dung_ham_offset_trong_excel\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m offset trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows v\u1edbi phi\u00ean b\u1ea3n Excel 2007, 2010, 2013, 2016,2019 B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 tr\u00ean h\u1ec7 \u0111i\u1ec1u h\u00e0nh MacOS.\u00a0<\/span><\/p>\n<p><span style=\"text-decoration: underline;\"><b>V\u00ed d\u1ee5\u00a0<\/b><\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u00ednh doanh thu b\u00e1n \u0111\u01b0\u1ee3c c\u1ee7a nh\u00e2n vi\u00ean L\u00ea Th\u1ecb Ng\u1ecdc Th\u1ea3o, d\u1ef1a v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00e3 cho.<\/span><\/p>\n<p>B\u01b0\u1edbc 1:<span style=\"font-weight: 400;\"> D\u1ef1a v\u00e0o b\u1ea3ng Excel, ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau <\/span><b>=OFFSET(B3,3,2) <\/b><span style=\"font-weight: 400;\">v\u00e0o 1 \u00f4 tham chi\u1ebfu m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<p>B\u01b0\u1edbc 2: <span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, c\u00e1c b\u1ea1n nh\u1ea5n ph\u00edm <\/span><b>Enter<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_11749\" aria-describedby=\"caption-attachment-11749\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11749 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-1-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11749\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ham_OFFSET_thuong_duoc_ket_hop_voi_ham_nao\"><\/span><span style=\"font-weight: 400;\">H\u00e0m OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m n\u00e0o?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m offset c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c. Ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Sum, Average, Min, Max,\u00a0 \u2026 m\u1ee5c \u0111\u00edch \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/span><\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam : <a href=\"https:\/\/teky.edu.vn\/blog\/cac-trang-web-tai-powerpoint-mien-phi\/\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;C\u00e1c trang web t\u1ea3i Powerpoint mi\u1ec5n ph\u00ed \u2013 ti\u1ebft ki\u1ec7m th\u1eddi gian hi\u1ec7u qu\u1ea3&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:12706,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16185335},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:12829895}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;10&quot;:2,&quot;11&quot;:4,&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:11}\">C\u00e1c trang web t\u1ea3i Powerpoint mi\u1ec5n ph\u00ed \u2013 ti\u1ebft ki\u1ec7m th\u1eddi gian hi\u1ec7u qu\u1ea3<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_offset_ket_hop_voi_ham_Sum\"><\/span><span style=\"font-weight: 400;\">H\u00e0m offset k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Sum<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>V\u00ed d\u1ee5:<\/b><span style=\"font-weight: 400;\"> T\u00ednh <\/span><span style=\"font-weight: 400;\">t\u1ed5ng doanh thu b\u00e1n \u0111\u01b0\u1ee3c c\u1ee7a nh\u00e2n vi\u00ean L\u00ea Cao b\u1eb1ng c\u1ee7a c\u1ed9t D theo b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p>B\u01b0\u1edbc 1:<span style=\"font-weight: 400;\"> Trong b\u1ea3ng d\u1eef li\u1ec7u t\u00ednh Excel, ch\u00fang ta nh\u1eadp h\u00e0m <\/span><b>=SUM(OFFSET(A3,1,3,5,1))<\/b><span style=\"font-weight: 400;\"> t\u1ea1i \u00f4 tham chi\u1ebfu m\u00e0 ch\u00fang ta mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_11750\" aria-describedby=\"caption-attachment-11750\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11750 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum1-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum1-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum1-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum1-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11750\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel<\/figcaption><\/figure>\n<p><b>Gi\u1ea3i th\u00edch:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>SUM v\u00e0 OFFSET:<\/strong> L\u00e0 c\u00e1c l\u1ec7nh h\u00e0m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>A3<\/b><span style=\"font-weight: 400;\">: \u00d4 tham chi\u1ebfu.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>1<\/b><span style=\"font-weight: 400;\">: S\u1ed1 h\u00e0ng di chuy\u1ec3n xu\u1ed1ng, t\u00ednh b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 tham chi\u1ebfu A3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>3<\/b><span style=\"font-weight: 400;\">: L\u00e0 s\u1ed1 c\u1ed9t \u0111\u01b0\u1ee3c di chuy\u1ec3n sang ph\u1ea3i, t\u00ednh b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 tham chi\u1ebfu A3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>5<\/b><span style=\"font-weight: 400;\">: L\u00e0 t\u1ed5ng s\u1ed1 h\u00e0ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u00ednh k\u1ebft qu\u1ea3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>1<\/b><span style=\"font-weight: 400;\">: L\u00e0 t\u1ed5ng s\u1ed1 c\u1ed9t \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u00ednh k\u1ebft qu\u1ea3.<\/span><\/li>\n<\/ul>\n<p>B\u01b0\u1edbc 2: <span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_11755\" aria-describedby=\"caption-attachment-11755\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11755 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum2-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum2-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum2-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/sum2-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11755\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ham_offset_ket_hop_voi_ham_Average_Min_Max\"><\/span><span style=\"font-weight: 400;\">H\u00e0m offset k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Average, Min, Max\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>V\u00ed d\u1ee5: <\/b><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m Average v\u1edbi offset \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh v\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng.<\/span><\/p>\n<p>B\u01b0\u1edbc 1: <span style=\"font-weight: 400;\">T\u1ea1i \u00f4 E5, b\u1ea1n nh\u1eadp h\u00e0m <\/span><b>=AVERAGE(OFFSET(B1,COUNT(B:B)-E2+1,0,E2,1)).<\/b><\/p>\n<figure id=\"attachment_11752\" aria-describedby=\"caption-attachment-11752\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11752 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave1-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave1-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave1-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave1-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11752\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel<\/figcaption><\/figure>\n<p>B\u01b0\u1edbc 2: <span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, c\u00e1c b\u1ea1n nh\u1ea5n ph\u00edm <\/span><b>Enter<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_11753\" aria-describedby=\"caption-attachment-11753\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11753 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave2-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave2-1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave2-1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ave2-1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11753\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1ch t\u00ednh ti\u1ec1n th\u01b0\u1edfng cho N th\u00e1ng trong b\u1ea3ng t\u00ednh tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh cho N tu\u1ea7n, N ng\u00e0y ho\u1eb7c N n\u0103m cu\u1ed1i c\u00f9ng. B\u00ean c\u1ea1nh \u0111\u00f3, c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00ecm c\u00e1c nh\u1ecf nh\u1ea5t ho\u1eb7c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t l\u1ed3ng gh\u00e9p h\u00e0m offset trong b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong b\u1ea3ng: <\/span><b>=MAX(OFFSET(B1,COUNT(B:B)-E2+1,0,E2,1)).<\/b><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t trong b\u1ea3ng: <\/span><b>=MIN(OFFSET(B1,COUNT(B:B)-E2+1,0,E2,1))<\/b><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_Offset_thay_the_cac_ham_Vlookup_trong_excel\"><\/span><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m Offset thay th\u1ebf c\u00e1c h\u00e0m Vlookup trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>V\u00ed d\u1ee5: <\/b><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m Vlookup v\u1edbi offset \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m offset v\u1edbi h\u00e0m Vlookup.<\/span><\/p>\n<p>B\u01b0\u1edbc 1: <span style=\"font-weight: 400;\">T\u1ea1i \u00f4 B2, c\u00e1c b\u1ea1n h\u00e3y nh\u1eadp h\u00e0m <\/span><b>=VLOOKUP(B1,A5:B11,2,FALSE)<\/b><span style=\"font-weight: 400;\"> v\u00e0o \u00f4 tham chi\u1ebfu mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m offset thay h\u00e0m Vlookup \u0111\u1ec3 tra c\u1ee9u d\u1eef li\u1ec7u b\u00ean tr\u00e1i trong file Excel. Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m Vlookup ch\u1ec9 c\u00f3 kh\u1ea3 n\u0103ng tr\u1ea3 l\u1ea1i m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh \u1edf b\u00ean ph\u1ea3i c\u1ed9t tra c\u1ee9u, \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u1ea1n ch\u1ebf l\u1edbn nh\u1ea5t c\u1ee7a h\u00e0m Vlookup, n\u00f3 kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng d\u00f2 \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i c\u1ee7a n\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00fang ta ti\u1ebfp t\u1ee5c \u00e1p d\u1ee5ng v\u00ed d\u1ee5 tr\u00ean cho b\u1ea3ng ti\u1ec1n th\u01b0\u1edfng theo th\u00e1ng. N\u1ebfu b\u1ea1n ch\u1ec9 c\u1ea7n t\u00ecm ki\u1ebfm s\u1ed1 ti\u1ec1n th\u01b0\u1edfng c\u1ee7a m\u1ed9t th\u00e1ng n\u00e0o \u0111\u00f3, \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m <a href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\">Vlookup<\/a> c\u01a1 b\u1ea3n r\u1ea5t \u0111\u01a1n gi\u1ea3n.<\/span><\/p>\n<p><b>=VLOOKUP(B10,A5:B11,2,FALSE)<\/b><\/p>\n<figure id=\"attachment_11754\" aria-describedby=\"caption-attachment-11754\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11754 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Vlo1.png\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Vlo1.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Vlo1-400x267.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Vlo1-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11754\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m offset trong excel<\/figcaption><\/figure>\n<p>B\u01b0\u1edbc 2: <span style=\"font-weight: 400;\">Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, c\u00e1c b\u1ea1n nh\u1ea5n ph\u00edm <\/span><b>Enter<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hy v\u1ecdng v\u1edbi n\u1ed9i m\u00e0 teky.edu.vn \u0111\u00e3 chia s\u1ebb v\u00e0 h\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m offset trong excel. Gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y, \u0111\u1ed3ng th\u1eddi \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 trong h\u1ecdc t\u1eadp m\u1ed9t c\u00e1ch. Ch\u00fac c\u00e1c b\u1ea1n ng\u00e0y c\u00e0ng th\u00e0nh th\u1ea1o excel h\u01a1n, \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c t\u1ed1t h\u01a1n nh\u00e9.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Offset l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t d\u00e3y hay m\u1ed9t \u00f4 trong b\u1ea3ng t\u00ednh d\u1ef1a v\u00e0o m\u1ed9t v\u00f9ng tham chi\u1ebfu \u0111\u00e3 c\u00f3 s\u1eb5n. Trong b\u00e0i vi\u1ebft n\u00e0y, h\u00e3y c\u00f9ng teky.edu.vn t\u00ecm hi\u1ec3u h\u00e0m offset trong excel v\u00e0 nh\u1eefng \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11757,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[2,173],"tags":[],"class_list":["post-11706","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-cong-nghe","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>S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m offset \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh trong excel b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a. N\u1ebfu ch\u01b0a h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\" \/>\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\/ham-offset-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m offset \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh trong excel b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a. N\u1ebfu ch\u01b0a h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-offset-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=\"2023-11-21T09:09:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-23T09:15:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png\" \/>\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\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\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=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 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\/ham-offset-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]\",\"datePublished\":\"2023-11-21T09:09:40+00:00\",\"dateModified\":\"2023-11-23T09:15:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\"},\"wordCount\":1977,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png\",\"articleSection\":[\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\",\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\",\"name\":\"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png\",\"datePublished\":\"2023-11-21T09:09:40+00:00\",\"dateModified\":\"2023-11-23T09:15:16+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m offset \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh trong excel b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a. N\u1ebfu ch\u01b0a h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png\",\"width\":600,\"height\":400,\"caption\":\"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt\",\"item\":\"https:\/\/teky.edu.vn\/blog\/tin-cong-nghe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]\"}]},{\"@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\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a","description":"S\u1eed d\u1ee5ng h\u00e0m offset \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh trong excel b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a. N\u1ebfu ch\u01b0a h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","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\/ham-offset-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a","og_description":"S\u1eed d\u1ee5ng h\u00e0m offset \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh trong excel b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a. N\u1ebfu ch\u01b0a h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-offset-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":"2023-11-21T09:09:40+00:00","article_modified_time":"2023-11-23T09:15:16+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]","datePublished":"2023-11-21T09:09:40+00:00","dateModified":"2023-11-23T09:15:16+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/"},"wordCount":1977,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png","articleSection":["C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt","T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/","name":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png","datePublished":"2023-11-21T09:09:40+00:00","dateModified":"2023-11-23T09:15:16+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m offset \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh trong excel b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a. N\u1ebfu ch\u01b0a h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua.png","width":600,"height":400,"caption":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-offset-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"C\u00f4ng ngh\u1ec7 - Th\u1ee7 Thu\u1eadt","item":"https:\/\/teky.edu.vn\/blog\/tin-cong-nghe\/"},{"@type":"ListItem","position":2,"name":"S\u1eed d\u1ee5ng h\u00e0m offset trong excel \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u [b\u1ea1n \u0111\u00e3 bi\u1ebft ch\u01b0a]"}]},{"@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\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Su-dung-ham-offset-trong-excel-de-tham-chieu-du-lieu-ban-da-biet-chua-400x267.png","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11706","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11706"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11706\/revisions"}],"predecessor-version":[{"id":23661,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11706\/revisions\/23661"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11757"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}