{"id":9429,"date":"2025-01-02T06:08:19","date_gmt":"2025-01-02T06:08:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-nhan-mot-cot-voi-mot-so-co-dinh-trong-excel\/"},"modified":"2025-01-02T06:08:19","modified_gmt":"2025-01-02T06:08:19","slug":"huong-dan-cach-nhan-mot-cot-voi-mot-so-co-dinh-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-nhan-mot-cot-voi-mot-so-co-dinh-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch nh\u00e2n m\u1ed9t c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 c\u1ed1 \u0111\u1ecbnh trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch \u0111\u1ec3 nh\u00e2n m\u1ed9t d\u1ea3i d\u1eef li\u1ec7u v\u1edbi m\u1ed9t s\u1ed1 (nh\u00e2n m\u1ed9t c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1, m\u1ed9t h\u00e0ng v\u1edbi m\u1ed9t s\u1ed1 ho\u1eb7c m\u1ed9t b\u1ea3ng v\u1edbi m\u1ed9t s\u1ed1).<\/p>\n<p>Ta s\u1ebd s\u1eed d\u1ee5ng b\u1ea3ng d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24477\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-hai-cot-1.png\" width=\"437\" height=\"363\" title=\"nhan-hai-cot-1\"><\/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-67762d524cd5b\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/nhan-mot-cot-voi-mot-so-co-dinh-trong-excel.html#Nhan_mot_cot_voi_mot_so_co_dinh_su_dung_dau_ket_hop_tham_chieu_tuyet_doi\" title=\"Nh\u00e2n\u00a0 m\u1ed9t c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 c\u1ed1 \u0111\u1ecbnh s\u1eed d\u1ee5ng d\u1ea5u * k\u1ebft h\u1ee3p tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i\">Nh\u00e2n\u00a0 m\u1ed9t c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 c\u1ed1 \u0111\u1ecbnh s\u1eed d\u1ee5ng d\u1ea5u * k\u1ebft h\u1ee3p tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/nhan-mot-cot-voi-mot-so-co-dinh-trong-excel.html#Nhan_nhieu_cot_voi_mot_so_bang_tinh_nang_Paste_Special\" title=\"Nh\u00e2n nhi\u1ec1u c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 b\u1eb1ng t\u00ednh n\u0103ng Paste Special\">Nh\u00e2n nhi\u1ec1u c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 b\u1eb1ng t\u00ednh n\u0103ng Paste Special<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Nhan_mot_cot_voi_mot_so_co_dinh_su_dung_dau_ket_hop_tham_chieu_tuyet_doi\"><\/span>Nh\u00e2n\u00a0 m\u1ed9t c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 c\u1ed1 \u0111\u1ecbnh s\u1eed d\u1ee5ng d\u1ea5u * k\u1ebft h\u1ee3p tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, thay v\u00ec nh\u00e2n hai c\u1ed9t v\u1edbi nhau, H\u1ecdc Excel Online mu\u1ed1n b\u1ea1n th\u1ef1c hi\u1ec7n nh\u00e2n to\u00e0n b\u1ed9 c\u1ed9t th\u1ee9 nh\u1ea5t v\u1edbi 73 \u2013 t\u1ee9c l\u00e0 \u00f4 C2.<\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta s\u1ebd th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p>T\u1ea1i \u00f4 D2 l\u00e0 n\u01a1i nh\u1eadp k\u1ebft qu\u1ea3, g\u00f5\u00a0<strong>=B2*$C$2.\u00a0<\/strong>B\u1eb1ng vi\u1ec7c \u0111\u1eb7t d\u1ea5u dollar ta \u0111\u00e3 \u201cc\u1ed1 \u0111\u1ecbnh\u201d \u00f4 C2 l\u1ea1i. Sau \u0111\u00f3 ti\u1ebfn h\u00e0nh fill \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p>K\u1ebft qu\u1ea3:<\/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\/2025\/01\/ex101_92019-nho-52.gif\" title=\"ex101_92019-nho-52\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24484\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-voi-mot-so-1.png\" width=\"607\" height=\"364\" title=\"nhan-voi-mot-so-1\"><\/p>\n<p>N\u1ebfu \u0111\u00e3 \u0111\u1ecdc b\u00e0i vi\u1ebft tr\u01b0\u1edbc: <strong><a href=\"http:\/\/blog.ezworkapp.com\/nhan-hai-cot-voi-nhau-trong-excel.html\">Nh\u00e2n hai c\u1ed9t v\u1edbi nhau trong Excel<\/a>,\u00a0<\/strong>c\u00e1c b\u1ea1n s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1ch th\u00f4ng d\u1ee5ng ti\u1ebfp theo m\u00e0 H\u1ecdc Excel Online s\u1ebd s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng<\/p>\n<p>C\u00f4ng th\u1ee9c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd l\u00e0: =B2:B7*$C$2, \u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 ch\u1ea1y. Sau \u0111\u00f3 fill \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c d\u1eef li\u1ec7u c\u00f2n l\u1ea1i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nhan_nhieu_cot_voi_mot_so_bang_tinh_nang_Paste_Special\"><\/span>Nh\u00e2n nhi\u1ec1u c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 b\u1eb1ng t\u00ednh n\u0103ng Paste Special<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi t\u00ednh n\u0103ng Paste Special, ta c\u00f3 th\u1ec3 nh\u00e2n c\u1ea3 m\u1ed9t b\u1ea3ng v\u1edbi m\u1ed9t s\u1ed1. \u0110\u1ec3 th\u1ef1c hi\u1ec7n ta l\u00e0m nh\u1eefng b\u01b0\u1edbc sau:<\/p>\n<p><strong>1:\u00a0<\/strong>Copy c\u1ed9t\/h\u00e0ng\/b\u1ea3ng c\u1ea7n nh\u00e2n sang v\u00f9ng \u0111\u00edch<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24485\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-voi-mot-so-2.png\" width=\"1001\" height=\"323\" title=\"nhan-voi-mot-so-2\"><\/p>\n<p><strong>2:\u00a0<\/strong>Ch\u1ecdn s\u1ed1 c\u1ed1 \u0111\u1ecbnh c\u1ea7n nh\u00e2n sau \u0111\u00f3 copy<\/p>\n<p><strong>3:\u00a0<\/strong>B\u00f4i \u0111en v\u00f9ng \u0111\u00edch r\u1ed3i trong th\u1ebb Home, nh\u00f3m clipboard ch\u1ecdn m\u0169i t\u00ean s\u1ed5 xu\u1ed1ng t\u1ea1i Paste v\u00e0 ch\u1ecdn\u00a0<strong>Paste Special.<\/strong><\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24486\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-voi-mot-so-3-1024x558-1.png\" width=\"1024\" height=\"558\" title=\"nhan-voi-mot-so-3-1024x558-1\"><\/p>\n<p><strong>4:\u00a0<\/strong>Ch\u1ecdn\u00a0<strong>Multiply\u00a0<\/strong>trong h\u1ed9p tho\u1ea1i\u00a0<strong>Paste Special<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24487\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-voi-mot-so-4.png\" width=\"408\" height=\"336\" title=\"nhan-voi-mot-so-4\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24488\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-voi-mot-so-5.png\" width=\"999\" height=\"321\" title=\"nhan-voi-mot-so-5\"><\/p>\n<p>\u00a0<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/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\/2025\/01\/ex101_92019-nho-52.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9430,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9429","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\/9429","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=9429"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9429\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9430"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}