{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Excel Table","Excel Table - UDF","Excel Table - 365","Autofilter - 365"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":"Excel Table","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Address","Country"]
["Kaya","Downs","1566 View Street","Finland"]
["Fraser","Curran","2708 Oak Road","Finland"]
["Jui","Petit","6191 Maple Street","Germany"]
["Cyril","Kurtz","2071 Ninth Road","San Marino"]
["Spencer","Alexander","1874 Lake Circle","Slovakia"]
["Horace","Shapiro","1073 Eighth Road","Germany"]
["Emmit","Maki","3276 Pine Boulevard","San Marino"]
["Lynna","Croft","18 Hill Circle","Madagascar"]
["Charley","Gaston","1016 Fifth Avenue","Romania"]
["Fraser","Parham","4736 Main Circle","Mexico"]
["Mckinley","Mcclung","1177 Hill Avenue","Thailand"]
["Tiara","Hoffman","6237 Eighth Avenue","Sao Tome and Principe"]
["Damien","Baughman","616 Cedar Circle","Indonesia"]
["Linnie","Quinn","6001 Maple Street","Poland"]
["Jui","Champagne","5667 Pine Avenue","Mexico"]
["Fraser","Stoddard","2254 Fourth Street","Germany"]
["Siena","Lear","1187 First Avenue","Egypt"]
["Lynna","Carmona","4532 Washington Avenue","Brazil"]
["Kelton","Riddle","3772 Main Boulevard","Germany"]
["Kaya","Spring","3147 Second Boulevard","Mexico"]
[]
["Unique distinct values from column A in table above"]
[]
[null,"Array formula"]
[null,{"$f":"INDEX(Table2[First Name],MATCH(0,IF(SUBTOTAL(3, OFFSET(Table2[First Name], MATCH(ROW(Table2[First Name]), ROW(Table2[First Name]))-1, 0, 1)),COUNTIF($B$25:B25,Table2[First Name]),\"\"),0))","v":"Kaya"}]
[null,{"$f":"INDEX(Table2[First Name],MATCH(0,IF(SUBTOTAL(3, OFFSET(Table2[First Name], MATCH(ROW(Table2[First Name]), ROW(Table2[First Name]))-1, 0, 1)),COUNTIF($B$25:B26,Table2[First Name]),\"\"),0))","v":"Fraser"}]
[null,{"$f":"INDEX(Table2[First Name],MATCH(0,IF(SUBTOTAL(3, OFFSET(Table2[First Name], MATCH(ROW(Table2[First Name]), ROW(Table2[First Name]))-1, 0, 1)),COUNTIF($B$25:B27,Table2[First Name]),\"\"),0))","v":"Jui"}]
[null,{"$f":"INDEX(Table2[First Name],MATCH(0,IF(SUBTOTAL(3, OFFSET(Table2[First Name], MATCH(ROW(Table2[First Name]), ROW(Table2[First Name]))-1, 0, 1)),COUNTIF($B$25:B28,Table2[First Name]),\"\"),0))","v":"Horace"}]
[null,{"$f":"INDEX(Table2[First Name],MATCH(0,IF(SUBTOTAL(3, OFFSET(Table2[First Name], MATCH(ROW(Table2[First Name]), ROW(Table2[First Name]))-1, 0, 1)),COUNTIF($B$25:B29,Table2[First Name]),\"\"),0))","v":"Kelton"}]

{"sheet":"Excel Table - UDF","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Address","Country"]
["Kaya","Downs","1566 View Street","Finland"]
["Fraser","Curran","2708 Oak Road","Finland"]
["Jui","Petit","6191 Maple Street","Germany"]
["Cyril","Kurtz","2071 Ninth Road","San Marino"]
["Spencer","Alexander","1874 Lake Circle","Slovakia"]
["Horace","Shapiro","1073 Eighth Road","Germany"]
["Emmit","Maki","3276 Pine Boulevard","San Marino"]
["Lynna","Croft","18 Hill Circle","Madagascar"]
["Charley","Gaston","1016 Fifth Avenue","Romania"]
["Fraser","Parham","4736 Main Circle","Mexico"]
["Mckinley","Mcclung","1177 Hill Avenue","Thailand"]
["Tiara","Hoffman","6237 Eighth Avenue","Sao Tome and Principe"]
["Damien","Baughman","616 Cedar Circle","Indonesia"]
["Linnie","Quinn","6001 Maple Street","Poland"]
["Jui","Champagne","5667 Pine Avenue","Mexico"]
["Fraser","Stoddard","2254 Fourth Street","Germany"]
["Siena","Lear","1187 First Avenue","Egypt"]
["Lynna","Carmona","4532 Washington Avenue","Brazil"]
["Kelton","Riddle","3772 Main Boulevard","Germany"]
["Kaya","Spring","3147 Second Boulevard","Mexico"]
[]
["Unique distinct values from column A in table above"]
[]
["Udf"]
[{"$f":"FilterUniqueSortTable(Table22[First Name])","v":{"$error":"#NAME?"}}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]
[{"$error":"#NAME?"}]

{"sheet":"Excel Table - 365","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Address","Country"]
["Kaya","Downs","1566 View Street","Finland"]
["Fraser","Curran","2708 Oak Road","Finland"]
["Jui","Petit","6191 Maple Street","Germany"]
["Cyril","Kurtz","2071 Ninth Road","San Marino"]
["Spencer","Alexander","1874 Lake Circle","Slovakia"]
["Horace","Shapiro","1073 Eighth Road","Germany"]
["Emmit","Maki","3276 Pine Boulevard","San Marino"]
["Lynna","Croft","18 Hill Circle","Madagascar"]
["Charley","Gaston","1016 Fifth Avenue","Romania"]
["Fraser","Parham","4736 Main Circle","Mexico"]
["Mckinley","Mcclung","1177 Hill Avenue","Thailand"]
["Tiara","Hoffman","6237 Eighth Avenue","Sao Tome and Principe"]
["Damien","Baughman","616 Cedar Circle","Indonesia"]
["Linnie","Quinn","6001 Maple Street","Poland"]
["Jui","Champagne","5667 Pine Avenue","Mexico"]
["Fraser","Stoddard","2254 Fourth Street","Germany"]
["Siena","Lear","1187 First Avenue","Egypt"]
["Lynna","Carmona","4532 Washington Avenue","Brazil"]
["Kelton","Riddle","3772 Main Boulevard","Germany"]
["Kaya","Spring","3147 Second Boulevard","Mexico"]
[]
["Unique distinct values from column A in table above"]
[]
[null,"Array formula"]
[null,{"$f":"_xlfn.LET(_xlpm.x,Table24[First Name],_xlfn.UNIQUE(_xlfn._xlws.FILTER(_xlpm.x,SUBTOTAL(3, OFFSET(_xlpm.x,_xlfn.SEQUENCE(ROWS(_xlpm.x))-1, 0, 1)))))","v":"Kaya"}]
[null,"Fraser"]
[null,"Jui"]
[null,"Horace"]
[null,"Kelton"]
[]
[]
[]
[]
[]
[]
[]
["=FILTER(Table2[First Name],\nSUBTOTAL(3, OFFSET(Table2[First Name],\nMATCH(ROW(Table2[First Name]), ROW(Table2[First Name]))-1, 0, 1))\n)"]

{"sheet":"Autofilter - 365","index":3,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Address","Country"]
["Kaya","Downs","1566 View Street","Finland"]
["Fraser","Curran","2708 Oak Road","Finland"]
["Jui","Petit","6191 Maple Street","Germany"]
["Cyril","Kurtz","2071 Ninth Road","San Marino"]
["Spencer","Alexander","1874 Lake Circle","Slovakia"]
["Horace","Shapiro","1073 Eighth Road","Germany"]
["Emmit","Maki","3276 Pine Boulevard","San Marino"]
["Lynna","Croft","18 Hill Circle","Madagascar"]
["Charley","Gaston","1016 Fifth Avenue","Romania"]
["Fraser","Parham","4736 Main Circle","Mexico"]
["Mckinley","Mcclung","1177 Hill Avenue","Thailand"]
["Tiara","Hoffman","6237 Eighth Avenue","Sao Tome and Principe"]
["Damien","Baughman","616 Cedar Circle","Indonesia"]
["Linnie","Quinn","6001 Maple Street","Poland"]
["Jui","Champagne","5667 Pine Avenue","Mexico"]
["Fraser","Stoddard","2254 Fourth Street","Germany"]
["Siena","Lear","1187 First Avenue","Egypt"]
["Lynna","Carmona","4532 Washington Avenue","Brazil"]
["Kelton","Riddle","3772 Main Boulevard","Germany"]
["Kaya","Spring","3147 Second Boulevard","Mexico"]
[]
["Unique distinct values from column A in table above"]
[]
[null,"Array formula",null,"Excel 365"]
[null,{"$f":"INDEX('Autofilter - 365'!$A$2:$A$21,MATCH(0,IF(SUBTOTAL(3, OFFSET('Autofilter - 365'!$A$2:$A$21, MATCH(ROW('Autofilter - 365'!$A$2:$A$21), ROW('Autofilter - 365'!$A$2:$A$21))-1, 0, 1)),COUNTIF($B$25:B25,'Autofilter - 365'!$A$2:$A$21),\"\"),0))","v":"Kaya"},null,{"$f":"_xlfn.LET(_xlpm.x,'Autofilter - 365'!$A$2:$A$21,_xlfn.UNIQUE(_xlfn._xlws.FILTER(_xlpm.x,SUBTOTAL(3, OFFSET(_xlpm.x,_xlfn.SEQUENCE(ROWS(_xlpm.x))-1, 0, 1))))\n)","v":"Kaya"}]
[null,{"$f":"INDEX('Autofilter - 365'!$A$2:$A$21,MATCH(0,IF(SUBTOTAL(3, OFFSET('Autofilter - 365'!$A$2:$A$21, MATCH(ROW('Autofilter - 365'!$A$2:$A$21), ROW('Autofilter - 365'!$A$2:$A$21))-1, 0, 1)),COUNTIF($B$25:B26,'Autofilter - 365'!$A$2:$A$21),\"\"),0))","v":"Fraser"},null,"Fraser"]
[null,{"$f":"INDEX('Autofilter - 365'!$A$2:$A$21,MATCH(0,IF(SUBTOTAL(3, OFFSET('Autofilter - 365'!$A$2:$A$21, MATCH(ROW('Autofilter - 365'!$A$2:$A$21), ROW('Autofilter - 365'!$A$2:$A$21))-1, 0, 1)),COUNTIF($B$25:B27,'Autofilter - 365'!$A$2:$A$21),\"\"),0))","v":"Jui"},null,"Jui"]
[null,{"$f":"INDEX('Autofilter - 365'!$A$2:$A$21,MATCH(0,IF(SUBTOTAL(3, OFFSET('Autofilter - 365'!$A$2:$A$21, MATCH(ROW('Autofilter - 365'!$A$2:$A$21), ROW('Autofilter - 365'!$A$2:$A$21))-1, 0, 1)),COUNTIF($B$25:B28,'Autofilter - 365'!$A$2:$A$21),\"\"),0))","v":"Horace"},null,"Horace"]
[null,{"$f":"INDEX('Autofilter - 365'!$A$2:$A$21,MATCH(0,IF(SUBTOTAL(3, OFFSET('Autofilter - 365'!$A$2:$A$21, MATCH(ROW('Autofilter - 365'!$A$2:$A$21), ROW('Autofilter - 365'!$A$2:$A$21))-1, 0, 1)),COUNTIF($B$25:B29,'Autofilter - 365'!$A$2:$A$21),\"\"),0))","v":"Kelton"},null,"Kelton"]