Top doanh nghiệp đã đăng ký cho nhân viên

Bạn sẽ học được gì?

Hiểu được SUY NGHĨ của Excel, để viết được mọi Hàm, Công thức
Tự động với hàm, quy trình hóa các thao tác xử lý dữ liệu
Thành thạo 75+ Hàm phổ biến, hữu ích nhất trong Excel dùng cho công việc
Phân chia, ghi nhớ Hàm theo các nhóm
Bài tập Thực hành, ứng dụng để tra cứu và học lại bất kỳ khi nào

Khoá học này sẽ có:

Video

13h 59m giờ học

Article

0 bài viết chuyên môn

Material

97 tài liệu đính kèm

Exam questions

0 đề thi ghi nhớ kiến thức

Nội dung khoá học

9 Chương . 107 bài giảng . 13h 59m giờ học

1

Bắt đầu khóa học

2

Tổng quan về hàm trong Excel

2 bài học thử
3

Các hàm đánh giá, kiểm tra

4

Hàm liên quan tới mệnh đề logic

5

Nhóm hàm toán học, thống kê

5 bài học thử
6

Nhóm hàm tìm kiếm, tham chiếu

2 bài học thử
7

Nhóm hàm với dữ liệu Text

1 bài học thử
8

Nhóm hàm Ngày tháng, thời gian

2 bài học thử
9

Ứng dụng sức mạnh của hàm trong công việc

Mô tả khoá học

Thành thạo 75+ Hàm và Công thức trong Excel với G-Learning để tăng hiệu quả sử dụng Excel cho công việc hằng ngày, tiết kiệm tới 35% thời gian làm việc. Khóa học này sẽ cung cấp cho bạn sự hiểu biết sâu sắc về các công thức và hàm nâng cao của Excel giúp biến Excel từ một chương trình bảng tính cơ bản thành một công cụ phân tích năng động và mạnh mẽ. Hầu hết các khóa học Excel chỉ tập trung dạy về cách viết công thức, nhưng G-Learning sẽ dạy bằng các ví dụ thực tế, theo ngữ cảnh cụ thể để hiểu lý do tại sao việc biết các công thức tuyệt vời đến vậy.

G-Learning sẽ không dạy bạn lặp lại các hàm và công thức; G-Learning sẽ dạy bạn cách SUY NGHĨ và LÀM VIỆC như Excel.

Giảng viên:

G-LEARNING Giảng viên

Trường đào tạo & phát triển kỹ năng ứng dụng tin học văn phòng

G-LEARNING
  • 4.6 điểm đánh giá

  • 436 đánh giá

  • 224,578 học viên

  • 88 khóa học

Đánh giá của học viên

4.75 điểm đánh giá . 4 lượt đánh giá

Phạm Linh 

Phạm Linh 

01:41 30/03/2022

Tôi hài lòng với khóa học. Cảm ơn Gitiho và giảng viên. Nhờ khóa học này tôi được ôn tập và biết thêm cách sử dụng các hàm để ứng dụng, giải quyết công việc được nhanh hơn. Sẽ tiếp tục học các khóa học khác của Gitiho
Đặng Thị Như Huyền

Đặng Thị Như Huyền

02:45 19/12/2021

Well done. Session is great. Chương này giúp củng cố kiến thức cơ bản cho học viên. Rất chi tiết. Giáo viên giọng giảng truyền cảm và dễ hiểu. Thực hành nhiều và cụ thể giúp học viên nắm vững kiến thức.
Nguyễn Trọng Hào

Nguyễn Trọng Hào

04:50 04/06/2021

Nice! Khoá học rất trực quan và dễ hiểu!!!! Nhưng nếu có nhiều bài tập hơn cho học viên thực hành sẽ ok hơn!!!! Đối với mình như thế là ổn!!!!!!!!!! Mình góp ý web nên hoàn thiện chức năng đính kèm file ( khi mình có thắc mắc gì hỏi giàng viên phải tải lên drive rất bất tiện)

Thảo luận về bài học

290 thảo luận

Trần Chính

Trần Chính 06 Dec 2022

Nhờ thầy hướng dẫn giúp em trường hợp này ạ, em có DS số ID (cột A - sheet data, mỗi ID đó được phép gán tối đa với 9 số điện thoại trên cột B - sheet data).

Giờ em muốn viết công thức để hiển theo hàng ngang ra được 1 ID đó đã gán cho những SĐT nào theo bảng trong hình

Em cảm ơn ạ

Tuấn Ba

Tuấn Ba [Chuyên gia] 06 Dec 2022

Bạn đẩy file và có mô tả 01 kết quả giúp gitiho nhé.

{"id":157073,"crm_contact_id":242468,"name":"Tr\u1ea7n Ch\u00ednh","email":"chinhtranvt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"30089d5de705c609df46d38d2f34c311","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-07-01T06:14:37.000000Z","updated_at":"2022-11-01T10:53:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"82 Duy T\u00e2n, D\u1ecbch V\u1ecdng H\u1eadu, C\u1ea7u Gi\u1ea5y, H\u00e0 N\u1ed9i","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":104972,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_157\/tran-chinh.png","link_profile":"https:\/\/gitiho.com\/u\/157073-tran-chinh","business_employers":[],"vip_account":null,"roles":[]}

Trần Chính 07 Dec 2022

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 07 Dec 2022

Công thức tại ô E2 như sau bạn nhé.

=IFERROR(INDEX(Data!$B$2:$B$201,IFERROR(AGGREGATE(15,6,ROW(Data!$A$2:$A$201)/(Data!$A$2:$A$201=$B2),COLUMNS($A$1:A2))-1,"")),"")

{"id":157073,"crm_contact_id":242468,"name":"Tr\u1ea7n Ch\u00ednh","email":"chinhtranvt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"30089d5de705c609df46d38d2f34c311","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-07-01T06:14:37.000000Z","updated_at":"2022-11-01T10:53:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"82 Duy T\u00e2n, D\u1ecbch V\u1ecdng H\u1eadu, C\u1ea7u Gi\u1ea5y, H\u00e0 N\u1ed9i","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":104972,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_157\/tran-chinh.png","link_profile":"https:\/\/gitiho.com\/u\/157073-tran-chinh","business_employers":[],"vip_account":null,"roles":[]}

Trần Chính 07 Dec 2022

Dạ em cảm ơn ạ

Mai Pham

Mai Pham 03 Dec 2022

Em bấm F5 thì không ra gì cả. File em down từ bài giảng ạ.

 

Tuấn Ba

Tuấn Ba [Chuyên gia] 04 Dec 2022

Chào bạn bạn có thể mô tả rõ hơn giúp gitiho được không?

Nguyễn Thị Thanh Hoa

Nguyễn Thị Thanh Hoa 19 Nov 2022

khóa học nào có thể áp dụng tạo files hàm chỉ em với ạ , em đăng kí nhầm khóa

Trợ giảng Gitiho (Huyền Trang)

Trợ giảng Gitiho (Huyền Trang) 19 Nov 2022

Chào bạn! Bạn vui lòng liên lạc với bên CSKH của Gitiho để có thể trao đổi kỹ hơn ạ

Dương Kim

Dương Kim 05 Nov 2022

Cho e hỏi, tại sao tính giá tiền chưa thuế lại chia với 1.1 ạ? nếu 10% thì phải là 0.1 chứ ạ???

Tuấn Ba

Tuấn Ba [Chuyên gia] 08 Nov 2022

Phần này bạn chỉ cần đặt hàm chia ngược là ra bạn nhé tính trước thuế là *10% còn tính lại trước thuế thì chia 1.1

CAO THI DIEM TRANG

CAO THI DIEM TRANG 04 Nov 2022

Thay oi, neu truong hop Nhan Vien lam them 1/2X (tuc nua ngay cong), thi minh lam sao de biet duoc a. Vi theo em hieu INT se lam tron ve so nguyen gan nhat. Va theo nhu vi du tren vay NLD se bi lo mat 0.5X a. Em cam on Thay nhieu.

 

Tuấn Ba

Tuấn Ba [Chuyên gia] 05 Nov 2022

Chào bạn bạn cứ cộng thời gian x/2 lại rồi hiện thị phần làm tròn số là xong

 

Nguyễn Thu Phương

Nguyễn Thu Phương 28 Oct 2022

Tuấn Ba

Tuấn Ba [Chuyên gia] 29 Oct 2022

Bạn kiểm tra hàm year(v13) cho ra kết quả bao nhiêu nhé.

{"id":105233,"crm_contact_id":41575,"name":"Nguy\u1ec5n Thu Ph\u01b0\u01a1ng","email":"phuongnt.fad@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-05-05 15:05:01","confirmation_code":"93a8805a4026fedbc61dca558f6d07f9","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-10-21T01:42:40.000000Z","updated_at":"2022-03-30T06:25:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Thu Ph\u01b0\u01a1ng","address":"\u0110o\u00e0n Ti\u1ebfp Vi\u00ean, ph\u1ed1 L\u00e2m H\u1ea1, Long Bi\u00ean,\u00a0 H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0946783833","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":79580,"google_id":"110923433187132801917","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_105\/nguyen-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/105233-nguyen-thu-phuong","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Thu Phương 29 Oct 2022

Mình đang kt hàm year(v13) đúng bằng 2023 (tại V1)

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2022-12-07T13:55:30.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":53874770,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1293,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":9.97,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 31 Oct 2022

Khi bạn dùng hàm YEAR thì kết quả của hàm là dạng số (number).

Còn khi viết YEAR(v13)="2023" thì “2023” đặt trong dấu nháy kép lại là dạng text. Khi đó 2 kết quả là khác nhau.

Để làm đúng thì bạn viết IF(YEAR(v13)=2023, 0, 1) tức là số 2023 không đặt trong dấu nháy kép.

Trần Hồng Phúc

Trần Hồng Phúc 25 Oct 2022

Xin giáo viên Gitiho cho hỏi,

Trong bài học này mình khá bất ngờ vì dấu * mang nghĩa là VÀ. Còn dấu + mang nghĩa là HOẶC.

1/ Có phải 02 dấu này chỉ mang nghĩa như vậy chỉ trong hàm sumproduct không ? 

2/ Đối với các hàm khác thì nó mang nghĩa khác không ?

3/ Khi nào thì mình biết được dấu + và dấu * mang nghĩa tính toán là phép Cộng và phép Nhân ? Khi nào thì nó mang nghĩa là VÀ, HOẶC ?

Tuấn Ba

Tuấn Ba [Chuyên gia] 26 Oct 2022

Chào bạn phần này gitiho sẽ làm một video để giải thích tại sao sau nhé.

{"id":179238,"crm_contact_id":164960,"name":"Tr\u1ea7n H\u1ed3ng Ph\u00fac","email":"phuctran882003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-11-04 17:15:19","confirmation_code":"7d7166268f1061a406753c2a7d99558c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-10-28T15:19:26.000000Z","updated_at":"2022-12-05T10:45:50.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"65\/12 H\u1ed3 V\u0103n Hu\u00ea,\u00a0P.9, Q. Ph\u00fa Nhu\u1eadn, TP H\u1ed3 Ch\u00ed Minh","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":49012,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":2,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_179\/tran-phuc.png","link_profile":"https:\/\/gitiho.com\/u\/179238-tran-hong-phuc","business_employers":[],"vip_account":null,"roles":[]}

Trần Hồng Phúc 26 Oct 2022

Xin cám ơn gitiho

Le Minh Duc

Le Minh Duc 20 Oct 2022

Thầy Chỉ giúp Em cách để làm tròn số nguyên với ah. Em đã thử nhiều cách và có search google nhưng chưa ra được đáp án ah. 

Vì dụ: Số 31.400 em muốn làm tròn số chẵn = 31.500 ( <500 = 500)

Còn số 31.600 em muốn làm tròn số chẵn = 32.000 ( >500 = 1.000)

Thầy hướng dẫn giúp em với ah. Cảm ơn Thầy

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 22 Oct 2022

Hàm làm tròn ở đây bạn có thể dùng là hàm ROUND

=ROUND(A1, -3)

tham số -3 để làm tròn tới số ở vị trí hàng trăm (phía bên trái dấu thập phân)

{"id":133337,"crm_contact_id":187946,"name":"Le Minh Duc","email":"leminh2108@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ea1c302696512a4a9f341eaa42b0c4b5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-03-20T07:11:24.000000Z","updated_at":"2022-10-20T04:01:40.000000Z","deleted_at":null,"unit_name":"longthuy.vn","grade":0,"avatar_disk":"public","avatar_path":"users\/1616426929.jpeg","gender":0,"birthday":"1982-08-21 00:00:00","position":"G\u0110","achievement":null,"full_name":"L\u00ea Minh \u0110\u1ee9c","address":"1648 V\u00f5 V\u0103n Ki\u1ec7t P16 Qu\u1eadn 8","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0937309930","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":26696,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1616426929.jpeg","link_profile":"https:\/\/gitiho.com\/u\/133337-le-minh-duc","business_employers":[],"vip_account":null,"roles":[]}

Le Minh Duc 23 Oct 2022

dạ Cảm ơn Thầy! 

Nhưng round ( A1,-3) thì 31.400  nó chạy về 31.000 rồi Thầy ah. 

 

Em muốn nó làm tròn tới số ngày nhất trong làm tròn 

Vì dụ: Số 31.400 em muốn làm tròn số chẵn = 31.500 ( <500 = 500, nhỏ hơn 500 sẽ làm tròn thành 500

Còn số 31.600 em muốn làm tròn số chẵn = 32.000 ( >500 = 1.000, lớn hơn 500 sẽ làm tròn thành 1000).

 

Nhờ Thầy hướng dẫn thêm ah

{"id":133337,"crm_contact_id":187946,"name":"Le Minh Duc","email":"leminh2108@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ea1c302696512a4a9f341eaa42b0c4b5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-03-20T07:11:24.000000Z","updated_at":"2022-10-20T04:01:40.000000Z","deleted_at":null,"unit_name":"longthuy.vn","grade":0,"avatar_disk":"public","avatar_path":"users\/1616426929.jpeg","gender":0,"birthday":"1982-08-21 00:00:00","position":"G\u0110","achievement":null,"full_name":"L\u00ea Minh \u0110\u1ee9c","address":"1648 V\u00f5 V\u0103n Ki\u1ec7t P16 Qu\u1eadn 8","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0937309930","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":26696,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1616426929.jpeg","link_profile":"https:\/\/gitiho.com\/u\/133337-le-minh-duc","business_employers":[],"vip_account":null,"roles":[]}

Le Minh Duc 24 Oct 2022

=CEILING(Con số, 500)

Ra rồi Thầy. Mò suốt các diễn đàn cũng ra rồi Thầy. 

 

mjzimzum

mjzimzum 11 Aug 2022

mjzimzum

mjzimzum 11 Aug 2022

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2022-12-07T13:55:30.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":53874770,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1293,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":9.97,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 12 Aug 2022

Bạn viết hàm sai cú pháp rồi.

Phần điều kiện tháng ở vùng A4:A18 là tháng 4 thì không viết dạng A4:A18=4 mà viết như sau:

=AVERAGEIF(A4:A18, 4, D4:D18)

{"id":187952,"crm_contact_id":321656,"name":"mjzimzum","email":"dongpijco1@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"0f1055c81d7656deca67166fb576c4b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-07T20:24:24.000000Z","updated_at":"2022-07-27T13:49:24.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":36879,"google_id":"116191570645612762479","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_188\/mjzimzum-mjzimzum.png","link_profile":"https:\/\/gitiho.com\/u\/187952-mjzimzum","business_employers":[],"vip_account":{"id":1363,"user_id":187952,"vip_account_id":1,"sale_price":299000,"discount":50,"time_start":"2022-06-12 15:40:21","time_end":"2023-06-12 15:40:21","created_at":"2022-06-12T08:40:21.000000Z","updated_at":"2022-06-12T08:40:21.000000Z"},"roles":[]}

mjzimzum 12 Aug 2022

anh ơi nhưng mà vùng từ A4:A18 là dữ liệu dạng ngày thì khi viết như anh thì sao mà Exxcel định ra được giá trị tháng là tháng 04 ạ  ? Viết như anh thì phải là =Averageif (G3:H18; 4; D3:D18) (Chèn thêm 1 cột tháng là cột G)

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Aug 2022

Phần này bạn dùng một cột phụ tách ngày đó ra tháng nhé.

Nguyễn Thu Hà

Nguyễn Thu Hà 09 Aug 2022

nhờ giảng viên giải thích và hướng dẫn cách dùng hàm như trong ảnh ạ. Thanks.
Nguyễn Thu Hà

Nguyễn Thu Hà 09 Aug 2022

bảng dữ liệu như trong hình bên dưới ạ
{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 09 Aug 2022

Bạn đính kèm hình ảnh giúp gitiho nhé.

{"id":238315,"crm_contact_id":415820,"name":"Nguy\u1ec5n Thu H\u00e0","email":"thuha.nguyen.hanoi@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"dbf5832df744b40367c097eff9415732","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-08-03T13:43:41.000000Z","updated_at":"2022-08-09T02:01:17.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1660010406.jpg","gender":1,"birthday":"1975-07-30 00:00:00","position":null,"achievement":null,"full_name":null,"address":"\u0110\u1ed1ng \u0110a - H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0354089752","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":13470,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1660010406.jpg","link_profile":"https:\/\/gitiho.com\/u\/238315-nguyen-thu-ha","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Thu Hà 09 Aug 2022

mình đã gửi ảnh trong phần bình luận bên dưới
Trần Thu Thủy

Trần Thu Thủy 14 Jul 2022

Mình thấy trên các bài học thầy hướng dẫn có phần copy công thức sao chép đến ô khác thì chỉ là chọn công thức đó sau dấu bằng và copy rồi dán đến ô khác, nhưng sao mình copy rồi dán đến ô khác thì excel lại thể hiện theo hình thức là tham chiếu đến ô đó chứ k dán được. Mong thầy hướng dẫn thêm
Tuấn Ba

Tuấn Ba [Chuyên gia] 15 Jul 2022

Bạn chụp công thức và hình ảnh file hoặc đính kèm file lên nhé

{"id":172196,"crm_contact_id":290737,"name":"Tr\u1ea7n Thu Th\u1ee7y","email":"thuthuytran510@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-09-28 10:35:45","confirmation_code":"aaf68dca4a299c24f0ad194c1e9a0412","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-09-28T03:06:30.000000Z","updated_at":"2022-09-25T11:27:21.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1657645526.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"Tr\u1ea7n Thu Th\u1ee7y","address":"22\/14 Phan V\u0103n H\u1edbn, P. T\u00e2n Th\u1edbi Nh\u1ea5t, Q12, TP.HCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0918004285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":72876,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657645526.png","link_profile":"https:\/\/gitiho.com\/u\/172196-tran-thu-thuy","business_employers":[],"vip_account":null,"roles":[]}

Trần Thu Thủy 15 Jul 2022

Copy dán công thức vào ô G3 thì thành tham chiếu đến ô G3, chứ không dán công thức vào được

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 15 Jul 2022

Bạn liên hệ cskh để lên lịch ultraview nhé. Tầm chiều nay

{"id":172196,"crm_contact_id":290737,"name":"Tr\u1ea7n Thu Th\u1ee7y","email":"thuthuytran510@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-09-28 10:35:45","confirmation_code":"aaf68dca4a299c24f0ad194c1e9a0412","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-09-28T03:06:30.000000Z","updated_at":"2022-09-25T11:27:21.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1657645526.png","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"Tr\u1ea7n Thu Th\u1ee7y","address":"22\/14 Phan V\u0103n H\u1edbn, P. T\u00e2n Th\u1edbi Nh\u1ea5t, Q12, TP.HCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0918004285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":72876,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657645526.png","link_profile":"https:\/\/gitiho.com\/u\/172196-tran-thu-thuy","business_employers":[],"vip_account":null,"roles":[]}

Trần Thu Thủy 15 Jul 2022

vâng thầy
Nguyễn Trọng Hào

Nguyễn Trọng Hào 07 Jul 2022

dạ e chào thầy nhờ thầy hướng dẫn giúp em  công thức sau:

Nhu cầu là nếu nhập cột B hoặc cột C thì cột A tự đánh stt tự động

=IF(B7="","",SUBTOTAL(3,$B$6:B7)) em làm cái này thì mới đc cột B ( nhu cầu nhập cột B hoac C)


Tuấn Ba

Tuấn Ba [Chuyên gia] 07 Jul 2022

Bạn để điều kiện như sau

=IF(B1&C1 <>"", SUBTOTAL(3,$B$1:B1,$C$1:C1),"")

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-12-03T21:41:40.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":9,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_110\/nguyen-hao.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 08 Jul 2022


{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-12-03T21:41:40.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":9,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_110\/nguyen-hao.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 08 Jul 2022

trường hợp cả 2 dòng có dữ liệu sai như này mình sửa sao thầy ơi

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-12-03T21:41:40.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":9,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_110\/nguyen-hao.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 08 Jul 2022

Trường hợp của thầy đúng khi 1 trong 2 cột B hoặc C có dữ liệu còn 2 cột dđều có dữ liệu thì nó đánh số chẵn k ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 08 Jul 2022

Trường hợp này bạn tạo ra 1 cột phụ D bằng cách nối cột B&c Lại với nhau 

Và dùng điều kiện cột D để đếm là được

=iF(D2<>"",SUBTOTAL(103,$D$2:D2),"")

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-12-03T21:41:40.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":9,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_110\/nguyen-hao.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 08 Jul 2022

ok cách này thì e làm đc rùi ạ!!!! e tưởng làm đc trên công thức trên lun!!!Tks thầy Ba

 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 08 Jul 2022

Do hàm SUBTOTAL không cho nối chuỗi nên cần phải làm kiểu này

Thúy Nga

Thúy Nga 03 Jul 2022

hj, máy tính mình nhấn f4 nó ko có định hàng cột, mình phải làm sao z bạn>?


Tuấn Ba

Tuấn Ba [Chuyên gia] 03 Jul 2022

Bạn ấn fn+f4 nhé

{"id":151740,"crm_contact_id":228064,"name":"Th\u00fay Nga","email":"thuyngadba@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-06-02 10:39:05","confirmation_code":"62903c9f7137bd62af6a7c5516bf0234","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-06-02T03:32:36.000000Z","updated_at":"2022-07-29T03:02:54.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"Th\u00fay Nga","address":"119\/57H l\u00ea v\u0103n kh\u01b0\u01a1ng, hi\u1ec7p thanh, qu\u1eadn 12, HCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0933274279","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":34669,"google_id":"111305595326369458425","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_152\/thuy-nga.png","link_profile":"https:\/\/gitiho.com\/u\/151740-thuy-nga","business_employers":[],"vip_account":null,"roles":[]}

Thúy Nga 03 Jul 2022

cám ơn,m đã sử dụng dc. m dùng công thức vlookup, nhưng có mã bên bảng dữ liệu cần tìm ko có mã, nên báo lỗi N/A. báo lỗi thì cột đó mình ko tính tổng dc, làm cách nào để cột ko có dữ liệu ko báo lỗi z b

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 03 Jul 2022

Bạn thêm hàm như sau 

=Iferror(vlookup(...),0)

{"id":151740,"crm_contact_id":228064,"name":"Th\u00fay Nga","email":"thuyngadba@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-06-02 10:39:05","confirmation_code":"62903c9f7137bd62af6a7c5516bf0234","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-06-02T03:32:36.000000Z","updated_at":"2022-07-29T03:02:54.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"Th\u00fay Nga","address":"119\/57H l\u00ea v\u0103n kh\u01b0\u01a1ng, hi\u1ec7p thanh, qu\u1eadn 12, HCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0933274279","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":34669,"google_id":"111305595326369458425","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_152\/thuy-nga.png","link_profile":"https:\/\/gitiho.com\/u\/151740-thuy-nga","business_employers":[],"vip_account":null,"roles":[]}

Thúy Nga 03 Jul 2022

mình đã làm dc rồi, cám ơn b nhìu nhé :)

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 03 Jul 2022

Chúc bạn học tốt cùng gitiho

Le Minh Duc

Le Minh Duc 23 Jun 2022

KÍNH NHỜ THẤY VÀ CÁC BẠN XEM GIÚP.


Hiện tại em đã tra soát và làm rất cẩn thận từng công đoạn, tuy nhiên cả hàm lồng IF và hàm IFS đểu cho kết quả #value.

Kình mong Thầy và các bạn xem giúp. ( chỗ em note màu vàng -chữ đỏ) và có File đính kèm  

https://docs.google.com/spreadsheets/...

Em cảm ơn Ah.

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-07T15:55:13.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1825,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.52,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 23 Jun 2022

Bạn sửa như sau nhé:

=IF(IFERROR(MID(G2,SEARCH("LOTTE",G2,1),5)="LOTTE",FALSE),F2+39,

IF(IFERROR(MID(G2,SEARCH("aeon",G2,1),4)="AEON",FALSE),F2+45,

IF(IFERROR(MID(G2,SEARCH("LANG",G2,1),4)="LANG",FALSE),F2+30,

"SAI")))


{"id":133337,"crm_contact_id":187946,"name":"Le Minh Duc","email":"leminh2108@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ea1c302696512a4a9f341eaa42b0c4b5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-03-20T07:11:24.000000Z","updated_at":"2022-10-20T04:01:40.000000Z","deleted_at":null,"unit_name":"longthuy.vn","grade":0,"avatar_disk":"public","avatar_path":"users\/1616426929.jpeg","gender":0,"birthday":"1982-08-21 00:00:00","position":"G\u0110","achievement":null,"full_name":"L\u00ea Minh \u0110\u1ee9c","address":"1648 V\u00f5 V\u0103n Ki\u1ec7t P16 Qu\u1eadn 8","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0937309930","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":26696,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1616426929.jpeg","link_profile":"https:\/\/gitiho.com\/u\/133337-le-minh-duc","business_employers":[],"vip_account":null,"roles":[]}

Le Minh Duc 24 Jun 2022

Em Cảm ơn Thầy! 

Le Minh Duc

Le Minh Duc 23 Jun 2022

KÍNH NHỜ THẤY VÀ CÁC BẠN XEM GIÚP.


Hiện tại em đã tra soát và làm rất cẩn thận từng công đoạn, tuy nhiên cả hàm lồng IF và hàm IFS đểu cho kết quả #value.

Kình mong Thầy và các bạn xem giúp. ( chỗ em note màu vàng -chữ đỏ) và có File đính kèm  

https://docs.google.com/spreadsheets/...

Em cảm ơn Ah.

Tuấn Ba

Tuấn Ba [Chuyên gia] 23 Jun 2022

=IF(IFERROR(MID(G2,SEARCH("LOTTE",G2,1),5)="LOTTE",FALSE),F2+39,

IF(IFERROR(MID(G2,SEARCH("aeon",G2,1),4)="AEON",FALSE),F2+45,

IF(IFERROR(MID(G2,SEARCH("LANG",G2,1),4)="LANG",FALSE),F2+30,

"SAI")))


Khoá học cùng chủ đề

EXG05 - Kỹ năng sử dụng công thức và hàm A-Z trong Excel
4.75

(4 đánh giá)

661 học viên
499,000đ
@ 2020 - Bản quyền của Công ty cổ phần công nghệ giáo dục Gitiho Việt Nam
Giấy chứng nhận Đăng ký doanh nghiệp số: 0109077145, cấp bởi Sở kế hoạch và đầu tư TP. Hà Nội
/