{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Amp&IF","CONCAT&IF","TEXTJOIN&IF","Another Column (2)","Another Column","VBA","CellNotBlank","Multiple Criteria","Multiple Criteria (2)"],"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":"Amp&IF","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining with Ampersand and If Condition"]
[]
[null,"First Name","Middle Name","Last Name","Concatenated"]
[null,"Elton","Hercules","John",{"$f":"B5&IF(ISBLANK(C5),\" \",\" \"&C5)&\" \"&D5","v":"Elton Hercules John"}]
[null,"Kate",null,"Hudson",{"$f":"B6&IF(ISBLANK(C6),\" \",\" \"&C6)&\" \"&D6","v":"Kate  Hudson"}]
[null,"Tina","Stamatina","Fey","Tina Stamatina Fey"]
[null,"Martin","Hayter","Short","Martin Hayter Short"]
[null,"Hugh","Mungo","Grant","Hugh Mungo Grant"]
[null,"Adele",null,"Blue","Adele  Blue"]
[null,"Ben",null,"Affleck","Ben  Affleck"]
[null,"Kit","Catesby","Harrington","Kit Catesby Harrington"]

{"sheet":"CONCAT&IF","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining with CONCAT Function and If Condition"]
[]
[null,"First Name","Middle Name","Last Name","Concatenated"]
[null,"Elton","Hercules","John",{"$f":"_xlfn.CONCAT(B5,\" \",IF(ISBLANK(C5),\"\",C5),D5)","v":"Elton HerculesJohn"}]
[null,"Kate",null,"Hudson",{"$f":"_xlfn.CONCAT(B6,\" \",IF(ISBLANK(C6),\"\",C6),D6)","v":"Kate Hudson"}]
[null,"Tina","Stamatina","Fey","Tina StamatinaFey"]
[null,"Martin","Hayter","Short","Martin HayterShort"]
[null,"Hugh","Mungo","Grant","Hugh MungoGrant"]
[null,"Adele",null,"Blue","Adele Blue"]
[null,"Ben",null,"Affleck","Ben Affleck"]
[null,"Kit","Catesby","Harrington","Kit CatesbyHarrington"]

{"sheet":"TEXTJOIN&IF","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining Cells with TEXTJOIN Function and If Condition"]
[]
[null,"Name","Team",null,"Concatenated"]
[null,"Micael Jordan","Chicago Bulls",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF($C$5:$C$13=\"Chicago Bulls\",B5:B13,\"\"))","v":"Micael Jordan, Scottie Pippen, Derrick Rose"}]
[null,"Kobe Bryant","LA Lakers"]
[null,"Shaq O'Neal","LA Lakers"]
[null,"Scottie Pippen","Chicago Bulls"]
[null,"Chris Bosh","Miami Heat"]
[null,"Kareem Abdul-Jabbar","LA Lakers"]
[null,"Dwayne Wade","Miami Heat"]
[null,"Derrick Rose","Chicago Bulls"]
[null,"Magic Johnson","LA Lakers"]

{"sheet":"Another Column (2)","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining Cells If Same Value Exists in Another Column"]
[]
[null,"Team","Name"]
[null,"Chicago Bulls","Micael Jordan"]
[null,"LA Lakers","Kobe Bryant"]
[null,"LA Lakers","Shaq O'Neal"]
[null,"LA Lakers","Scottie Pippen"]
[null,"Miami Heat","Chris Bosh"]
[null,"Miami Heat","Kareem Abdul-Jabbar"]
[null,"Chicago Bulls","Dwayne Wade"]
[null,"Chicago Bulls","Derrick Rose"]
[null,"LA Lakers","Magic Johnson"]

{"sheet":"Another Column","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining Cells If Same Value Exists in Another Column"]
[]
[null,"Team","Name","Output"]
[null,"Chicago Bulls","Micael Jordan",{"$f":"IF(B5<>B4,C5,D4&\", \"&C5)","v":"Micael Jordan"}]
[null,"LA Lakers","Kobe Bryant",{"$f":"IF(B6<>B5,C6,D5&\", \"&C6)","v":"Kobe Bryant"}]
[null,"LA Lakers","Shaq O'Neal","Kobe Bryant, Shaq O'Neal"]
[null,"LA Lakers","Scottie Pippen","Kobe Bryant, Shaq O'Neal, Scottie Pippen"]
[null,"Miami Heat","Chris Bosh","Chris Bosh"]
[null,"Miami Heat","Kareem Abdul-Jabbar","Chris Bosh, Kareem Abdul-Jabbar"]
[null,"Chicago Bulls","Dwayne Wade","Dwayne Wade"]
[null,"Chicago Bulls","Derrick Rose","Dwayne Wade, Derrick Rose"]
[null,"LA Lakers","Magic Johnson","Magic Johnson"]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Combining Multiple Cells Based on User-Defined Function"]
[]
[null,"Team","Name",null,"Criteria","Concatenated"]
[null,"Chicago Bulls","Micael Jordan",null,{"$f":"_xlfn.UNIQUE(B5:B13)","v":"Chicago Bulls"},{"$f":"CONCATIF($B$5:$B$13,E5,$C$5:$C$13,\", \")","v":"Micael Jordan, Dwayne Wade, Derrick Rose"}]
[null,"LA Lakers","Kobe Bryant",null,"LA Lakers",{"$f":"CONCATIF($B$5:$B$13,E6,$C$5:$C$13,\", \")","v":"Kobe Bryant, Shaq O'Neal, Scottie Pippen, Magic Johnson"}]
[null,"LA Lakers","Shaq O'Neal",null,"Miami Heat",{"$f":"CONCATIF($B$5:$B$13,E7,$C$5:$C$13,\", \")","v":"Chris Bosh, Kareem Abdul-Jabbar"}]
[null,"LA Lakers","Scottie Pippen"]
[null,"Miami Heat","Chris Bosh"]
[null,"Miami Heat","Kareem Abdul-Jabbar"]
[null,"Chicago Bulls","Dwayne Wade"]
[null,"Chicago Bulls","Derrick Rose"]
[null,"LA Lakers","Magic Johnson"]

{"sheet":"CellNotBlank","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining If Cell Is Not Blank in Excel"]
[]
[null,"Name","Hometown",null,"Output"]
[null,"Elton","Boston",null,{"$f":"_xlfn.CONCAT(IF(ISBLANK(C5:C12),\"\",B5:B12))","v":"EltonTinaHughBenVictor"}]
[null,"Kate"]
[null,"Tina","Nashville"]
[null,"Martin"]
[null,"Hugh","Denver"]
[null,"Adele"]
[null,"Ben","San Diego"]
[null,"Victor","Chicago"]

{"sheet":"Multiple Criteria","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Combining Cells If Cells Match Multiple Criteria"]
[]
[null,"Name","Class","Team","Score","Output"]
[null,"Elton",11,"A",27,{"$f":"IF(C5=11,IF(D5=\"A\",_xlfn.CONCAT(B5,\": \",E5),\"\"),\"\")","v":"Elton: 27"}]
[null,"Kate",12,"A",12,{"$f":"IF(C6=11,IF(D6=\"A\",_xlfn.CONCAT(B6,\": \",E6),\"\"),\"\")","v":""}]
[null,"Tina",11,"A",21,"Tina: 21"]
[null,"Martin",11,"B",26,""]
[null,"Hugh",12,"B",20,""]
[null,"Adele",13,"C",24,""]
[null,"Ben",11,"A",25,"Ben: 25"]
[null,"Kit",11,"B",26,""]

{"sheet":"Multiple Criteria (2)","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Combining Cells If Cells Match Multiple Criteria"]
[]
[null,"Name","Class","Team","Score","Output"]
[null,"Elton",11,"A",27]
[null,"Kate",12,"A",12]
[null,"Tina",11,"A",21]
[null,"Martin",11,"B",26]
[null,"Hugh",12,"B",20]
[null,"Adele",13,"C",24]
[null,"Ben",11,"A",25]
[null,"Kit",11,"B",26]