{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["UNIQUE() Function","UNIQUE() and CONCATENATE()","UNIQUE() and FILTER()","UNIQUE, CONCAT and FILTER","IFERROR","PIVOT Table","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"UNIQUE() Function","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Student Record of Glory Kindergarten"]
[]
[null,"Student ID","First Name","Last Name","Unique First Name","Unique Last Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(C4:D15,FALSE,TRUE)","v":"Jack"},"Morris"]
[null,121,"Steve","Gibbs","Steve","Gibbs"]
[null,131,"Alen","Moor","Jack","North"]
[null,141,"Richard","Hick","Mike","Jennings"]
[null,151,"Jack","North","Kane","Orwell"]
[null,161,"Richard","Hick","Nicky","Butt"]
[null,171,"Natalia ","Austin"]
[null,181,"Natalia ","Austin"]
[null,191,"Mike","Jennings"]
[null,201,"Kane","Orwell"]
[null,211,"Nicky","Butt"]
[null,221,"Alen","Moor"]

{"sheet":"UNIQUE() and CONCATENATE()","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Student Record of Glory Kindergarten"]
[]
[null,"Student ID","First Name","Last Name","Unique Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(CONCATENATE(C4:C15,\" \",D4:D15),FALSE,TRUE)","v":"Jack Morris"}]
[null,121,"Steve","Gibbs","Steve Gibbs"]
[null,131,"Alen","Moor","Jack North"]
[null,141,"Richard","Hick","Mike Jennings"]
[null,151,"Jack","North","Kane Orwell"]
[null,161,"Richard","Hick","Nicky Butt"]
[null,171,"Natalia ","Austin"]
[null,181,"Natalia ","Austin"]
[null,191,"Mike","Jennings"]
[null,201,"Kane","Orwell"]
[null,211,"Nicky","Butt"]
[null,221,"Alen","Moor"]

{"sheet":"UNIQUE() and FILTER()","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Student Record of Glory Kindergarten"]
[]
[null,"Student ID","First Name","Last Name","Unique First Name","Unique Last Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(C4:D15,B4:B15>150,\"no result\"),FALSE,TRUE)","v":"Jack"},"North"]
[null,121,"Steve","Gibbs","Richard","Hick"]
[null,131,"Alen","Moor","Mike","Jennings"]
[null,141,"Richard","Hick","Kane","Orwell"]
[null,151,"Jack","North","Nicky","Butt"]
[null,161,"Richard","Hick","Alen","Moor"]
[null,171,"Natalia ","Austin"]
[null,181,"Natalia ","Austin"]
[null,191,"Mike","Jennings"]
[null,201,"Kane","Orwell"]
[null,211,"Nicky","Butt"]
[null,221,"Alen","Moor"]

{"sheet":"UNIQUE, CONCAT and FILTER","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Student Record of Glory Kindergarten"]
[]
[null,"Student ID","First Name","Last Name","Unique Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(CONCATENATE(C4:C15,\" \",D4:D15),B4:B15>150,\"no result\"),FALSE,TRUE)","v":"Jack North"}]
[null,121,"Steve","Gibbs","Richard Hick"]
[null,131,"Alen","Moor","Mike Jennings"]
[null,141,"Richard","Hick","Kane Orwell"]
[null,151,"Jack","North","Nicky Butt"]
[null,161,"Richard","Hick","Alen Moor"]
[null,171,"Natalia ","Austin"]
[null,181,"Natalia ","Austin"]
[null,191,"Mike","Jennings"]
[null,201,"Kane","Orwell"]
[null,211,"Nicky","Butt"]
[null,221,"Alen","Moor"]

{"sheet":"IFERROR","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Nick Names of Some Students"]
[null,null,null,null,null,null,"Unique Values"]
[null,"Garry","Shaun","Steve",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G2,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G2, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G2, $D$3:$D$10)=0), $D$3:$D$10))","v":"Steve"}]
[null,"Nathan","Nicky","Nathan",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G3,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G3, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G3, $D$3:$D$10)=0), $D$3:$D$10))","v":"Lionel"}]
[null,"Christian","Garry","Steve",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G4,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G4, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G4, $D$3:$D$10)=0), $D$3:$D$10))","v":"Georgina"}]
[null,"Natasha","Natasha","Mike",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G5,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G5, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G5, $D$3:$D$10)=0), $D$3:$D$10))","v":"Natasha"}]
[null,"Georgina","Alisha","Ayesha",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G6,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G6, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G6, $D$3:$D$10)=0), $D$3:$D$10))","v":"Christian"}]
[null,"Lionel",null,"Jennifer",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G7,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G7, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G7, $D$3:$D$10)=0), $D$3:$D$10))","v":"Nathan"}]
[null,"Steve",null,"Mathew",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G8,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G8, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G8, $D$3:$D$10)=0), $D$3:$D$10))","v":"Garry"}]
[null,null,null,"Georgina",null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G9,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G9, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G9, $D$3:$D$10)=0), $D$3:$D$10))","v":"Alisha"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G10,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G10, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G10, $D$3:$D$10)=0), $D$3:$D$10))","v":"Nicky"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G11,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G11, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G11, $D$3:$D$10)=0), $D$3:$D$10))","v":"Shaun"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G12,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G12, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G12, $D$3:$D$10)=0), $D$3:$D$10))","v":"Mathew"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G13,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G13, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G13, $D$3:$D$10)=0), $D$3:$D$10))","v":"Jennifer"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G14,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G14, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G14, $D$3:$D$10)=0), $D$3:$D$10))","v":"Ayesha"}]
[null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($G$2:G15,$B$3:$B$9)=0), $B$3:$B$9), LOOKUP(2, 1/(COUNTIF($G$2:G15, $C$3:$C$7)=0), $C$3:$C$7)),LOOKUP(2, 1/(COUNTIF($G$2:G15, $D$3:$D$10)=0), $D$3:$D$10))","v":"Mike"}]

{"sheet":"PIVOT Table","index":5,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Nick Names of Some Students"]
[]
[null,"Garry","Shaun","Steve",null,null,"Row Labels"]
[null,"Nathan","Nicky","Nathan",null,null,"Alisha"]
[null,"Christian","Garry","Steve",null,null,"Ayesha"]
[null,"Natasha","Natasha","Mike",null,null,"Christian"]
[null,"Georgina","Alisha","Ayesha",null,null,"Garry"]
[null,"Lionel",null,"Jennifer",null,null,"Georgina"]
[null,"Steve",null,"Mathew",null,null,"Jennifer"]
[null,null,null,"Georgina",null,null,"Lionel"]
[null,null,null,null,null,null,"Mathew"]
[null,null,null,null,null,null,"Mike"]
[null,null,null,null,null,null,"Natasha"]
[null,null,null,null,null,null,"Nathan"]
[null,null,null,null,null,null,"Nicky"]
[null,null,null,null,null,null,"Steve"]
[null,null,null,null,null,null,"(blank)"]
[null,null,null,null,null,null,"Grand Total"]

{"sheet":"VBA","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Nick Names of Some Students"]
[]
[null,"Garry","Shaun","Steve",null,"Garry"]
[null,"Nathan","Nicky","Nathan",null,"Shaun"]
[null,"Christian","Garry","Steve",null,"Steve"]
[null,"Natasha","Natasha","Mike",null,"Nathan"]
[null,"Georgina","Alisha","Ayesha",null,"Nicky"]
[null,"Lionel",null,"Jennifer",null,"Christian"]
[null,"Steve",null,"Mathew",null,"Natasha"]
[null,null,null,"Georgina",null,"Mike"]
[null,null,null,null,null,"Georgina"]
[null,null,null,null,null,"Alisha"]
[null,null,null,null,null,"Ayesha"]
[null,null,null,null,null,"Lionel"]
[null,null,null,null,null,"Jennifer"]
[null,null,null,null,null,"Mathew"]