{"id":11827,"date":"2025-01-15T05:21:05","date_gmt":"2025-01-15T05:21:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tim-nhung-gia-tri-xuat-hien-mot-lan-hoac-nhieu-lan-trong-hai-cot-hay-trong-hai-trang-tinh\/"},"modified":"2025-01-15T05:21:05","modified_gmt":"2025-01-15T05:21:05","slug":"cach-tim-nhung-gia-tri-xuat-hien-mot-lan-hoac-nhieu-lan-trong-hai-cot-hay-trong-hai-trang-tinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tim-nhung-gia-tri-xuat-hien-mot-lan-hoac-nhieu-lan-trong-hai-cot-hay-trong-hai-trang-tinh\/","title":{"rendered":"C\u00e1ch t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n ho\u1eb7c nhi\u1ec1u l\u1ea7n trong hai c\u1ed9t hay trong hai trang t\u00ednh"},"content":{"rendered":"
\n

C\u00f3 th\u1ec3 vi\u1ec7c so s\u00e1nh hai v\u00f9ng d\u1eef li\u1ec7u trong c\u00f9ng trang t\u00ednh v\u00e0 t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p ho\u1eb7c xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n s\u1ebd d\u1ec5 d\u00e0ng v\u1edbi m\u1ed9t s\u1ed1 b\u1ea1n, nh\u01b0ng n\u1ebfu hai v\u00f9ng d\u1eef li\u1ec7u trong hai trang t\u00ednh kh\u00e1c nhau, l\u00e0m c\u00e1ch n\u00e0o b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u00f3? Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n m\u1ed9t v\u00e0i c\u00e1ch t\u1eaft \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c n\u00e0y.<\/p>\n

So s\u00e1nh hai c\u1ed9t c\u00f3 c\u00f9ng ti\u00eau \u0111\u1ec1trong hai trang t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c Excel<\/strong><\/p>\n

B\u1eb1ng c\u00f4ng th\u1ee9c Excel, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh hai c\u1ed9t c\u00f3 c\u00f9ng ti\u00eau \u0111\u1ec1 trong nhi\u1ec1u trang t\u00ednh v\u00e0 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n.<\/p>\n

<\/p>\n

1. G\u00f5 c\u00f4ng th\u1ee9c =COUNTIF(Sheet1!$A:$A, A1)<\/strong><\/em>\u00a0v\u00e0o \u00f4 tr\u1ed1ng li\u1ec1n k\u1ec1 v\u1edbi v\u00f9ng d\u1eef li\u1ec7u trong Sheet3.<\/p>\n

<\/p>\n

2. Nh\u1ea5n Enter, sau \u0111\u00f3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n so s\u00e1nh v\u1edbi d\u1eef li\u1ec7u trong Sheet1. (S\u1ed1 0 ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb tr\u00f9ng trong hai v\u00f9ng d\u1eef li\u1ec7u, s\u1ed1 1 l\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Sheet3, nh\u01b0ng kh\u00f4ng c\u00f3 trong Sheet1)<\/p>\n

<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

M\u1eb9o.<\/strong><\/p>\n

1. C\u00f4ng th\u1ee9c n\u00e0y ch\u1ec9 c\u00f3 th\u1ec3 so s\u00e1nh hai c\u1ed9t c\u00f3 c\u00f9ng ti\u00eau \u0111\u1ec1 trong hai trang t\u00ednh.<\/p>\n

2. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n trong Sheet1, nh\u01b0ng kh\u00f4ng c\u00f3 trong Sheet3, b\u1ea1n c\u1ea7n g\u00f5 c\u00f4ng th\u1ee9c =COUNTIF(Sheet3!$A:$A, A1)<\/strong><\/em>\u00a0v\u00e0o Sheet1.<\/p>\n

So s\u00e1nh hai v\u00f9ng d\u1eef li\u1ec7u trong hai trang t\u00ednh b\u1eb1ng VBA<\/strong><\/p>\n

1. Nh\u1ea5n gi\u1eef ph\u00edm\u00a0Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications\u00a0<\/strong><\/em>m\u1edf ra.<\/p>\n

2. Nh\u1ea5p Insert > Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o Module Window<\/strong><\/em>.<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
3. Nh\u1ea5n\u00a0F5\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra nh\u1eafc nh\u1edf b\u1ea1n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n so s\u00e1nh v\u1edbi.<\/div>\n
<\/div>\n
4. Nh\u1ea5n OK. M\u1ed9t h\u1ed9p tho\u1ea1i l\u1ea1i xu\u1ea5t hi\u1ec7n \u0111\u1ec3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u th\u1ee9 hai.<\/div>\n

<\/p>\n

5. Nh\u1ea5n OK. C\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong c\u1ea3 hai V\u00f9ng A v\u00e0 V\u00f9ng B s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u \u0111\u1ecf trong V\u00f9ng A.<\/p>\n

<\/p>\n

M\u1eb9o.\u00a0<\/strong>B\u1eb1ng VBA, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh hai v\u00f9ng d\u1eef li\u1ec7u trong c\u00f9ng trang t\u00ednh ho\u1eb7c nhi\u1ec1u trang t\u00ednh kh\u00e1c nhau.<\/p>\n

Tham gia kho\u00e1 h\u1ecdc VBA c\u1ef1c \u0111\u1ec9nh c\u1ee7a H\u1ecdc Excel Online<\/p><\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11828,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11827","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\/11827","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=11827"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11827\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11828"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}