{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","VLOOKUP","CONCATENATE","COUNTIF","VBA"],"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":"Overview","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[14,2,14,4],[15,2,15,4]]}
[]
[null,"Overview of Dataset"]
[]
[null,"First Name","Last Name","Profession","Concatenate"]
[null,"Alfred","Tennyson","Student",{"$f":"B5&\" \" & C5","v":"Alfred Tennyson"}]
[null,"Robert","Browning","Writer",{"$f":"B6&\" \" & C6","v":"Robert Browning"}]
[null,"Charls","Dickens","Doctor","Charls Dickens"]
[null,"Edward","Fokuama","Student","Edward Fokuama"]
[null,"Stuart","Mill","Entrepreneur","Stuart Mill"]
[null,"Charlotte","Bronte","Writer",{"$f":"B10&\" \" & C10","v":"Charlotte Bronte"}]
[null,"George","Eliot","Student","George Eliot"]
[null,"Alexandre","Cardinal","Doctor","Alexandre Cardinal"]
[null,"Twain","Mark","Writer","Twain Mark"]
[]
[null,"Profession","Result"]
[null,"Entrepreneur",{"$f":"VLOOKUP(B16,D5:E13,2,FALSE)","v":"Stuart Mill"}]

{"sheet":"VLOOKUP","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[14,3,14,4],[15,3,15,4],[14,1,14,2],[15,1,15,2],[1,6,1,9],[14,6,14,7],[14,8,14,9],[15,6,15,7],[15,8,15,9]]}
[]
[null,"Apply Ampersand Operator",null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Profession","Concatenate",null,"First Name","Last Name","Profession","Concatenate"]
[null,"Alfred","Tennyson","Student",{"$f":"B5&\" \" & C5","v":"Alfred Tennyson"},null,"Alfred","Tennyson","Student"]
[null,"Robert","Browning","Writer",{"$f":"B6&\" \" & C6","v":"Robert Browning"},null,"Robert","Browning","Writer"]
[null,"Charls","Dickens","Entrepreneur","Charls Dickens",null,"Charls","Dickens","Entrepreneur"]
[null,"Edward","Fokuama","Student","Edward Fokuama",null,"Edward","Fokuama","Student"]
[null,"Stuart","Mill","Entrepreneur","Stuart Mill",null,"Stuart","Mill","Entrepreneur"]
[null,"Charlotte","Bronte","Writer","Charlotte Bronte",null,"Charlotte","Bronte","Writer"]
[null,"George","Eliot","Student","George Eliot",null,"George","Eliot","Student"]
[null,"Alexandre","Cardinal","Entrepreneur","Alexandre Cardinal",null,"Alexandre","Cardinal","Entrepreneur"]
[null,"Twain","Mark","Writer","Twain Mark",null,"Twain","Mark","Writer"]
[]
[null,"First Name",null,"Result",null,null,"First Name",null,"Result"]
[null,"George",null,{"$f":"VLOOKUP(B16,B5:E13,4,FALSE)","v":"George Eliot"},null,null,"George"]

{"sheet":"CONCATENATE","index":2,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4],[14,1,14,2],[14,3,14,4],[15,1,15,2],[15,3,15,4],[1,6,1,9],[14,6,14,7],[14,8,14,9],[15,6,15,7],[15,8,15,9]]}
[]
[null,"Use CONCATENATE Function",null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Profession","Concatenate",null,"First Name","Last Name","Profession","Concatenate"]
[null,"Alfred","Tennyson","Student",{"$f":"CONCATENATE(B5,\" \",C5)","v":"Alfred Tennyson"},null,"Alfred","Tennyson","Student"]
[null,"Robert","Browning","Writer",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Robert Browning"},null,"Robert","Browning","Writer"]
[null,"Charls","Dickens","Entrepreneur","Charls Dickens",null,"Charls","Dickens","Entrepreneur"]
[null,"Edward","Fokuama","Student","Edward Fokuama",null,"Edward","Fokuama","Student"]
[null,"Stuart","Mill","Entrepreneur","Stuart Mill",null,"Stuart","Mill","Entrepreneur"]
[null,"Charlotte","Bronte","Writer","Charlotte Bronte",null,"Charlotte","Bronte","Writer"]
[null,"George","Eliot","Student","George Eliot",null,"George","Eliot","Student"]
[null,"Alexandre","Cardinal","Entrepreneur","Alexandre Cardinal",null,"Alexandre","Cardinal","Entrepreneur"]
[null,"Twain","Mark","Writer","Twain Mark",null,"Twain","Mark","Writer"]
[]
[null,"First Name",null,"Result",null,null,"First Name",null,"Result"]
[null,"Edward",null,{"$f":"VLOOKUP(B16,B5:E13,4,FALSE)","v":"Edward Fokuama"},null,null,"George"]
[]
[]
[]
[]
[null,{"$f":"VLOOKUP(B16,B5:E13,4,FALSE)","v":"Edward Fokuama"}]

{"sheet":"COUNTIF","index":3,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,10]]}
[]
[null,"Combination of IF, COUNTIF, ROW, INDEX, and SMALL Functions",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"Project","Manager",null,"Project","Manager","Concatenate",null,"Project","Manager","Concatenate"]
[null,"Proj1","User1",null,"Proj1",{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:1),INDEX($C$4:$C$16,SMALL(\nIF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(1:1))),\"\")","v":"User1"},{"$f":"$E$5&\" \"&F5","v":"Proj1 User1"},null,"Proj1",{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:1),INDEX($C$4:$C$16,SMALL(\nIF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(1:1))),\"\")","v":"User1"}]
[null,"Proj2","User2",null,null,{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:2),INDEX($C$4:$C$16,SMALL(\nIF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(2:2))),\"\")","v":"User3"},{"$f":"$E$5&\" \"&F6","v":"Proj1 User3"},null,null,{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:2),INDEX($C$4:$C$16,SMALL(\nIF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(2:2))),\"\")","v":"User3"}]
[null,"Proj1","User3",null,null,{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:3),INDEX($C$4:$C$16,SMALL(\nIF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(3:3))),\"\")","v":"User2"},"Proj1 User2",null,null,{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:3),INDEX($C$4:$C$16,SMALL(\nIF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(3:3))),\"\")","v":"User2"}]
[null,"Proj4","User1"]
[null,"Proj1","User2"]
[null,"Proj2","User3",null,null,{"$f":"IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:6),INDEX($C$4:$C$16,SMALL(IF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(6:6))),\"\")","v":""}]
[null,"Proj4","User4"]
[null,"Proj3","User2"]
[null,"Proj2","User1"]
[null,"Proj3","User5"]
[null,"Proj4","User2"]
[null,"Proj2","User4"]

{"sheet":"VBA","index":4,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[14,2,14,4],[15,2,15,4],[1,6,1,9],[14,6,14,7],[14,8,14,9],[15,6,15,7],[15,8,15,9]]}
[]
[null,"Run Excel VBA Code to Concatenate with VLOOKUP",null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Profession","Helper Column",null,"First Name","Last Name","Profession","Concatenate"]
[null,"Alfred","Tennyson","Student",{"$f":"B5&\" \" & C5","v":"Alfred Tennyson"},null,"Alfred","Tennyson","Student",{"$f":"G5&\" \" & H5","v":"Alfred Tennyson"}]
[null,"Robert","Browning","Writer",{"$f":"B6&\" \" & C6","v":"Robert Browning"},null,"Robert","Browning","Writer",{"$f":"G6&\" \" & H6","v":"Robert Browning"}]
[null,"Charls","Dickens","Entrepreneur","Charls Dickens",null,"Charls","Dickens","Entrepreneur","Charls Dickens"]
[null,"Edward","Fokuama","Student","Edward Fokuama",null,"Edward","Fokuama","Student","Edward Fokuama"]
[null,"Stuart","Mill","Entrepreneur","Stuart Mill",null,"Stuart","Mill","Entrepreneur","Stuart Mill"]
[null,"Charlotte","Bronte","Writer",{"$f":"B10&\" \" & C10","v":"Charlotte Bronte"},null,"Charlotte","Bronte","Writer",{"$f":"G10&\" \" & H10","v":"Charlotte Bronte"}]
[null,"George","Eliot","Student","George Eliot",null,"George","Eliot","Student","George Eliot"]
[null,"Alexandre","Cardinal","Entrepreneur","Alexandre Cardinal",null,"Alexandre","Cardinal","Entrepreneur","Alexandre Cardinal"]
[null,"Twain","Mark","Writer","Twain Mark",null,"Twain","Mark","Writer","Twain Mark"]
[]
[null,"Profession","Result",null,null,null,"First Name",null,"Result"]
[null,"Entrepreneur",{"$f":"VlookupCon(B16,B5:E13,2)","v":" Charls Dickens Stuart Mill Alexandre Cardinal"},null,null,null,"George"]