{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","IF Function","IF, EXACT ","VBA (Sensitive)","Case Sensitive- Combined","Case In-Sensitive","Case In-Sensitive - COUNTIF","Case In-Sensitive- SEARCH ","Case In-Sensitive- SUMPRODUCT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Checking If Cell Contains Specific Text"]
[]
[null,"ID","Name","Grade"]
[null,"Alex-AB-001","Alex","Passed"]
[null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","Passed"]
[null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"IF Function","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Use of IF Function",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Remarks",null,null,null,null,null,null,null,"ID","Name","Grade","Remarks"]
[null,"Alex-AB-001","Alex","Passed",{"$f":"IF(D5=\"Passed\",\"Promoted\",\"\")","v":"Promoted"},null,null,null,null,null,null,null,"Alex-AB-001","Alex","Passed"]
[null,"Marry-ab-002","Marry","Passed",{"$f":"IF(D6=\"Passed\",\"Promoted\",\"\")","v":"Promoted"},null,null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed","",null,null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed","Promoted",null,null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed","",null,null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed","",null,null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","Passed","Promoted",null,null,null,null,null,null,null,"Robart-CH-007","Robart","Passed"]
[null,"John-ch-008","Jason","Passed","Promoted",null,null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed","",null,null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed","Promoted",null,null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"IF, EXACT ","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Merge IF & EXACT Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Remarks",null,null,null,null,null,null,null,"ID","Name","Grade","Remarks"]
[null,"Alex-AB-001","Alex","Passed",{"$f":"IF(EXACT(\"Passed\",D5),\"Promoted\",\"\")","v":"Promoted"},null,null,null,null,null,null,null,"Alex-AB-001","Alex","Passed"]
[null,"Marry-ab-002","Marry","Passed",{"$f":"IF(EXACT(\"Passed\",D6),\"Promoted\",\"\")","v":"Promoted"},null,null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed","",null,null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed","Promoted",null,null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed","",null,null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed","",null,null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","Passed","Promoted",null,null,null,null,null,null,null,"Robart-CH-007","Robart","Passed"]
[null,"John-ch-008","Jason","Passed","Promoted",null,null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed","",null,null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed","Promoted",null,null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"VBA (Sensitive)","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade",null,null,null,null,null,null,null,"ID","Name","Grade"]
[null,"Alex-AB-001","Alex","Passed",null,null,null,null,null,null,null,"Alex-AB-001","Alex","Passed"]
[null,"Marry-ab-002","Marry","Passed",null,null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed",null,null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed",null,null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed",null,null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed",null,null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","Passed",null,null,null,null,null,null,null,"Robart-CH-007","Robart","Passed"]
[null,"John-ch-008","Jason","Passed",null,null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed",null,null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed",null,null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"Case Sensitive- Combined","index":4,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[4,4,13,4],[1,12,1,16],[4,15,13,15]]}
[]
[null,"Combine IF, ISNUMBER, FIND & MID Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Search String","Group",null,null,null,null,null,null,"ID","Name","Grade","Search String","Group"]
[null,"Alex-AB-001","Alex","Passed","XG",{"$f":"IF(ISNUMBER(FIND($E$5,B5)),MID(B5,FIND($E$5,B5),2),\"\")","v":""},null,null,null,null,null,null,"Alex-AB-001","Alex","Passed","XG"]
[null,"Marry-ab-002","Marry","Passed",null,"",null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed",null,"",null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed",null,"",null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed",null,"XG",null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed",null,"",null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","passed",null,"",null,null,null,null,null,null,"Robart-CH-007","Robart","passed"]
[null,"John-ch-008","Jason","Passed",null,"",null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed",null,"",null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed",null,"",null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"Case In-Sensitive","index":5,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[4,4,13,4],[1,12,1,16],[4,15,13,15]]}
[]
[null,"Combine IF, ISNUMBER, SEARCH & MID Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Search String","Group",null,null,null,null,null,null,"ID","Name","Grade","Search String","Group"]
[null,"Alex-AB-001","Alex","Passed","AB",{"$f":"IF(ISNUMBER(SEARCH($E$5,B5)),MID(B5,SEARCH($E$5,B5),2),\"\")","v":"AB"},null,null,null,null,null,null,"Alex-AB-001","Alex","Passed","AB"]
[null,"Marry-ab-002","Marry","Passed",null,"ab",null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed",null,"",null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed",null,"aB",null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed",null,"",null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed",null,"Ab",null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","passed",null,"",null,null,null,null,null,null,"Robart-CH-007","Robart","passed"]
[null,"John-ch-008","Jason","Passed",null,"",null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed",null,"AB",null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed",null,"",null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"Case In-Sensitive - COUNTIF","index":6,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[4,4,13,4],[1,12,1,16],[4,15,13,15]]}
[]
[null,"Combine IF, COUNTIF, SEARCH & MID Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Search String","Group",null,null,null,null,null,null,"ID","Name","Grade","Search String","Group"]
[null,"Alex-AB-001","Alex","Passed","Xg",{"$f":"IF(COUNTIF(B5,\"*\"&$E$5&\"*\"),MID(B5,SEARCH($E$5,B5),2),\"\")","v":""},null,null,null,null,null,null,"Alex-AB-001","Alex","Passed","XG"]
[null,"Marry-ab-002","Marry","Passed",null,"",null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed",null,"xg",null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed",null,"",null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed",null,"XG",null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed",null,"",null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","passed",null,"",null,null,null,null,null,null,"Robart-CH-007","Robart","passed"]
[null,"John-ch-008","Jason","Passed",null,"",null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed",null,"",null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed",null,"xg",null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"Case In-Sensitive- SEARCH ","index":7,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[4,4,13,4],[1,12,1,16],[4,15,13,15]]}
[]
[null,"Unite ISNUMBER & SEARCH Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Search String","Status",null,null,null,null,null,null,"ID","Name","Grade","Search String","Status"]
[null,"Alex-AB-001","Alex","Passed","Xg",{"$f":"ISNUMBER(SEARCH(E5,B5:B14))","v":false},null,null,null,null,null,null,"Alex-AB-001","Alex","Passed","XG"]
[null,"Marry-ab-002","Marry","Passed",null,false,null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed",null,true,null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed",null,false,null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed",null,true,null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed",null,false,null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","passed",null,false,null,null,null,null,null,null,"Robart-CH-007","Robart","passed"]
[null,"John-ch-008","Jason","Passed",null,false,null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed",null,false,null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed",null,true,null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]

{"sheet":"Case In-Sensitive- SUMPRODUCT","index":8,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[4,4,13,4],[1,12,1,16],[4,15,13,15]]}
[]
[null,"Merge SUMPRODUCT & COUNTIF Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Grade","Search String","Status",null,null,null,null,null,null,"ID","Name","Grade","Search String","Status"]
[null,"Alex-AB-001","Alex","Passed","Xg",{"$f":"SUMPRODUCT(COUNTIF(B5,\"*\"&$E$5&\"*\"))>0","v":false},null,null,null,null,null,null,"Alex-AB-001","Alex","Passed","Xg"]
[null,"Marry-ab-002","Marry","Passed",null,{"$f":"SUMPRODUCT(COUNTIF(B6,\"*\"&$E$5&\"*\"))>0","v":false},null,null,null,null,null,null,"Marry-ab-002","Marry","Passed"]
[null,"John-xg-003","John","Failed",null,true,null,null,null,null,null,null,"John-xg-003","John","Failed"]
[null,"Ajantha-aB-004","Ajantha","Passed",null,false,null,null,null,null,null,null,"Ajantha-aB-004","Ajantha","Passed"]
[null,"Mick-XG-005","Mick","Failed",null,true,null,null,null,null,null,null,"Mick-XG-005","Mick","Failed"]
[null,"Leen-Ab-006","Leen","Failed",null,false,null,null,null,null,null,null,"Leen-Ab-006","Leen","Failed"]
[null,"Robart-CH-007","Robart","passed",null,false,null,null,null,null,null,null,"Robart-CH-007","Robart","passed"]
[null,"John-ch-008","Jason","Passed",null,false,null,null,null,null,null,null,"John-ch-008","Jason","Passed"]
[null,"Chistina-AB-009","Chistina","Failed",null,false,null,null,null,null,null,null,"Chistina-AB-009","Chistina","Failed"]
[null,"Stephen-xg-010","Stephen","Passed",null,true,null,null,null,null,null,null,"Stephen-xg-010","Stephen","Passed"]