{"id":46762,"date":"2021-12-08T14:18:55","date_gmt":"2021-12-08T07:18:55","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=46762"},"modified":"2021-12-28T16:38:27","modified_gmt":"2021-12-28T09:38:27","slug":"ham-address","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-address\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Address \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb \u00f4 \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p>H\u00e0m Address l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong Excel. N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi kh\u00f4ng th\u00e0nh th\u1ea1o v\u1ec1 Excel th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Address m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t th\u00f4ng qua v\u00ed d\u1ee5 c\u1ee5 th\u1ec3.<\/p>\n<figure id=\"attachment_47297\" aria-describedby=\"caption-attachment-47297\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47297 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-5-e1638947512362.jpg\" alt=\"H\u00e0m address \" width=\"600\" height=\"295\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-5-e1638947512362.jpg 600w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-5-e1638947512362-300x148.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-47297\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Address<\/figcaption><\/figure>\n<h2><strong>1. H\u00e0m Address l\u00e0 g\u00ec?<\/strong><\/h2>\n<p><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-address\/\">H\u00e0m Address<\/a><\/strong><\/span> l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu d\u1ef1a tr\u00ean th\u00f4ng tin s\u1ed1 h\u00e0ng v\u1edbi s\u1ed1 c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c cho tr\u01b0\u1edbc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47298 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address.jpg\" alt=\"H\u00e0m adress trong Excel\" width=\"599\" height=\"319\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address.jpg 599w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-300x160.jpg 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/p>\n<p>C\u00f4ng th\u1ee9c:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<strong>=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<p>+ <strong>row_num:<\/strong> S\u1ed1 h\u00e0ng c\u1ee7a \u0111\u1ecba ch\u1ec9 \u00f4 mu\u1ed1n tham chi\u1ebfu. \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c.<br \/>\n+ <strong>column_num:<\/strong> S\u1ed1 c\u1ed9t c\u1ee7a \u0111\u1ecba ch\u1ec9 \u00f4 tham chi\u1ebfu. \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c<br \/>\n+ <strong>abs_num:<\/strong> Ki\u1ec3u tham chi\u1ebfu s\u1ebd tr\u1ea3 v\u1ec1. \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn. K\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t trong nh\u1eefng ki\u1ec3u d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ul>\n<li><strong>1 &#8211;<\/strong>\u00a0m\u1eb7c \u0111\u1ecbnh tr\u1ea3 v\u1ec1 ki\u1ec3u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i. V\u00ed d\u1ee5: $C$1.<\/li>\n<li>2 &#8211; tr\u1ea3 v\u1ec1 ki\u1ec3u h\u00e0ng tuy\u1ec7t \u0111\u1ed1i v\u00e0 c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i. V\u00ed d\u1ee5: 1$<\/li>\n<li>3 &#8211; tr\u1ea3 v\u1ec1 ki\u1ec3u h\u00e0ng t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 c\u1ed9t tuy\u1ec7t \u0111\u1ed1i. V\u00ed d\u1ee5: $C1<\/li>\n<li>4 &#8211; tr\u1ea3 v\u1ec1 ki\u1ec3u tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i. V\u00ed d\u1ee5: C1<\/li>\n<\/ul>\n<p>+ <strong>A1:<\/strong> \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn, ch\u1ec9 r\u00f5 ki\u1ec3u tham chi\u1ebfu \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 l\u00e0 A1 hay R1C1.<\/p>\n<ul>\n<li>N\u1ebfu theo ki\u1ec3u A1, c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh nh\u00e3n theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i v\u00e0 h\u00e0ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh theo th\u1ee9 t\u1ef1 s\u1ed1. C\u00f2n \u0111\u1ed1i v\u1edbi ki\u1ec3u R1C1, c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t s\u1ebd \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1nh nh\u00e3n theo th\u1ee9 t\u1ef1 s\u1ed1.<\/li>\n<li>N\u1ebfu \u0111\u1ed1i s\u1ed1 l\u00e0 TRUE ho\u1eb7c b\u1ecf qua, h\u00e0m Address s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 theo ki\u1ec3u tham chi\u1ebfu A1; n\u1ebfu \u0111\u1ed1i s\u1ed1 l\u00e0 FALSE, h\u00e0m Address s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 theo ki\u1ec3u tham chi\u1ebfu R1C1.<\/li>\n<\/ul>\n<p>+<strong> Sheet_text<\/strong>: \u0110\u00e2y l\u00e0 m\u1ed9t \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn th\u1ec3 hi\u1ec7n t\u00ean trang t\u00ednh \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tham chi\u1ebfu. N\u1ebfu b\u1ecf qua ph\u1ea7n n\u00e0y th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd kh\u00f4ng ch\u1ee9a t\u00ean trang t\u00ednh m\u00e0 ch\u1ec9 tr\u1ea3 v\u1ec1 \u0111\u1ecba ch\u1ec9 \u00f4 tham chi\u1ebfu tr\u00ean trang t\u00ednh hi\u1ec7n t\u1ea1i. C\u00f2n n\u1ebfu th\u00eam \u0111\u1ed1i s\u1ed1 n\u00e0y v\u00e0o trong h\u00e0m, k\u1ebft qu\u1ea3 s\u1ebd \u0111\u00ednh k\u00e8m t\u00ean sheet tham chi\u1ebfu. V\u00ed d\u1ee5: nh\u1eadp c\u00f4ng th\u1ee9c =ADDRESS (1,1,,,&#8221;Sheet1&#8243;), k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 Sheet1!$A$1.<\/p>\n<h2><strong>2. C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Address c\u00f3 v\u00ed d\u1ee5<\/strong><\/h2>\n<p>D\u1ef1a tr\u00ean th\u00f4ng tin s\u1ed1 h\u00e0ng, s\u1ed1 c\u1ed9t \u0111\u00e3 cho tr\u01b0\u1edbc, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo m\u1ed9t trong n\u0103m ki\u1ec3u tham chi\u1ebfu c\u1ee7a h\u00e0m Address. \u0110\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n, h\u00e3y tham kh\u1ea3o nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ul>\n<li><strong>T\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo ki\u1ec3u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/strong><\/li>\n<\/ul>\n<p>N\u1ebfu mu\u1ed1n t\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 A1 theo ki\u1ec3u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i, c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c <strong>=ADDRESS(2,3) =&gt;<\/strong> k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 $C$2 nh\u01b0 h\u00ecnh minh h\u1ecda b\u00ean d\u01b0\u1edbi<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47280 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi.jpg\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m Address\" width=\"750\" height=\"397\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-300x159.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: center;\"><em>Nh\u1eadp c\u00f4ng th\u1ee9c =ADDRESS(2,3) =&gt; k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 $C$2 <\/em><\/p>\n<ul>\n<li><strong>T\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo ki\u1ec3u h\u00e0ng tuy\u1ec7t \u0111\u1ed1i v\u00e0 c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i<\/strong><\/li>\n<\/ul>\n<p>\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c v\u1edbi ki\u1ec3u tham chi\u1ebfu h\u00e0ng tuy\u1ec7t \u0111\u1ed1i v\u00e0 c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i, c\u00e1c b\u1ea1n nh\u1eadp: =ADDRESS(2,3,2) =&gt; k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u00e0 C$2 nh\u01b0 h\u00ecnh minh h\u1ecda b\u00ean d\u01b0\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47281 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-1.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m ADDRESS\" width=\"750\" height=\"408\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-1.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-1-300x163.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: center;\"><em>Nh\u1eadp: =ADDRESS(2,3,2) =&gt; k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 l\u00e0 C$2<\/em><\/p>\n<ul>\n<li><strong>T\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo ki\u1ec3u tham chi\u1ebfu h\u00e0ng tuy\u1ec7t \u0111\u1ed1i; c\u1ed9t t\u01b0\u01a1ng \u0111\u1ed1i R1C1<\/strong><\/li>\n<\/ul>\n<p>\u0110\u1ec3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 theo ki\u1ec3u tham chi\u1ebfu R1C1, c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: =ADDRESS(2,3,2,FALSE) =&gt; k\u1ebft qu\u1ea3 l\u00e0 R2C[3] nh\u01b0 h\u00ecnh minh h\u1ecda<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47282 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-2.jpg\" alt=\"c\u00e1ch d\u00f9ng h\u00e0m address\" width=\"750\" height=\"374\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-2.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-2-300x150.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-2-360x180.jpg 360w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: center;\"><em>Nh\u1eadp: =ADDRESS(2,3,2,FALSE) =&gt; k\u1ebft qu\u1ea3 l\u00e0 R2C[3] <\/em><\/p>\n<ul>\n<li><strong>T\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i \u0111\u1ebfn m\u1ed9t s\u1ed5 l\u00e0m vi\u1ec7c c\u1ee7a trang t\u00ednh c\u1ee5 th\u1ec3<\/strong><\/li>\n<\/ul>\n<p>N\u1ebfu c\u00e1c b\u1ea1n mu\u1ed1n t\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t s\u1ed5 l\u00e0m vi\u1ec7c c\u1ee7a trang t\u00ednh c\u1ee5 th\u1ec3, v\u00ed d\u1ee5 book 1 c\u1ee7a sheet 1, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: =ADDRESS(2,3,1,FALSE,&#8221;[Book1]Sheet1&#8243;) =&gt; k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0: &#8216;[Book1]Sheet1&#8217;!R2C3 nh\u01b0 h\u00ecnh minh h\u1ecda ph\u00eda d\u01b0\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47283 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-3.jpg\" alt=\"v\u00ed d\u1ee5 h\u00e0m address\" width=\"750\" height=\"379\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-3.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-3-300x152.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: center;\"><em>=ADDRESS(2,3,1,FALSE,&#8221;[Book1]Sheet1&#8243;) =&gt; k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1: &#8216;[Book1]Sheet1&#8217;!R2C3<\/em><\/p>\n<ul>\n<li><strong>T\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo ki\u1ec3u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i \u0111\u1ebfn m\u1ed9t trang t\u00ednh c\u1ee5 th\u1ec3<\/strong><\/li>\n<\/ul>\n<p>N\u1ebfu mu\u1ed1n t\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo ki\u1ec3u tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i t\u1ea1i sheet c\u1ee5 th\u1ec3, v\u00ed d\u1ee5 Sheet 1, c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: =ADDRESS(2,3,1,FALSE,&#8221;EXCEL SHEET&#8221;) =&gt; k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 &#8216;EXCEL SHEET&#8217;!R2C3 nh\u01b0 \u1ea3nh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47284 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-4.jpg\" alt=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m address\" width=\"750\" height=\"390\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-4.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/12\/ham-address-la-gi-4-300x156.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: center;\"><em>Nh\u1eadp c\u00f4ng th\u1ee9c: =ADDRESS(2,3,1,FALSE,&#8221;EXCEL SHEET&#8221;) =&gt; k\u1ebft qu\u1ea3 l\u00e0 &#8216;EXCEL SHEET&#8217;!R2C3 <\/em><\/p>\n<p><strong>K\u1ebft lu\u1eadn:<\/strong> Nh\u01b0 v\u1eady, tr\u00ean \u0111\u00e2y, Ben Computer \u0111\u00e3 gi\u1ea3i th\u00edch cho c\u00e1c b\u1ea1n chi ti\u1ebft v\u1ec1 <strong>h\u00e0m Address<\/strong> v\u00e0 c\u00e1ch \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o \u0111\u1ecba ch\u1ec9 \u00f4 theo t\u1eebng ki\u1ec3u tham chi\u1ebfu ph\u00f9 h\u1ee3p. Hy v\u1ecdng b\u00e0i vi\u1ebft \u0111\u00e3 gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u h\u01a1n v\u1ec1 h\u00e0m Address trong Excel. N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 c\u00e2u h\u1ecfi n\u00e0o \u0111\u1eb7t ra cho Ben Computer, h\u00e3y comment xu\u1ed1ng ph\u00eda d\u01b0\u1edbi nh\u00e9!<\/p>\n<blockquote><p><strong><span style=\"color: #000000;\">Tham kh\u1ea3o th\u00eam b\u00e0i vi\u1ebft:\u00a0<\/span><\/strong><\/p>\n<ul>\n<li><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-daverage\/\">C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Daverage \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft<\/a><\/strong><\/span><\/li>\n<li><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-random-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Random trong Excel<\/a><\/strong><\/span><\/li>\n<\/ul>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Address l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m quen thu\u1ed9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong Excel. N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi kh\u00f4ng th\u00e0nh th\u1ea1o v\u1ec1 Excel th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Address m\u1ed9t c\u00e1ch chi ti\u1ebft nh\u1ea5t th\u00f4ng qua [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":47297,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-46762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/46762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=46762"}],"version-history":[{"count":8,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/46762\/revisions"}],"predecessor-version":[{"id":50356,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/46762\/revisions\/50356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/47297"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=46762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=46762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=46762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}