{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Podcast Content","ByColumn","Wrap Up"],"not_rendered":{"charts":0,"images":10,"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,2246]

{"sheet":"Podcast Content","index":1,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Artist",null,"Unique List (Distinct)",null,null,"Unique List (occurs once)",null,null,null,"Revisiting"]
["The Beatles",null,{"$f":"_xlfn.UNIQUE(A2:A12)","v":"The Beatles"},null,null,{"$f":"_xlfn.UNIQUE(A2:A12,,TRUE)","v":"Los Del Rio"}]
["Elvis",null,"Elvis",null,null,"Vanilla Ice"]
["Los Del Rio",null,"Los Del Rio",null,null,"Toni Basil"]
["Vanilla Ice",null,"Vanilla Ice",null,null,"Dexys Midnight Runners"]
["The Beatles",null,"Toni Basil",null,null,"Soft Cell"]
["Elvis",null,"Dexys Midnight Runners"]
["Toni Basil",null,"Soft Cell"]
["Dexys Midnight Runners"]
["Soft Cell"]
["Elvis"]
["The Beatles"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,3108]
[null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L48/L47","v":1.3513513513513514E-2}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/L49","v":74}]

{"sheet":"ByColumn","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Unique Sorted List of Ingredients For Each Row"]
["Banana","Banana","Date","Jackfruit","Mango","Mango",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A2:G2,TRUE)))","v":"Banana, Date, Jackfruit, Mango"}]
["Fig","Lime","Jackfruit","Iceberg","Elderberry","Cherry",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A3:G3,TRUE)))","v":"Fig, Lime, Jackfruit, Iceberg, Elderberry, Cherry"}]
["Fig","Elderberry","Lime","Elderberry","Mango",null,null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A4:G4,TRUE)))","v":"Fig, Elderberry, Lime, Mango"}]
["Honeydew","Apple","Date","Nectarine","Honeydew","Iceberg",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A5:G5,TRUE)))","v":"Honeydew, Apple, Date, Nectarine, Iceberg"}]
["Jackfruit","Jackfruit","Nectarine","Cherry","Kiwi","Date",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A6:G6,TRUE)))","v":"Jackfruit, Nectarine, Cherry, Kiwi, Date"}]
["Elderberry","Fig","Orange","Nectarine","Fig","Fig",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A7:G7,TRUE)))","v":"Elderberry, Fig, Orange, Nectarine"}]
["Jackfruit","Fig","Iceberg","Iceberg",null,null,null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A8:G8,TRUE)))","v":"Jackfruit, Fig, Iceberg"}]
["Iceberg","Orange","Nectarine","Fig","Banana","Apple",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A9:G9,TRUE)))","v":"Iceberg, Orange, Nectarine, Fig, Banana, Apple"}]
["Banana","Banana","Date","Jackfruit","Mango","Lime",null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A10:G10,TRUE)))","v":"Banana, Date, Jackfruit, Mango, Lime"}]
["Honeydew","Lime","Kiwi","Honeydew","Jackfruit","Iceberg","Iceberg",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn._xlws.SORT(_xlfn.UNIQUE(A11:G11,TRUE)))","v":"Honeydew, Lime, Kiwi, Jackfruit, Iceberg"}]

{"sheet":"Wrap Up","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[null,"The new UNIQUE dynamic array function can return either DISTINCT or UNIQUE"]
[null,"If you don't specify the second or third argument, you get a list of distinct values"]
[null,"Specify True for third argument, and you get the items that occur just once"]
[null,"For the second argument, you can do UNIQUE across the columns"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To download this workbook: https://www.mrexcel.com/download-center/2018/10/find-one-hit-wonders-with-unique.xlsm"]
[null,"List of upcoming seminars: https://www.mrexcel.com/press-appearances/"]
[]
[null,"To download the workbook from today's video, visit the URL in the YouTube description"]
[]
[null,"Title Image Photo Credit: Photo by Shu xin on Unsplash"]