{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Goal","BillTry","MikeTry","Wrap Up"],"not_rendered":{"charts":0,"images":7,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,183]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: mikesween / Pixabay"]

{"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":"BillTry","index":2,"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$9)","v":"Low Oil, Checked on 12/12"}]
[109876,"Checked on 12/12",null,null,109877,{"$f":"getall(E3,$A$2:$A$9)","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,{"$f":"getall(E5,$A$2:$A$19)","v":"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":3,"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":"Wrap Up","index":4,"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!"]