{"id":44717,"date":"2026-08-05T10:00:00","date_gmt":"2026-08-05T03:00:00","guid":{"rendered":"https:\/\/adsplus.vn\/blog\/?p=44717"},"modified":"2026-08-07T09:51:36","modified_gmt":"2026-08-07T02:51:36","slug":"cach-loc-trung-trong-google-sheet-nhanh-chong","status":"publish","type":"post","link":"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong","title":{"rendered":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng"},"content":{"rendered":"\n<p><span style=\"font-weight: 400;\">Khi qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, th\u00f4ng tin b\u1ecb l\u1eb7p l\u1ea1i l\u00e0 \u0111i\u1ec1u kh\u00f3 tr\u00e1nh kh\u1ecfi. Thao t\u00e1c <\/span><b>l\u1ecdc tr\u00f9ng trong Google Sheet<\/b><span style=\"font-weight: 400;\"> s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd tri\u1ec7t \u0111\u1ec3 v\u1ea5n \u0111\u1ec1 n\u00e0y. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c. C\u00e1c s\u1ed1 li\u1ec7u b\u00e1o c\u00e1o c\u0169ng \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c cao. Trong b\u00e0i vi\u1ebft n\u00e0y, <\/span><b>AdsPlus<\/b><span style=\"font-weight: 400;\"> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb.jpg\" alt=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google sheet nhanh ch\u00f3ng\" class=\"wp-image-44718\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h5 class=\"wp-block-heading\"><b>Xem th\u00eam:<\/b><\/h5>\n\n\n\n<ul>\n<li><a href=\"https:\/\/adsplus.vn\/blog\/cach-xem-lich-su-chinh-sua-tren-google-sheet-cuc-chi-tiet\"><span style=\"font-weight: 400;\">C\u00e1ch xem l\u1ecbch s\u1eed ch\u1ec9nh s\u1eeda tr\u00ean Google Sheet c\u1ef1c chi ti\u1ebft<\/span><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/adsplus.vn\/blog\/cach-chuyen-file-excel-len-google-sheets-nhanh-chong-va-de-dang\"><span style=\"font-weight: 400;\">C\u00e1ch chuy\u1ec3n file Excel l\u00ean Google Sheets nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng<\/span><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ai-tool-cho-google-sheet\"><span style=\"font-weight: 400;\">T\u1ed5ng h\u1ee3p c\u00e1c AI tool cho Google Sheet | Adsplus.vn<\/span><\/a><span style=\"font-weight: 400;\">&nbsp;<\/span><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><b>V\u00ec sao c\u1ea7n thao t\u00e1c l\u1ecdc tr\u00f9ng trong Google Sheet?<\/b><\/h2>\n\n\n\n<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c c\u00f9ng c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn, t\u00ecnh tr\u1ea1ng tr\u00f9ng l\u1eb7p d\u1eef li\u1ec7u th\u01b0\u1eddng xuy\u00ean xu\u1ea5t hi\u1ec7n. \u0110i\u1ec1u n\u00e0y tr\u1ef1c ti\u1ebfp l\u00e0m t\u0103ng s\u1ed1 l\u01b0\u1ee3ng th\u1ef1c t\u1ebf, g\u00e2y ra nh\u1eefng sai l\u1ec7ch nghi\u00eam tr\u1ecdng cho m\u1ecdi b\u00e1o c\u00e1o. H\u1eadu qu\u1ea3 l\u00e0 c\u00e1c ph\u00e9p t\u00ednh to\u00e1n t\u1ed5ng h\u1ee3p ho\u1eb7c trung b\u00ecnh c\u1ed9ng c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng c\u00f2n t\u00ednh chu\u1ea9n x\u00e1c.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, nh\u1eefng th\u00f4ng tin d\u01b0 th\u1eeba s\u1ebd l\u00e0m trang t\u00ednh ph\u00ecnh to v\u00e0 ti\u00eau t\u1ed1n r\u1ea5t nhi\u1ec1u dung l\u01b0\u1ee3ng. S\u1ef1 c\u1ed3ng k\u1ec1nh n\u00e0y ch\u1eafc ch\u1eafn l\u00e0m gi\u1ea3m \u0111i \u0111\u00e1ng k\u1ec3 t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd c\u1ee7a to\u00e0n b\u1ed9 h\u1ec7 th\u1ed1ng. \u0110\u1ed3ng th\u1eddi, ng\u01b0\u1eddi d\u00f9ng c\u0169ng g\u1eb7p r\u1ea5t nhi\u1ec1u kh\u00f3 kh\u0103n khi ph\u00e2n bi\u1ec7t d\u1eef li\u1ec7u g\u1ed1c v\u00e0 b\u1ea3n nh\u1eadp \u0111\u00e8.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">Ch\u00ednh v\u00ec v\u1eady, thao t\u00e1c l\u1ecdc tr\u00f9ng trong Google Sheet \u0111\u1ecbnh k\u1ef3 lu\u00f4n l\u00e0 m\u1ed9t y\u00eau c\u1ea7u th\u1eadt s\u1ef1 c\u1ea7n thi\u1ebft. Th\u00f3i quen n\u00e0y s\u1ebd tr\u1ef1c ti\u1ebfp gi\u00fap b\u1ea1n duy tr\u00ec th\u00e0nh c\u00f4ng m\u1ed9t h\u1ec7 th\u1ed1ng d\u1eef li\u1ec7u c\u1ef1c k\u1ef3 s\u1ea1ch s\u1ebd. Nh\u1edd v\u1eady, m\u1ecdi k\u1ebft qu\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n lu\u00f4n \u0111\u1ea1t \u0111\u1ed9 chu\u1ea9n x\u00e1c cao v\u00e0 v\u00f4 c\u00f9ng chuy\u00ean nghi\u1ec7p.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-1.jpg\" alt=\"V\u00ec sao n\u00ean l\u1ecdc tr\u00f9ng d\u1eef li\u1ec7u trong Google Sheet?\" class=\"wp-image-44719\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-1.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-1-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-1-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-1-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-1-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><b>Chi ti\u1ebft 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google sheet c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/b><\/h2>\n\n\n\n<p><span style=\"font-weight: 400;\">T\u00f9y v\u00e0o nhu c\u1ea7u th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng 1 trong 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet d\u01b0\u1edbi \u0111\u00e2y. M\u1ed7i ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec1u s\u1edf h\u1eefu \u01b0u \u0111i\u1ec3m ri\u00eang gi\u00fap b\u1ea1n x\u1eed l\u00fd b\u1ea3ng t\u00ednh nhanh ch\u00f3ng.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><b>Highlight (t\u00f4 m\u00e0u) c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau<\/b><\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m n\u00e0y mang l\u1ea1i t\u00ednh tr\u1ef1c quan r\u1ea5t cao. B\u1ea3ng t\u00ednh s\u1ebd d\u00f9ng m\u00e0u s\u1eafc \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 d\u1eef li\u1ec7u l\u1eb7p l\u1ea1i. Nh\u1edd \u0111\u00f3, b\u1ea1n d\u1ec5 d\u00e0ng ki\u1ec3m tra th\u00f4ng tin tr\u01b0\u1edbc khi quy\u1ebft \u0111\u1ecbnh x\u00f3a.<\/span><\/p>\n\n\n\n<p><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra. Tr\u00ean thanh menu, b\u1ea1n ch\u1ecdn m\u1ee5c <\/span><b>\u0110\u1ecbnh d\u1ea1ng<\/b><span style=\"font-weight: 400;\"> (Format). Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n ch\u1ecdn <\/span><b>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> (Conditional formatting).<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-2.jpg\" alt=\"Highlight (t\u00f4 m\u00e0u) c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau: b\u01b0\u1edbc 1\" class=\"wp-image-44720\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-2.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-2-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-2-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-2-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-2-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> B\u1ea3ng quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng s\u1ebd xu\u1ea5t hi\u1ec7n b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh. T\u1ea1i m\u1ee5c <\/span><b>Quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng<\/b><span style=\"font-weight: 400;\">, b\u1ea1n ch\u1ecdn <\/span><b>C\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh l\u00e0<\/b><span style=\"font-weight: 400;\"> (Custom formula is). B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =COUNTIF(A:A; A1)&gt;1. B\u1ea1n thi\u1ebft l\u1eadp m\u00e0u n\u1ec1n ho\u1eb7c m\u00e0u ch\u1eef \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt \u00f4 tr\u00f9ng. Cu\u1ed1i c\u00f9ng, b\u1ea1n nh\u1ea5n <\/span><b>\u0110\u00e3 xong<\/b><span style=\"font-weight: 400;\"> (Done).<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-3.jpg\" alt=\"Highlight (t\u00f4 m\u00e0u) c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau: b\u01b0\u1edbc 2\" class=\"wp-image-44722\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-3.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-3-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-3-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-3-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-3-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 3: <\/b><span style=\"font-weight: 400;\">B\u1ea1n quan s\u00e1t l\u1ea1i trang t\u00ednh. H\u1ec7 th\u1ed1ng \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng t\u00f4 m\u00e0u c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p. L\u01b0u \u00fd nh\u1ecf: M\u00e1y t\u00ednh d\u00f9ng \u0111\u1ecbnh d\u1ea1ng M\u1ef9 c\u1ea7n \u0111\u1ed5i d\u1ea5u ch\u1ea5m ph\u1ea9y (;) th\u00e0nh d\u1ea5u ph\u1ea9y (,) trong c\u00f4ng th\u1ee9c: =COUNTIF(A:A, A1)&gt;1. B\u1ea1n nh\u1edb thay ch\u1eef A th\u00e0nh t\u00ean c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u th\u1ef1c t\u1ebf.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-4.jpg\" alt=\"Highlight (t\u00f4 m\u00e0u) c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau: b\u01b0\u1edbc 3 l\u1ecdc tr\u00f9ng trong google sheet\" class=\"wp-image-44723\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-4.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-4-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-4-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-4-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-4-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><b>L\u1ecdc l\u1ecdc tr\u00f9ng trong Google Sheet<\/b> <b>b\u1eb1ng h\u00e0m UNIQUE<\/b><\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">H\u00e0m UNIQUE \u0111\u00f3ng vai tr\u00f2 nh\u01b0 m\u1ed9t c\u00f4ng c\u1ee5 tr\u00edch xu\u1ea5t th\u00f4ng tin nhanh ch\u00f3ng. C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet n\u00e0y gi\u00fap b\u1ea1n l\u1ea5y ra c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 \u0111\u1eb7t ch\u00fang v\u00e0o m\u1ed9t v\u00f9ng ho\u00e0n to\u00e0n m\u1edbi.<\/span><\/p>\n\n\n\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">B\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u1ea5t k\u1ef3 n\u1eb1m ngo\u00e0i b\u1ea3ng d\u1eef li\u1ec7u. Ti\u1ebfp theo, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =UNIQUE(A2:B8). (L\u01b0u \u00fd: B\u1ea1n thay A2:B8 b\u1eb1ng v\u00f9ng d\u1eef li\u1ec7u th\u1ef1c t\u1ebf c\u1ee7a file).<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-5.jpg\" alt=\"L\u1ecdc danh s\u00e1ch d\u1eef li\u1ec7u duy nh\u1ea5t b\u1eb1ng h\u00e0m UNIQUE: b\u01b0\u1edbc 1\" class=\"wp-image-44724\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-5.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-5-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-5-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-5-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-5-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n nh\u1ea5n ph\u00edm <\/span><b>Enter<\/b><span style=\"font-weight: 400;\">. H\u1ec7 th\u1ed1ng l\u1eadp t\u1ee9c tr\u1ea3 v\u1ec1 danh s\u00e1ch ch\u1ec9 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng. <\/span><b>L\u01b0u \u00fd nh\u1ecf:<\/b><span style=\"font-weight: 400;\"> Khi copy danh s\u00e1ch n\u00e0y sang v\u1ecb tr\u00ed kh\u00e1c, b\u1ea1n h\u00e3y d\u00e1n d\u01b0\u1edbi d\u1ea1ng <\/span><b>Ch\u1ec9 d\u00e1n gi\u00e1 tr\u1ecb<\/b><span style=\"font-weight: 400;\"> (<\/span><b>Ctrl + Shift + V<\/b><span style=\"font-weight: 400;\">). Thao t\u00e1c n\u00e0y gi\u00fap b\u1ea1n tr\u00e1nh l\u1ed7i nh\u1ea3y t\u1ecda \u0111\u1ed9 c\u00f4ng th\u1ee9c.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-6.jpg\" alt=\"L\u1ecdc danh s\u00e1ch d\u1eef li\u1ec7u duy nh\u1ea5t b\u1eb1ng h\u00e0m UNIQUE: b\u01b0\u1edbc 2 l\u1ecdc tr\u00f9ng trong google sheet\" class=\"wp-image-44725\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-6.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-6-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-6-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-6-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-6-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><b>K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter)<\/b><\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c k\u1ebft h\u1ee3p n\u00e0y mang l\u1ea1i \u0111\u1ed9 linh ho\u1ea1t r\u1ea5t cao. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ee7 \u0111\u1ed9ng gi\u1eef l\u1ea1i gi\u00e1 tr\u1ecb duy nh\u1ea5t (TRUE) ho\u1eb7c ki\u1ec3m tra gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng (FALSE).<\/span><\/p>\n\n\n\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">B\u1ea1n ch\u1ecdn \u00f4 tr\u1ed1ng k\u1ebf b\u00ean h\u00e0ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean. B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =COUNTIF(A:A; A1)=1.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-7.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter): b\u01b0\u1edbc 1\" class=\"wp-image-44726\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-7.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-7-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-7-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-7-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-7-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n nh\u1ea5n ph\u00edm <\/span><b>Enter<\/b><span style=\"font-weight: 400;\">. Sau \u0111\u00f3, b\u1ea1n k\u00e9o g\u00f3c ph\u1ea3i c\u1ee7a \u00f4 n\u00e0y xu\u1ed1ng \u0111\u1ec3 copy c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-8.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter): b\u01b0\u1edbc 2 l\u1ecdc tr\u00f9ng trong google sheet\" class=\"wp-image-44727\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-8.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-8-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-8-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-8-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-8-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 3:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n ch\u00e8n th\u00eam 1 h\u00e0ng tr\u1ed1ng tr\u00ean c\u00f9ng \u0111\u1ec3 l\u00e0m ti\u00eau \u0111\u1ec1 cho b\u1ed9 l\u1ecdc.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-9.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter): b\u01b0\u1edbc 3 l\u1ecdc tr\u00f9ng trong google sheet\" class=\"wp-image-44728\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-9.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-9-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-9-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-9-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-9-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 4:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n b\u00f4i \u0111en h\u00e0ng ti\u00eau \u0111\u1ec1 v\u1eeba t\u1ea1o. B\u1ea1n v\u00e0o tab <\/span><b>D\u1eef li\u1ec7u<\/b><span style=\"font-weight: 400;\"> (Data) r\u1ed3i ch\u1ecdn <\/span><b>T\u1ea1o b\u1ed9 l\u1ecdc<\/b><span style=\"font-weight: 400;\"> (Create a filter).<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/24.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter): b\u01b0\u1edbc 4\" class=\"wp-image-44731\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/24.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/24-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/24-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/24-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/24-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 5:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng ph\u1ec5u l\u1ecdc \u1edf c\u1ed9t c\u00f4ng th\u1ee9c: \u0110\u1ec3 l\u1ea5y d\u1eef li\u1ec7u <\/span><b>kh\u00f4ng tr\u00f9ng<\/b><span style=\"font-weight: 400;\">: B\u1ea1n b\u1ecf ch\u1ecdn FALSE v\u00e0 ch\u1ec9 gi\u1eef TRUE, r\u1ed3i nh\u1ea5n <\/span><b>OK<\/b><span style=\"font-weight: 400;\">. \u0110\u1ec3 xem d\u1eef li\u1ec7u <\/span><b>b\u1ecb tr\u00f9ng<\/b><span style=\"font-weight: 400;\">: B\u1ea1n b\u1ecf ch\u1ecdn TRUE v\u00e0 ch\u1ec9 gi\u1eef FALSE, r\u1ed3i nh\u1ea5n <\/span><b>OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-10-1.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter): b\u01b0\u1edbc 5 l\u1ecdc tr\u00f9ng trong google sheet\" class=\"wp-image-44732\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-10-1.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-10-1-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-10-1-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-10-1-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-10-1-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 6:<\/b><span style=\"font-weight: 400;\"> B\u1ea3ng t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c c\u00e1c k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-11.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m COUNTIF v\u00e0 B\u1ed9 l\u1ecdc (Filter): b\u01b0\u1edbc 6\" class=\"wp-image-44733\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-11.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-11-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-11-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-11-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-11-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n\n\n\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c <\/span><b>l\u1ecdc tr\u00f9ng trong Google Sheet<\/b><span style=\"font-weight: 400;\"> \u0111\u00f3ng vai tr\u00f2 r\u1ea5t quan tr\u1ecdng khi b\u1ea1n qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Thao t\u00e1c n\u00e0y gi\u00fap b\u1ea3ng t\u00ednh lu\u00f4n g\u1ecdn g\u00e0ng v\u00e0 \u0111\u1ea1t \u0111\u1ed9 chu\u1ea9n x\u00e1c cao. B\u1ea1n c\u0169ng ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian khi l\u00e0m b\u00e1o c\u00e1o. <\/span><b>AdsPlus<\/b><span style=\"font-weight: 400;\"> hy v\u1ecdng b\u00e0i vi\u1ebft \u0111\u00e3 gi\u00fap b\u1ea1n n\u1eafm r\u00f5 3 c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n nh\u1ea5t. B\u1ea1n h\u00e3y \u00e1p d\u1ee5ng ngay c\u00e1c ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y nh\u00e9. Ch\u00fac b\u1ea1n thao t\u00e1c th\u00e0nh c\u00f4ng!<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/adsplus.vn\/\"><b><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">Adsplus.vn<\/mark><\/b><\/a><b>&nbsp;<\/b><\/h3>\n\n\n\n<p><i><span style=\"font-weight: 400;\">C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 xem b\u00e0i vi\u1ebft n\u00e0y.<\/span><\/i> <i><span style=\"font-weight: 400;\">H\u00e3y c\u1eadp nh\u1eadt th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u1eeb Adsplus \u0111\u1ec3 bi\u1ebft th\u00eam nh\u1eefng th\u00f4ng tin m\u1edbi nh\u1ea5t v\u1ec1 Marketing.<\/span><\/i> <i><span style=\"font-weight: 400;\">V\u00e0 c\u00e1c Tips ch\u1ea1y qu\u1ea3ng c\u00e1o hi\u1ec7u qu\u1ea3.&nbsp;<\/span><\/i><\/p>\n\n\n\n<ul>\n<li><span style=\"font-weight: 400;\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Tham kh\u1ea3o c\u00e1c kh\u00f3a h\u1ecdc Google Ads, Facebook Ads t\u1ea1i<\/mark><\/span><a href=\"https:\/\/guru.edu.vn\/\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><span style=\"font-weight: 400;\"> <\/span><\/mark><span style=\"font-weight: 400;\">guru.edu.vn<\/span><\/a><\/li>\n\n\n\n<li><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><span style=\"font-weight: 400;\">Tham kh\u1ea3o c\u00e1c g\u00f3i setup t\u00e0i kho\u1ea3n qu\u1ea3ng c\u00e1o Google Ads, Facebook Ads t\u1ea1i<\/span> <\/mark><a href=\"http:\/\/1ad.vn\"><span style=\"font-weight: 400;\">1ad.vn<\/span><\/a><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">C\u1eadp nh\u1eadt tin t\u1ee9c, kinh nghi\u1ec7m Digital Marketing nhanh \u2013 chu\u1ea9n<\/mark><\/span> <a href=\"https:\/\/zalo.me\/g\/jwrtyt321\"><span style=\"font-weight: 400;\">t\u1ea1i \u0111\u00e2y<\/span><\/a><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/07\/cong-dong-adsplus.png\" alt=\"C\u1ed9ng \u0111\u1ed3ng AdsPlus\" class=\"wp-image-44423\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/07\/cong-dong-adsplus.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/07\/cong-dong-adsplus-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/07\/cong-dong-adsplus-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/07\/cong-dong-adsplus-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/07\/cong-dong-adsplus-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Khi qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, th\u00f4ng tin b\u1ecb l\u1eb7p l\u1ea1i l\u00e0 \u0111i\u1ec1u kh\u00f3 tr\u00e1nh kh\u1ecfi. Thao t\u00e1c l\u1ecdc tr\u00f9ng trong Google Sheet s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd tri\u1ec7t \u0111\u1ec3 v\u1ea5n \u0111\u1ec1 n\u00e0y. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c. C\u00e1c s\u1ed1 li\u1ec7u b\u00e1o c\u00e1o c\u0169ng \u0111\u1ea3m [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":44718,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[406,110,921],"tags":[1049],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng<\/title>\n<meta name=\"description\" content=\"M\u00e1ch b\u1ea1n 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet c\u1ef1c nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n gi\u00fap l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng\" \/>\n<meta property=\"og:description\" content=\"M\u00e1ch b\u1ea1n 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet c\u1ef1c nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n gi\u00fap l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong\" \/>\n<meta property=\"og:site_name\" content=\"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/AdsplusVietnam\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-05T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-07T02:51:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"722\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"trinhnt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"trinhnt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong\",\"url\":\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong\",\"name\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng\",\"isPartOf\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/#website\"},\"datePublished\":\"2026-08-05T03:00:00+00:00\",\"dateModified\":\"2026-08-07T02:51:36+00:00\",\"author\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/67543373a794f8256dfcd92002fb0dad\"},\"description\":\"M\u00e1ch b\u1ea1n 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet c\u1ef1c nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n gi\u00fap l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n.\",\"breadcrumb\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/adsplus.vn\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#website\",\"url\":\"https:\/\/adsplus.vn\/blog\/\",\"name\":\"Adsplus Blog\",\"description\":\"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/adsplus.vn\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/67543373a794f8256dfcd92002fb0dad\",\"name\":\"trinhnt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0ade6edbfbc4cd27cbfe4fc0e20c5d46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0ade6edbfbc4cd27cbfe4fc0e20c5d46?s=96&d=mm&r=g\",\"caption\":\"trinhnt\"},\"url\":\"https:\/\/adsplus.vn\/blog\/author\/trinhnt\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng","description":"M\u00e1ch b\u1ea1n 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet c\u1ef1c nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n gi\u00fap l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n.","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:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng","og_description":"M\u00e1ch b\u1ea1n 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet c\u1ef1c nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n gi\u00fap l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n.","og_url":"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong","og_site_name":"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online","article_publisher":"https:\/\/www.facebook.com\/AdsplusVietnam\/","article_published_time":"2026-08-05T03:00:00+00:00","article_modified_time":"2026-08-07T02:51:36+00:00","og_image":[{"width":722,"height":401,"url":"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2026\/08\/cach-loc-trung-trong-google-sheet-nhanh-chong-thumb.jpg","type":"image\/jpeg"}],"author":"trinhnt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"trinhnt","Est. reading time":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong","url":"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong","name":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng","isPartOf":{"@id":"https:\/\/adsplus.vn\/blog\/#website"},"datePublished":"2026-08-05T03:00:00+00:00","dateModified":"2026-08-07T02:51:36+00:00","author":{"@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/67543373a794f8256dfcd92002fb0dad"},"description":"M\u00e1ch b\u1ea1n 3 c\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet c\u1ef1c nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n gi\u00fap l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n.","breadcrumb":{"@id":"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adsplus.vn\/blog\/cach-loc-trung-trong-google-sheet-nhanh-chong#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adsplus.vn\/blog\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet nhanh ch\u00f3ng"}]},{"@type":"WebSite","@id":"https:\/\/adsplus.vn\/blog\/#website","url":"https:\/\/adsplus.vn\/blog\/","name":"Adsplus Blog","description":"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adsplus.vn\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/67543373a794f8256dfcd92002fb0dad","name":"trinhnt","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0ade6edbfbc4cd27cbfe4fc0e20c5d46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0ade6edbfbc4cd27cbfe4fc0e20c5d46?s=96&d=mm&r=g","caption":"trinhnt"},"url":"https:\/\/adsplus.vn\/blog\/author\/trinhnt"}]}},"_links":{"self":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts\/44717"}],"collection":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/comments?post=44717"}],"version-history":[{"count":0,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts\/44717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/media\/44718"}],"wp:attachment":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/media?parent=44717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/categories?post=44717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/tags?post=44717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}