{"id":502522,"date":"2025-10-29T09:18:48","date_gmt":"2025-10-29T02:18:48","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=502522"},"modified":"2025-10-29T09:18:48","modified_gmt":"2025-10-29T02:18:48","slug":"ham-offset","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/","title":{"rendered":"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m OFFSET l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m quan tr\u1ecdng trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng tham chi\u1ebfu \u0111\u1ebfn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh s\u1eb5n. V\u1edbi kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt ph\u1ea1m vi khi d\u1eef li\u1ec7u thay \u0111\u1ed5i, h\u00e0m OFFSET \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong vi\u1ec7c t\u00ednh to\u00e1n, t\u1ea1o b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch d\u00f9ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u nh\u1ea5t.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m OFFSET l\u00e0 g\u00ec?<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET trong Excel l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t v\u00f9ng tham chi\u1ebfu d\u1ef1a tr\u00ean v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc, gi\u00fap ng\u01b0\u1eddi d\u00f9ng linh ho\u1ea1t h\u01a1n khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u. N\u00f3i m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u, h\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n l\u1ea5y gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t nh\u00f3m \u00f4 b\u1eb1ng c\u00e1ch d\u1ecbch chuy\u1ec3n t\u1eeb \u0111i\u1ec3m xu\u1ea5t ph\u00e1t theo s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng c\u1ee5 n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong vi\u1ec7c x\u1eed l\u00fd c\u1ea3 c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u nh\u1ecf l\u1eabn c\u00e1c b\u1ea3ng c\u00f3 c\u1ea5u tr\u00fac ph\u1ee9c t\u1ea1p, nh\u1edd kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng. Ch\u1ec9 trong v\u00e0i ph\u1ea7n c\u1ee7a m\u1ed9t gi\u00e2y, OFFSET c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00e0 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, gi\u00fap ti\u1ebft ki\u1ec7m \u0111\u00e1ng k\u1ec3 th\u1eddi gian thao t\u00e1c v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-502524 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-1.jpg\" alt=\"ham-offset-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m OFFSET<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t c\u1ee7a h\u00e0m l\u00e0: =OFFSET(reference, rows, cols, [height], [width])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET gi\u00fap b\u1ea1n t\u1ea1o ra m\u1ed9t v\u00f9ng tham chi\u1ebfu \u0111\u1ed9ng d\u1ef1a tr\u00ean v\u1ecb tr\u00ed ban \u0111\u1ea7u (reference) v\u00e0 s\u1ed1 h\u00e0ng, s\u1ed1 c\u1ed9t c\u1ea7n d\u1ecbch chuy\u1ec3n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch c\u00e1c tham s\u1ed1 trong h\u00e0m OFFSET nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Reference: L\u00e0 v\u1ecb tr\u00ed \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u g\u1ed1c \u2013 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3. \u0110\u00e2y l\u00e0 \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u \u0111\u1ec3 Excel x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u00f9ng c\u1ea7n tr\u1ea3 v\u1ec1. V\u00f9ng tham chi\u1ebfu n\u00e0y ph\u1ea3i li\u00ean t\u1ee5c, kh\u00f4ng \u0111\u01b0\u1ee3c r\u1eddi r\u1ea1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Rows: X\u00e1c \u0111\u1ecbnh s\u1ed1 h\u00e0ng c\u1ea7n di chuy\u1ec3n t\u1eeb \u00f4 tham chi\u1ebfu ban \u0111\u1ea7u. N\u1ebfu nh\u1eadp s\u1ed1 d\u01b0\u01a1ng, h\u00e0m s\u1ebd di chuy\u1ec3n xu\u1ed1ng; n\u1ebfu nh\u1eadp s\u1ed1 \u00e2m, h\u00e0m s\u1ebd di chuy\u1ec3n l\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cols: X\u00e1c \u0111\u1ecbnh s\u1ed1 c\u1ed9t c\u1ea7n di chuy\u1ec3n t\u1eeb \u00f4 tham chi\u1ebfu ban \u0111\u1ea7u. T\u01b0\u01a1ng t\u1ef1, gi\u00e1 tr\u1ecb d\u01b0\u01a1ng di chuy\u1ec3n sang ph\u1ea3i v\u00e0 gi\u00e1 tr\u1ecb \u00e2m di chuy\u1ec3n sang tr\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Height (t\u00f9y ch\u1ecdn): D\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 h\u00e0ng m\u00e0 v\u00f9ng k\u1ebft qu\u1ea3 bao g\u1ed3m. N\u1ebfu b\u1ecf qua, Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh chi\u1ec1u cao b\u1eb1ng v\u1edbi v\u00f9ng tham chi\u1ebfu ban \u0111\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Width (t\u00f9y ch\u1ecdn): D\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 c\u1ed9t m\u00e0 v\u00f9ng k\u1ebft qu\u1ea3 bao g\u1ed3m. N\u1ebfu kh\u00f4ng \u0111i\u1ec1n, chi\u1ec1u r\u1ed9ng s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean nh\u01b0 \u00f4 ho\u1eb7c v\u00f9ng tham chi\u1ebfu g\u1ed1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n tham chi\u1ebfu \u0111\u1ed9ng \u0111\u1ebfn d\u1eef li\u1ec7u thay \u0111\u1ed5i th\u01b0\u1eddng xuy\u00ean, v\u00ed d\u1ee5 nh\u01b0 trong bi\u1ec3u \u0111\u1ed3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, b\u00e1o c\u00e1o theo ng\u00e0y, ho\u1eb7c c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 th\u00eam d\u00f2ng m\u1edbi li\u00ean t\u1ee5c.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-502525 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-2.jpg\" alt=\"ham-offset-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m OFFSET trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET kh\u00f4ng ch\u1ec9 mang l\u1ea1i s\u1ef1 ti\u1ec7n l\u1ee3i, nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c nh\u01b0 c\u00e1c h\u00e0m th\u00f4ng th\u01b0\u1eddng kh\u00e1c trong Excel, m\u00e0 c\u00f2n s\u1edf h\u1eefu nh\u1eefng \u01b0u \u0111i\u1ec3m n\u1ed5i b\u1eadt gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u1ec5 d\u00e0ng k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET c\u00f3 kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m t\u00ednh to\u00e1n ph\u1ed5 bi\u1ebfn nh\u01b0 SUM, AVERAGE, COUNT,\u2026 gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ed9ng. Nh\u1edd \u0111\u00f3, vi\u1ec7c t\u00ednh t\u1ed5ng, t\u00ednh trung b\u00ecnh hay \u0111\u1ebfm d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng l\u1edbn tr\u1edf n\u00ean t\u1ef1 \u0111\u1ed9ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n r\u1ea5t nhi\u1ec1u.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-502526 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-3.jpg\" alt=\"ham-offset-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n v\u1edbi v\u00f9ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 linh ho\u1ea1t<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng gi\u1ed1ng c\u00e1c h\u00e0m ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng trong ph\u1ea1m vi c\u1ed1 \u0111\u1ecbnh, OFFSET cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng thi\u1ebft l\u1eadp ph\u1ea1m vi d\u1eef li\u1ec7u linh \u0111\u1ed9ng, ngay c\u1ea3 khi b\u1ea3ng t\u00ednh m\u1edf r\u1ed9ng ho\u1eb7c thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc. C\u00e1c v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng ho\u1eb7c thu h\u1eb9p m\u00e0 kh\u00f4ng c\u1ea7n ch\u1ec9nh s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi hai \u01b0u \u0111i\u1ec3m n\u1ed5i b\u1eadt n\u00e0y, h\u00e0m OFFSET \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong ph\u00e2n t\u00edch v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u th\u00f4, gi\u00fap ng\u01b0\u1eddi d\u00f9ng ch\u1ee7 \u0111\u1ed9ng h\u01a1n trong vi\u1ec7c thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh t\u1ed5ng, t\u00ednh trung b\u00ecnh, ho\u1eb7c \u0111\u1ebfm t\u1ea1i b\u1ea5t k\u1ef3 v\u00f9ng d\u1eef li\u1ec7u n\u00e0o mong mu\u1ed1n trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OFFSET c\u01a1 b\u1ea3n k\u00e8m v\u00ed d\u1ee5<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 mu\u1ed1n l\u1ea5y gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t \u00f4 n\u1eb1m c\u00e1ch \u00f4 B3 ba h\u00e0ng xu\u1ed1ng v\u00e0 hai c\u1ed9t sang ph\u1ea3i, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Trong \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c: =OFFSET(B3, 3, 2). C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B3, di chuy\u1ec3n 3 h\u00e0ng xu\u1ed1ng v\u00e0 2 c\u1ed9t sang ph\u1ea3i, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502527 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-4.jpg\" alt=\"ham-offset-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. L\u00fac n\u00e0y, Excel s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh theo c\u00f4ng th\u1ee9c tr\u00ean.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502528 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-5.jpg\" alt=\"ham-offset-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1eb9o: Khi b\u1ea1n th\u00eam ho\u1eb7c b\u1edbt d\u00f2ng, c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u, OFFSET s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00f9ng tham chi\u1ebfu, gi\u00fap d\u1eef li\u1ec7u trong b\u00e1o c\u00e1o ho\u1eb7c bi\u1ec3u \u0111\u1ed3 lu\u00f4n ch\u00ednh x\u00e1c.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c k\u00e8m v\u00ed d\u1ee5<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET ph\u00e1t huy t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh khi k\u1ebft h\u1ee3p c\u00f9ng c\u00e1c h\u00e0m kh\u00e1c trong Excel. S\u1ef1 linh ho\u1ea1t n\u00e0y gi\u00fap c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00f9ng d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong c\u00e1c b\u1ea3ng b\u00e1o c\u00e1o ho\u1eb7c bi\u1ec3u \u0111\u1ed3 thay \u0111\u1ed5i th\u01b0\u1eddng xuy\u00ean.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m OFFSET v\u1edbi h\u00e0m SUM<\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Trong \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb t\u1ed5ng, nh\u1eadp c\u00f4ng th\u1ee9c: =SUM(B2:OFFSET(B9, -1, 0))<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502529 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-6.jpg\" alt=\"ham-offset-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Excel s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 B2 \u0111\u1ebfn \u00f4 n\u1eb1m ngay ph\u00eda tr\u00ean B9.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502531 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-8.jpg\" alt=\"ham-offset-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m OFFSET v\u1edbi c\u00e1c h\u00e0m MAX,\u00a0 AVERAGE, MIN<\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, nh\u1eadp c\u00f4ng th\u1ee9c: =AVERAGE(OFFSET(B1, COUNT(B:B) &#8211; E2 + 1, 0, E2, 1)).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502530 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-7.jpg\" alt=\"ham-offset-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3 trung b\u00ecnh.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502532 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-9.jpg\" alt=\"ham-offset-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: N\u1ebfu mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =MAX(OFFSET(B1, COUNT(B:B) &#8211; E2 + 1, 0, E2, 1)).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502533 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-10.jpg\" alt=\"ham-offset-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong v\u00f9ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502534 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-11.jpg\" alt=\"ham-offset-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: \u0110\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, nh\u1eadp c\u00f4ng th\u1ee9c: =MIN(OFFSET(B1, COUNT(B:B) &#8211; E2 + 1, 0, E2, 1)).<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502535 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-12.jpg\" alt=\"ham-offset-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 6: Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3 nh\u1ecf nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502536 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-13.jpg\" alt=\"ham-offset-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p h\u00e0m OFFSET v\u1edbi h\u00e0m VLOOKUP<\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Trong \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 tra c\u1ee9u, nh\u1eadp c\u00f4ng th\u1ee9c: =VLOOKUP(B1, A5:B11, 2, FALSE)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502537 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-14.jpg\" alt=\"ham-offset-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng. C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap t\u00ecm gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb tham chi\u1ebfu t\u1ea1i \u00f4 B1 v\u00e0 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u \u1edf c\u1ed9t th\u1ee9 hai c\u1ee7a b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502538 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-15.jpg\" alt=\"ham-offset-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eefng \u0111i\u1ec1u l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m OFFSET<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng OFFSET trong Excel, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ch\u00fa \u00fd m\u1ed9t s\u1ed1 nguy\u00ean t\u1eafc \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh l\u1ed7i ph\u00e1t sinh trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd khi \u00e1p d\u1ee5ng h\u00e0m OFFSET, gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t t\u1ed1t h\u01a1n ph\u1ea1m vi d\u1eef li\u1ec7u v\u00e0 duy tr\u00ec \u0111\u1ed9 \u1ed5n \u0111\u1ecbnh cho b\u1ea3ng t\u00ednh:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u1edbi h\u1ea1n ph\u1ea1m vi trang t\u00ednh: N\u1ebfu gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 rows ho\u1eb7c cols khi\u1ebfn v\u00f9ng tham chi\u1ebfu v\u01b0\u1ee3t ra ngo\u00e0i gi\u1edbi h\u1ea1n c\u1ee7a b\u1ea3ng t\u00ednh, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #REF!.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u1eef nguy\u00ean k\u00edch th\u01b0\u1edbc v\u00f9ng g\u1ed1c: Khi b\u1ea1n b\u1ecf qua hai \u0111\u1ed1i s\u1ed1 height v\u00e0 width, v\u00f9ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd m\u1eb7c \u0111\u1ecbnh c\u00f3 c\u00f9ng chi\u1ec1u cao v\u00e0 chi\u1ec1u r\u1ed9ng v\u1edbi v\u00f9ng tham chi\u1ebfu ban \u0111\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng khi c\u1ea7n: Trong tr\u01b0\u1eddng h\u1ee3p c\u00e1c \u0111\u1ed1i s\u1ed1 height v\u00e0 width c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 1, t\u1ee9c l\u00e0 v\u00f9ng tr\u1ea3 v\u1ec1 ch\u1ee9a nhi\u1ec1u \u00f4, b\u1ea1n c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng. N\u1ebfu kh\u00f4ng, Excel s\u1ebd b\u00e1o l\u1ed7i #VALUE!.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 cho height v\u00e0 width: Hai \u0111\u1ed1i s\u1ed1 n\u00e0y ph\u1ea3i l\u00e0 s\u1ed1 d\u01b0\u01a1ng, Excel kh\u00f4ng ch\u1ea5p nh\u1eadn gi\u00e1 tr\u1ecb \u00e2m ho\u1eb7c b\u1eb1ng 0.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00f4ng thay \u0111\u1ed5i d\u1eef li\u1ec7u g\u1ed1c: H\u00e0m OFFSET ch\u1ec9 t\u1ea1o ra m\u1ed9t v\u00f9ng tham chi\u1ebfu t\u1ea1m th\u1eddi, kh\u00f4ng l\u00e0m di chuy\u1ec3n ho\u1eb7c ch\u1ec9nh s\u1eeda b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m kh\u00e1c: OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi c\u00e1c h\u00e0m nh\u01b0 SUM, AVERAGE, COUNTA, ho\u1eb7c MATCH \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00f9ng t\u00ednh to\u00e1n, gi\u00fap b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3 lu\u00f4n hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u m\u1edbi nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502539 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-16.jpg\" alt=\"ham-offset-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m OFFSET trong Excel<\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m OFFSET c\u00f3 l\u00e0m thay \u0111\u1ed5i d\u1eef li\u1ec7u g\u1ed1c trong b\u1ea3ng t\u00ednh kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng. OFFSET ch\u1ec9 t\u1ea1o ra m\u1ed9t v\u00f9ng tham chi\u1ebfu t\u1ea1m th\u1eddi \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u ho\u1eb7c t\u00ednh to\u00e1n, ho\u00e0n to\u00e0n kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn gi\u00e1 tr\u1ecb g\u1ed1c trong c\u00e1c \u00f4 ban \u0111\u1ea7u.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 d\u00f9ng h\u00e0m OFFSET \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3. OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi h\u00e0m COUNTA ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u00ean v\u00f9ng \u0111\u1ec3 t\u1ea1o bi\u1ec3u \u0111\u1ed3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt khi th\u00eam d\u1eef li\u1ec7u m\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502541 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-17.jpg\" alt=\"ham-offset-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ec sao h\u00e0m OFFSET \u0111\u00f4i khi l\u00e0m file Excel ch\u1ea1y ch\u1eadm?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u c\u00f4ng th\u1ee9c OFFSET trong m\u1ed9t b\u1ea3ng l\u1edbn, Excel ph\u1ea3i t\u00ednh to\u00e1n l\u1ea1i li\u00ean t\u1ee5c do h\u00e0m n\u00e0y l\u00e0 h\u00e0m bi\u1ebfn \u0111\u1ed9ng (volatile function), khi\u1ebfn t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd b\u1ecb gi\u1ea3m.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng tr\u00ean c\u00e1c trang t\u00ednh kh\u00e1c nhau kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng tr\u1ef1c ti\u1ebfp. OFFSET ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng trong c\u00f9ng m\u1ed9t trang t\u00ednh. N\u1ebfu mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb trang kh\u00e1c, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p th\u00eam tham chi\u1ebfu t\u00ean trang (v\u00ed d\u1ee5: Sheet2!A1) ho\u1eb7c d\u00f9ng h\u00e0m INDIRECT.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ea1n ch\u1ebf l\u1ed7i #REF khi d\u00f9ng OFFSET?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n n\u00ean ki\u1ec3m tra k\u1ef9 gi\u1edbi h\u1ea1n c\u1ee7a b\u1ea3ng t\u00ednh tr\u01b0\u1edbc khi \u0111\u1eb7t \u0111\u1ed1i s\u1ed1 rows v\u00e0 cols, tr\u00e1nh \u0111\u1ec3 v\u00f9ng tham chi\u1ebfu v\u01b0\u1ee3t ra ngo\u00e0i ph\u1ea1m vi trang t\u00ednh. Vi\u1ec7c c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m tra (IF, MIN, MAX) c\u0169ng gi\u00fap h\u1ea1n ch\u1ebf l\u1ed7i n\u00e0y.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/10\/ham-offset-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-502542 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-18.jpg\" alt=\"ham-offset-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 k\u1ebft h\u1ee3p OFFSET v\u1edbi h\u00e0m IF kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3. Vi\u1ec7c k\u1ebft h\u1ee3p OFFSET v\u1edbi IF gi\u00fap b\u1ea1n t\u1ea1o ra c\u00f4ng th\u1ee9c \u0111\u1ed9ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, v\u00ed d\u1ee5 ch\u1ec9 tr\u1ea3 v\u1ec1 v\u00f9ng d\u1eef li\u1ec7u khi th\u1ecfa m\u00e3n ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh (ch\u1eb3ng h\u1ea1n nh\u01b0 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0).<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u theo chi\u1ec1u ng\u01b0\u1ee3c l\u1ea1i kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp gi\u00e1 tr\u1ecb \u00e2m cho \u0111\u1ed1i s\u1ed1 rows ho\u1eb7c cols \u0111\u1ec3 di chuy\u1ec3n ng\u01b0\u1ee3c l\u00ean tr\u00ean ho\u1eb7c sang tr\u00e1i so v\u1edbi \u00f4 tham chi\u1ebfu ban \u0111\u1ea7u.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m OFFSET kh\u00e1c g\u00ec so v\u1edbi h\u00e0m INDEX?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">OFFSET tr\u1ea3 v\u1ec1 m\u1ed9t v\u00f9ng tham chi\u1ebfu, trong khi INDEX tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t \u00f4 c\u1ee5 th\u1ec3. Ngo\u00e0i ra, OFFSET l\u00e0 h\u00e0m \u0111\u1ed9ng, c\u00f2n INDEX l\u00e0 h\u00e0m t\u0129nh n\u00ean INDEX gi\u00fap file Excel x\u1eed l\u00fd nhanh h\u01a1n khi d\u1eef li\u1ec7u l\u1edbn.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 n\u00ean d\u00f9ng OFFSET trong c\u00e1c file Excel chia s\u1ebb cho nhi\u1ec1u ng\u01b0\u1eddi kh\u00f4ng?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1ec9 n\u00ean d\u00f9ng khi th\u1eadt s\u1ef1 c\u1ea7n thi\u1ebft. OFFSET l\u00e0 h\u00e0m bi\u1ebfn \u0111\u1ed9ng, n\u00ean n\u1ebfu \u00e1p d\u1ee5ng qu\u00e1 nhi\u1ec1u trong file chia s\u1ebb n\u1ed9i b\u1ed9, Excel c\u00f3 th\u1ec3 m\u1ea5t th\u1eddi gian c\u1eadp nh\u1eadt l\u1ea1i c\u00f4ng th\u1ee9c cho t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng, g\u00e2y ch\u1eadm ho\u1eb7c treo file.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 thay th\u1ebf OFFSET n\u1ebfu mu\u1ed1n c\u00f4ng th\u1ee9c \u1ed5n \u0111\u1ecbnh h\u01a1n?<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 INDEX ho\u1eb7c INDIRECT \u0111\u1ec3 thay th\u1ebf trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p. Hai h\u00e0m n\u00e0y cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng \u00edt \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t t\u00ednh to\u00e1n h\u01a1n OFFSET.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Qua nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean, c\u00f3 th\u1ec3 th\u1ea5y h\u00e0m OFFSET kh\u00f4ng ch\u1ec9 gi\u00fap c\u00f4ng th\u1ee9c trong Excel tr\u1edf n\u00ean linh ho\u1ea1t m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 t\u1ed1i \u01b0u vi\u1ec7c x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Khi k\u1ebft h\u1ee3p c\u00f9ng c\u00e1c h\u00e0m nh\u01b0 SUM, AVERAGE hay VLOOKUP, OFFSET mang l\u1ea1i hi\u1ec7u qu\u1ea3 v\u01b0\u1ee3t tr\u1ed9i trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n, th\u1ed1ng k\u00ea v\u00e0 b\u00e1o c\u00e1o. H\u00e3y \u00e1p d\u1ee5ng ngay h\u00e0m n\u00e0y \u0111\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng Excel v\u00e0 l\u00e0m vi\u1ec7c chuy\u00ean nghi\u1ec7p h\u01a1n m\u1ed7i ng\u00e0y.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400; text-align: justify;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\"><span style=\"font-weight: 400;\">C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5<\/span><\/a><\/li>\n<li style=\"font-weight: 400; text-align: justify;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/count\/\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm: COUNT, COUNTA, COUNTIF, COUNTIFS trong Excel<\/span><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m OFFSET l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m quan tr\u1ecdng trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng tham chi\u1ebfu \u0111\u1ebfn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean v\u1ecb tr\u00ed \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh s\u1eb5n. V\u1edbi kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt ph\u1ea1m vi khi d\u1eef li\u1ec7u thay \u0111\u1ed5i, h\u00e0m OFFSET \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng r\u1ed9ng r\u00e3i trong vi\u1ec7c t\u00ednh to\u00e1n, [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":502543,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-502522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u00ecm hi\u1ec3u h\u00e0m OFFSET trong Excel v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u00ecm hi\u1ec3u h\u00e0m OFFSET trong Excel v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-29T02:18:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0790996b964a39ecaeee5b5cabc821b5\"},\"headline\":\"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\",\"datePublished\":\"2025-10-29T02:18:48+00:00\",\"dateModified\":\"2025-10-29T02:18:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\"},\"wordCount\":3123,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\",\"name\":\"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg\",\"datePublished\":\"2025-10-29T02:18:48+00:00\",\"dateModified\":\"2025-10-29T02:18:48+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u00ecm hi\u1ec3u h\u00e0m OFFSET trong Excel v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-offset\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0790996b964a39ecaeee5b5cabc821b5\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/af6ba686f8795ce266c4a6aa2a93aaeb.jpg?ver=1774865095\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/af6ba686f8795ce266c4a6aa2a93aaeb.jpg?ver=1774865095\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u00ecm hi\u1ec3u h\u00e0m OFFSET trong Excel v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u.","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:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u00ecm hi\u1ec3u h\u00e0m OFFSET trong Excel v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-10-29T02:18:48+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0790996b964a39ecaeee5b5cabc821b5"},"headline":"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda","datePublished":"2025-10-29T02:18:48+00:00","dateModified":"2025-10-29T02:18:48+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/"},"wordCount":3123,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/","name":"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg","datePublished":"2025-10-29T02:18:48+00:00","dateModified":"2025-10-29T02:18:48+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u00ecm hi\u1ec3u h\u00e0m OFFSET trong Excel v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/10\/ham-offset.jpg","width":1200,"height":628,"caption":"ham-offset"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-offset\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m OFFSET l\u00e0 g\u00ec? C\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0790996b964a39ecaeee5b5cabc821b5","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/af6ba686f8795ce266c4a6aa2a93aaeb.jpg?ver=1774865095","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/af6ba686f8795ce266c4a6aa2a93aaeb.jpg?ver=1774865095","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/502522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=502522"}],"version-history":[{"count":3,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/502522\/revisions"}],"predecessor-version":[{"id":502960,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/502522\/revisions\/502960"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/502543"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=502522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=502522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=502522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}