{"id":8728,"date":"2024-12-28T01:31:01","date_gmt":"2024-12-28T01:31:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/28\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet\/"},"modified":"2024-12-28T01:31:01","modified_gmt":"2024-12-28T01:31:01","slug":"huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/28\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n v\u1edbi h\u00e0m Query trong GoogleSheet"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nO_m37Xw#1\">\n<p>H\u00e0m Query l\u00e0 m\u1ed9t h\u00e0m\u00a0\u0111\u1eb7c bi\u1ec7t ch\u1ec9 c\u00f3 trong GoogleSheet (Google Spreadsheet). Tuy nhi\u00ean b\u1ea1n\u00a0\u0111\u00e3 th\u1ef1c s\u1ef1 hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c c\u00e1ch vi\u1ebft h\u00e0m Query v\u1edbi c\u00e1c lo\u1ea1i\u00a0\u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau? N\u1ebfu b\u1ea1n ch\u01b0a n\u1eafm r\u00f5 th\u00ec h\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch vi\u1ebft \u0111i\u1ec1u ki\u1ec7n v\u1edbi h\u00e0m Query trong GoogleSheet nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676f54d4839ff\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet.html#Cau_truc_ham_Query\" title=\"C\u1ea5u tr\u00fac h\u00e0m Query\">C\u1ea5u tr\u00fac h\u00e0m Query<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet.html#Cach_viet_dieu_kien_trong_ham_QUERY\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m QUERY\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m QUERY<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet.html#Cach_viet_dieu_kien_dang_tham_chieu_toi_o_chua_gia_tri_so_hoac_Text_khong_phai_ngay_thang\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb\u00a0s\u1ed1 ho\u1eb7c Text (kh\u00f4ng ph\u1ea3i ng\u00e0y th\u00e1ng)\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb\u00a0s\u1ed1 ho\u1eb7c Text (kh\u00f4ng ph\u1ea3i ng\u00e0y th\u00e1ng)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet.html#Cach_viet_dieu_kien_dang_tham_chieu_toi_o_chua_gia_tri_ngay_thang\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-dieu-kien-voi-ham-query-trong-googlesheet.html#Cach_viet_dieu_kien_truc_tiep_khong_tham_chieu\" title=\"C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp (kh\u00f4ng tham chi\u1ebfu)\">C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp (kh\u00f4ng tham chi\u1ebfu)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_ham_Query\"><\/span>C\u1ea5u tr\u00fac h\u00e0m Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>=<strong><span style=\"color: #ff0000\">QUERY<\/span><\/strong>(B\u1ea3ng d\u1eef li\u1ec7u, \u201cSelect + C\u00e1c c\u1ed9t k\u1ebft qu\u1ea3 c\u1ea7n l\u1ea5y + WHERE + T\u00ean c\u1ed9t k\u00e8m \u0111i\u1ec1u ki\u1ec7n li\u00ean quan\u201d)<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>Query<\/strong> : T\u00ean c\u1ee7a h\u00e0m<\/li>\n<li><strong>B\u1ea3ng d\u1eef li\u1ec7u<\/strong>: b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu t\u1edbi b\u1ea5t k\u1ef3 b\u1ea3ng d\u1eef li\u1ec7u n\u00e0o, nh\u01b0ng\u00a0l\u01b0u\u00a0\u00fd n\u1ebfu ch\u1ecdn c\u1ea3 d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 th\u00ec k\u1ebft qu\u1ea3 c\u0169ng s\u1ebd xu\u1ea5t hi\u1ec7n d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1<\/li>\n<li>C\u1ee5m c\u1ea5u tr\u00fac\u00a0<strong>Select + C\u00e1c c\u1ed9t k\u1ebft qu\u1ea3\u00a0c\u1ea7n l\u1ea5y + WHERE + T\u00ean c\u1ed9t k\u00e8m \u0111i\u1ec1u ki\u1ec7n li\u00ean quan<\/strong>\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 m\u1ed9t c\u1ea5u tr\u00fac nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=QUERY(<span dir=\"auto\">Sheet1!A1:C10<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">\u201cselect A, B, C where A = <span style=\"color: #000000\">date&#8217;\u201d<\/span><\/span><span style=\"color: #000000\">\u00a0<span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span>\u00a0<span class=\" default-formula-text-color\" dir=\"auto\">TEXT<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">$D$2<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\" string \" dir=\"auto\">\u201cyyyy-mm-dd\u201d<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\u00a0<span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span>\u00a0<span class=\" string \" dir=\"auto\">\u201c\u2018\u201d<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/span><\/p>\n<ul>\n<li>B\u1ea3ng d\u1eef li\u1ec7u l\u00e0 v\u00f9ng A1:C10 trong Sheet1<\/li>\n<li>C\u00e1c c\u1ed9t k\u1ebft qu\u1ea3 c\u1ea7n l\u1ea5y l\u00e0 c\u1ed9t A, B, C<\/li>\n<li>Trong\u00a0\u0111\u00f3 l\u1ea5y theo\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111i\u1ec1u ki\u1ec7n ng\u00e0y trong c\u1ed9t A ph\u1ea3i b\u1eb1ng v\u1edbi ng\u00e0y t\u1ea1i\u00a0\u00f4 D2<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_trong_ham_QUERY\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n trong h\u00e0m QUERY<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ec trong th\u1ef1c t\u1ebf c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u th\u01b0\u1eddng r\u1ea5t\u00a0\u0111a d\u1ea1ng, do\u00a0\u0111\u00f3 c\u00e1ch vi\u1ebft h\u00e0m QUERY l\u1ea1i\u00a0\u0111\u1eb7c bi\u1ec7t c\u1ea7n ch\u00fa\u00a0\u00fd ph\u1ea7n vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n. Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch vi\u1ebft m\u1ed9t s\u1ed1 lo\u1ea1i\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_dang_tham_chieu_toi_o_chua_gia_tri_so_hoac_Text_khong_phai_ngay_thang\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb\u00a0s\u1ed1 ho\u1eb7c Text (kh\u00f4ng ph\u1ea3i ng\u00e0y th\u00e1ng)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-813.gif\" title=\"ex101_92019-nho-813\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n + d\u1ea5u nh\u00e1y k\u00e9p + d\u1ea5u &amp; + t\u1ecda\u00a0\u0111\u1ed9\u00a0\u00f4 tham chi\u1ebfu + d\u1ea5u &amp; + d\u1ea5u nh\u00e1y k\u00e9p + d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26990\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3a1ch-vie1babft-tham-chie1babfu-trong-hc3a0m-query.png\" width=\"785\" height=\"355\" title=\"cc3a1ch-vie1babft-tham-chie1babfu-trong-hc3a0m-query\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta vi\u1ebft h\u00e0m Query v\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 ng\u01b0\u1eddi c\u00f3 t\u00ean l\u00e0 An,\u00a0\u0111\u01b0\u1ee3c tham chi\u1ebfu t\u1edbi\u00a0\u00f4 F1<\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 E3 (v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u l\u1ea5y k\u1ebft qu\u1ea3) l\u00e0:<\/p>\n<p style=\"padding-left: 30px\"><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">$A$1:$C$11<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201d\u00a0<span style=\"color: #ff0000\">select A, B, C where A = \u2018\u201d<\/span><\/span><span style=\"color: #ff0000\"><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span dir=\"auto\">$F$1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><\/span><span class=\" string \" dir=\"auto\"><span style=\"color: #ff0000\">\u201c\u2018\u00a0<\/span>\u201c<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/p>\n<p>Trong\u00a0\u0111\u00f3 ph\u1ea7n\u00a0\u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu\u00a0\u0111\u01b0\u1ee3c vi\u1ebft g\u1ed3m:<\/p>\n<p style=\"padding-left: 30px\"><span class=\" string \" dir=\"auto\">A = \u2018\u201d<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span dir=\"auto\">$F$1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span class=\" string \" dir=\"auto\">\u201c\u2018 (C\u1ed9t A c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb trong\u00a0\u00f4 F1)<\/span><\/p>\n<p>Trong\u00a0\u0111\u00f3 ch\u00fang ta kh\u00f4ng vi\u1ebft ch\u1ec9 c\u00f3 A = $F$1, m\u00e0 ph\u1ea3i vi\u1ebft\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 c\u1ea5u tr\u00fac\u00a0\u0111i\u1ec1u ki\u1ec7n trong\u00a0\u00f4 F1 l\u00e0:<\/p>\n<p style=\"padding-left: 30px\"><span class=\" string \" dir=\"auto\"><span style=\"color: #0000ff\">\u2018\u00a0<\/span><span style=\"color: #ff0000\">\u201d\u00a0<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\" style=\"color: #ff00ff\">&amp;\u00a0<\/span><span dir=\"auto\" style=\"color: #008000\">$F$1\u00a0<\/span><span class=\" default-formula-text-color\" dir=\"auto\" style=\"color: #ff00ff\">&amp;\u00a0<\/span><span class=\" string \" dir=\"auto\"><span style=\"color: #ff0000\">\u201d\u00a0<\/span><span style=\"color: #0000ff\">\u2018<\/span><\/span><\/p>\n<p><span style=\"color: #0000ff\">D\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n<\/span> + <span style=\"color: #ff0000\">d\u1ea5u nh\u00e1y k\u00e9p<\/span> +<span style=\"color: #ff00ff\"> d\u1ea5u &amp;<\/span> +\u00a0<span style=\"color: #008000\">\u00f4 F1 (c\u1ed1\u00a0\u0111\u1ecbnh)<\/span> + <span style=\"color: #ff00ff\">d\u1ea5u &amp;<\/span> +<span style=\"color: #ff0000\"> d\u1ea5u nh\u00e1y k\u00e9p<\/span> + <span style=\"color: #0000ff\">d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_dang_tham_chieu_toi_o_chua_gia_tri_ngay_thang\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ng\u00e0y, ch\u00fang ta kh\u00f4ng th\u1ec3 tham chi\u1ebfu tr\u1ef1c ti\u1ebfp t\u1edbi\u00a0\u00f4 ch\u1ee9a\u00a0gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng theo c\u00e1ch tham chi\u1ebfu th\u00f4ng th\u01b0\u1eddng, m\u00e0 ph\u1ea3i chuy\u1ec3n gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng\u00a0\u0111\u00f3 v\u1ec1 d\u1ea1ng Text v\u1edbi c\u1ea5u tr\u00fac ng\u00e0y th\u00e1ng g\u1ed3m N\u0103m-Th\u00e1ng-Ng\u00e0y<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26991\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-query-dieu-kien-thoi-gian.png\" width=\"828\" height=\"355\" title=\"ham-query-dieu-kien-thoi-gian\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta mu\u1ed1n l\u1ea5y Query theo\u00a0\u0111i\u1ec1u ki\u1ec7n gi\u00e1 tr\u1ecb trong c\u1ed9t Ng\u00e0y (c\u1ed9t B) ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (T\u1eeb ng\u00e0y) trong\u00a0\u00f4 F1<\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 E3 (v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u l\u1ea5y k\u1ebft qu\u1ea3) l\u00e0:<\/p>\n<p style=\"padding-left: 30px\"><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">$A$1:$C$11<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201c<span style=\"color: #ff0000\">Select A, B, C where B &gt;= date\u2019 \u201c<\/span><\/span><span style=\"color: #ff0000\"><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span class=\" default-formula-text-color\" dir=\"auto\">Text<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">$F$1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201cyyyy-mm-dd\u201d<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><\/span><span class=\" string \" dir=\"auto\"><span style=\"color: #ff0000\">\u201d \u2018\u00a0<\/span>\u201c<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/p>\n<p>Trong\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ng\u00e0y trong\u00a0\u00f4 F1, ch\u00fang ta ph\u1ea3i l\u00e0m 2 b\u01b0\u1edbc:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: Chuy\u1ec3n v\u1ec1 d\u1ea1ng N\u0103m-Th\u00e1ng-Ng\u00e0y b\u1eb1ng h\u00e0m Text<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><span class=\" default-formula-text-color\" dir=\"auto\">Text<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">$F$1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span>\u00a0<span class=\" string \" dir=\"auto\">\u201cyyyy-mm-dd\u201d<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/p>\n<ul>\n<li>B\u01b0\u1edbc 2: Chuy\u1ec3n v\u1ec1 c\u1ea5u tr\u00fac\u00a0\u0111i\u1ec1u ki\u1ec7n th\u1eddi gian v\u1edbi c\u00fa ph\u00e1p:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">t\u1eeb kh\u00f3a <strong><span style=\"color: #800080\">date<\/span><\/strong> + <span style=\"color: #0000ff\">D\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n<\/span>\u00a0+\u00a0<span style=\"color: #ff0000\">d\u1ea5u nh\u00e1y k\u00e9p<\/span>\u00a0+<span style=\"color: #ff00ff\">\u00a0d\u1ea5u &amp;<\/span>\u00a0+ k\u1ebft qu\u1ea3 chuy\u1ec3n d\u1ea1ng Text N\u0103m-th\u00e1ng-ng\u00e0y<\/p>\n<p style=\"padding-left: 60px\">+ <span style=\"color: #ff00ff\">d\u1ea5u &amp;<\/span>\u00a0+<span style=\"color: #ff0000\">\u00a0d\u1ea5u nh\u00e1y k\u00e9p<\/span>\u00a0+\u00a0<span style=\"color: #0000ff\">d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n<\/span><\/p>\n<p>C\u1ee5 th\u1ec3:<\/p>\n<p style=\"padding-left: 30px\"><span class=\" string \" dir=\"auto\"><span style=\"color: #ff0000\"><span style=\"color: #800080\">date<\/span><span style=\"color: #0000ff\">\u2018<\/span> \u201d\u00a0<\/span><\/span><span style=\"color: #ff0000\"><span class=\" default-formula-text-color\" dir=\"auto\" style=\"color: #ff00ff\">&amp;\u00a0<\/span><span style=\"color: #000000\"><span class=\" default-formula-text-color\" dir=\"auto\">Text<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span dir=\"auto\">$F$1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span>\u00a0<span class=\" string \" dir=\"auto\">\u201cyyyy-mm-dd\u201d<\/span><\/span><span class=\" default-formula-text-color\" dir=\"auto\"><span style=\"color: #000000\">)<\/span>\u00a0<\/span><span class=\" default-formula-text-color\" dir=\"auto\" style=\"color: #ff00ff\">&amp;\u00a0<\/span><\/span><span class=\" string \" dir=\"auto\"><span style=\"color: #ff0000\">\u201d <span style=\"color: #0000ff\">\u2018<\/span><\/span><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_viet_dieu_kien_truc_tiep_khong_tham_chieu\"><\/span>C\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp (kh\u00f4ng tham chi\u1ebfu)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi c\u00e1ch vi\u1ebft n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp tr\u1ef1c ti\u1ebfp gi\u00e1 tr\u1ecb\u00a0\u0111i\u1ec1u ki\u1ec7n theo nguy\u00ean t\u1eafc:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb Text (k\u00fd t\u1ef1 ch\u1eef) th\u00ec\u00a0\u0111\u1eb7t trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>Gi\u00e1 tr\u1ecb Number (s\u1ed1) th\u00ec vi\u1ebft tr\u1ef1c ti\u1ebfp<\/li>\n<\/ul>\n<p>C\u00e1c d\u1ea5u to\u00e1n t\u1eed (= , &gt;=, &lt;=, &gt;, &lt; \u2026) vi\u1ebft tr\u1ef1c ti\u1ebfp<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p style=\"padding-left: 30px\">=QUERY($A$1:$F$100, \u201cSELECT <span style=\"color: #0000ff\">A<\/span>, <span style=\"color: #0000ff\">C<\/span>, <span style=\"color: #0000ff\">D<\/span>\u00a0WHERE\u00a0<span style=\"color: #ff0000\">F &gt; 1<\/span> AND <span style=\"color: #ff0000\">F &lt; 100<\/span> AND <span style=\"color: #ff0000\">B = \u201cHanoi\u201d<\/span> \u201c)<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 bi\u1ebft c\u00e1ch vi\u1ebft h\u00e0m Query trong Google Sheet r\u1ed3i. Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t nh\u1eefng ki\u1ebfn th\u1ee9c tr\u00ean v\u00e0o c\u00f4ng vi\u1ec7c.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c v\u1ec1 Google Sheet:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-form-nhap-lieu-trong-google-sheet.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o form nh\u1eadp li\u1ec7u trong Google Sheet<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-ngon-ngu-tren-giao-dien-google-sheet.html\">Chuy\u1ec3n ng\u00f4n ng\u1eef tr\u00ean giao di\u1ec7n Google Sheet<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/sua-doi-cac-hang-cot-va-o-trong-google-sheets.html\">S\u1eeda \u0111\u1ed5i c\u00e1c h\u00e0ng, c\u1ed9t v\u00e0 \u00f4 trong Google Sheets<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-813.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8729,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8728","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8728"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8728\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8729"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}