{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Goal","Try","BillTry","MikeTry","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"Title","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,183]

{"sheet":"Goal","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ID","Comment"]
[109876,"Low Oil"]
[109876,"Checked on 12/12"]
[109877,"Checked on 12/12"]
[109878,"Correct Level"]
[109877,"Correct Level"]
[109878,"Perfect"]
[109877,"New"]
[109878,"Correct Level"]

{"sheet":"Try","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ID","Comment"]
[109876,"Low Oil"]
[109876,"Checked on 12/12"]
[109877,"Checked on 12/12"]
[109878,"Correct Level"]
[109877,"Correct Level"]
[109878,"Perfect"]
[109877,"New"]
[109878,"Correct Level"]

{"sheet":"BillTry","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["ID","Comment",null,null,"ID"]
[109876,"Low Oil",null,null,109876,{"$f":"getall(E2,$A$2:$A$19)","v":"Low Oil, Checked on 12/12"}]
[109876,"Checked on 12/12",null,null,109877,{"$f":"getall(E3,$A$2:$A$19)","v":"Checked on 12/12, Correct Level, New"}]
[109877,"Checked on 12/12",null,null,109878,"Correct Level, Perfect, Correct Level"]
[109878,"Correct Level",null,null,109999,"Phrase 1, Phrase 2, Phrase 3, Phrase 4, Phrase 5, Phrase 6, Phrase 7, Phrase 8, Phrase 9, Phrase 10"]
[109877,"Correct Level"]
[109878,"Perfect"]
[109877,"New"]
[109878,"Correct Level"]
[109999,"Phrase 1"]
[109999,"Phrase 2"]
[109999,"Phrase 3"]
[109999,"Phrase 4"]
[109999,"Phrase 5"]
[109999,"Phrase 6"]
[109999,"Phrase 7"]
[109999,"Phrase 8"]
[109999,"Phrase 9"]
[109999,"Phrase 10"]

{"sheet":"MikeTry","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["ID","Comment",null,"ID","All Comments"]
[109876,"Low Oil",null,109876,{"$f":"_xlfn.TEXTJOIN(\", \",,IF(OilChangeData[ID]=D2,OilChangeData[Comment],\"\"))","v":"Low Oil, Checked on 12/12"}]
[109876,"Checked on 12/12",null,109877,{"$f":"_xlfn.TEXTJOIN(\", \",,IF(OilChangeData[ID]=D3,OilChangeData[Comment],\"\"))","v":"Checked on 12/12, Correct Level, New"}]
[109877,"Checked on 12/12",null,109878,{"$f":"_xlfn.TEXTJOIN(\", \",,IF(OilChangeData[ID]=D4,OilChangeData[Comment],\"\"))","v":"Correct Level, Perfect, Correct Level"}]
[109878,"Correct Level",null,109999,{"$f":"_xlfn.TEXTJOIN(\", \",,IF(OilChangeData[ID]=D5,OilChangeData[Comment],\"\"))","v":"Checked 5/2/2017, Windshield Wipers"}]
[109877,"Correct Level",null,200000,{"$f":"_xlfn.TEXTJOIN(\", \",,IF(OilChangeData[ID]=D6,OilChangeData[Comment],\"\"))","v":"Check 5/3/2017, Perfect"}]
[109878,"Perfect"]
[109877,"New"]
[109878,"Correct Level"]
[109999,"Checked 5/2/2017"]
[109999,"Windshield Wipers"]
[200000,"Check 5/3/2017"]
[200000,"Perfect"]

{"sheet":"Wrap Up","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Goal is to concatenate all of the text answers from a VLOOKUP"]
[null,"Bill's method: Use a VBA Function called GetAll"]
[null,"Unique list using Remove Duplicates"]
[null,"Mike's method:"]
[null,"Unique list using Advanced Filter"]
[null,"TEXTJOIN function added in Office 365"]
[null,"TEXTJOIN(\", \",,IF(OilChangeData[ID]=D2,OilChangeData[Comment],\"\"))"]
[null,"Because of the IF function, the formula requires Ctrl+Shift+Enter any time you edit the formula"]
[null,"Alt A Q O R Enter will re-run the Advanced Filter!"]