{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Data Set","First and Last Name","Full Unique Names","UNIQUE & FILTER Functions","UNIQUE, FILTER, CONCATENATE","Conditional Formatting","IFERROR Function","Pivot Table","VBA Code"],"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":"Data Set","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Student ID","First Name","Last Name"]
[null,111,"Jack","Morris"]
[null,121,"Steve","Gibbs"]
[null,131,"Alen","Moor"]
[null,141,"Richard","Hick"]
[null,151,"Jack","North"]
[null,161,"Richard","Hick"]
[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":"First and Last Name","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Getting First and Last Name Using UNIQUE Function",null,null,null,null,null,"Practice"]
[]
[null,"Student ID","First Name","Last Name","Unique First Name","Unique Last Name",null,"Student ID","First Name","Last Name","Unique First Name","Unique Last Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(C5:D16,FALSE,TRUE)","v":"Jack"},"Morris",null,111,null,null,{"$f":"_xlfn.UNIQUE(I5:J16,FALSE,TRUE)","v":{"$error":"#VALUE!"}}]
[null,121,"Steve","Gibbs","Steve","Gibbs",null,121]
[null,131,"Alen","Moor","Jack","North",null,131]
[null,141,"Richard","Hick","Mike","Jennings",null,141]
[null,151,"Jack","North","Kane","Orwell",null,151]
[null,161,"Richard","Hick","Nicky","Butt",null,161]
[null,171,"Natalia ","Austin",null,null,null,171]
[null,181,"Natalia ","Austin",null,null,null,181]
[null,191,"Mike","Jennings",null,null,null,191]
[null,201,"Kane","Orwell",null,null,null,201]
[null,211,"Nicky","Butt",null,null,null,211]
[null,221,"Alen","Moor",null,null,null,221]

{"sheet":"Full Unique Names","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Getting Full Unique Names Using UNIQUE Function",null,null,null,null,"Practice"]
[]
[null,"Student ID","First Name","Last Name","Unique Name",null,"Student ID","First Name","Last Name","Unique Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(CONCATENATE(C5:C16,\" \",D5:D16),FALSE,TRUE)","v":"Jack Morris"},null,111,null,null,{"$f":"_xlfn.UNIQUE(CONCATENATE(H5:H16,\" \",I5:I16),FALSE,TRUE)","v":{"$error":"#VALUE!"}}]
[null,121,"Steve","Gibbs","Steve Gibbs",null,121]
[null,131,"Alen","Moor","Jack North",null,131]
[null,141,"Richard","Hick","Mike Jennings",null,141]
[null,151,"Jack","North","Kane Orwell",null,151]
[null,161,"Richard","Hick","Nicky Butt",null,161]
[null,171,"Natalia ","Austin",null,null,171]
[null,181,"Natalia ","Austin",null,null,181]
[null,191,"Mike","Jennings",null,null,191]
[null,201,"Kane","Orwell",null,null,201]
[null,211,"Nicky","Butt",null,null,211]
[null,221,"Alen","Moor",null,null,221]

{"sheet":"UNIQUE & FILTER Functions","index":3,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Combination of UNIQUE & FILTER Functions",null,null,null,null,null,"Practice"]
[]
[null,"Student ID","First Name","Last Name","Unique First Name","Unique Last Name",null,"Student ID","First Name","Last Name","Unique First Name","Unique Last Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(C5:D16,B5:B16>150,\"no result\"),FALSE,TRUE)","v":"Jack"},"North",null,111,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(I5:J16,H5:H16>150,\"no result\"),FALSE,TRUE)","v":{"$error":"#VALUE!"}}]
[null,121,"Steve","Gibbs","Richard","Hick",null,121]
[null,131,"Alen","Moor","Mike","Jennings",null,131]
[null,141,"Richard","Hick","Kane","Orwell",null,141]
[null,151,"Jack","North","Nicky","Butt",null,151]
[null,161,"Richard","Hick","Alen","Moor",null,161]
[null,171,"Natalia ","Austin",null,null,null,171]
[null,181,"Natalia ","Austin",null,null,null,181]
[null,191,"Mike","Jennings",null,null,null,191]
[null,201,"Kane","Orwell",null,null,null,201]
[null,211,"Nicky","Butt",null,null,null,211]
[null,221,"Alen","Moor",null,null,null,221]

{"sheet":"UNIQUE, FILTER, CONCATENATE","index":4,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Combination of UNIQUE & FILTER Functions with CONCATENATE",null,null,null,null,"Practice"]
[]
[null,"Student ID","First Name","Last Name","Unique Name",null,"Student ID","First Name","Last Name","Unique Name"]
[null,111,"Jack","Morris",{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(CONCATENATE(C5:C16,\" \",D5:D16),B5:B16>150,\"no result\"),\nFALSE,TRUE)","v":"Jack North"},null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(CONCATENATE(H5:H16,\" \",I5:I16),G5:G16>150,\"no result\"),FALSE,TRUE)","v":"no result"}]
[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":"Conditional Formatting","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,5,1,7],[3,5,3,7]]}
[]
[null,"Use of Conditional Formatting",null,null,null,"Practice"]
[]
[null,"Names",null,null,null,"Names"]
[null,"Garry","Shaun","Steve"]
[null,"Nathan","Nicky","Nathan"]
[null,"Christian","Garry","Steve"]
[null,"Natasha","Natasha","Mike"]
[null,"Georgina","Alisha","Ayesha"]
[null,"Lionel",null,"Jennifer"]
[null,"Steve",null,"Mathew"]
[null,null,null,"Georgina"]

{"sheet":"IFERROR Function","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,3]]}
[]
[null,"Use of IFERROR Function"]
[]
[null,"Names",null,null,null,"Unique Names"]
[null,"Garry","Shaun","Steve",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F4,$B$5:$B$11)=0), $B$5:$B$11),\nLOOKUP(2, 1/(COUNTIF($F$4:F4, $C$5:$C$9)=0), $C$5:$C$9)),\nLOOKUP(2, 1/(COUNTIF($F$4:F4, $D$5:$D$12)=0), $D$5:$D$12))","v":"Steve"}]
[null,"Nathan","Nicky","Nathan",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F5,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F5, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F5, $D$5:$D$12)=0), $D$5:$D$12))","v":"Lionel"}]
[null,"Christian","Garry","Steve",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F6,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F6, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F6, $D$5:$D$12)=0), $D$5:$D$12))","v":"Georgina"}]
[null,"Natasha","Natasha","Mike",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F7,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F7, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F7, $D$5:$D$12)=0), $D$5:$D$12))","v":"Natasha"}]
[null,"Georgina","Alisha","Ayesha",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F8,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F8, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F8, $D$5:$D$12)=0), $D$5:$D$12))","v":"Christian"}]
[null,"Lionel",null,"Jennifer",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F9,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F9, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F9, $D$5:$D$12)=0), $D$5:$D$12))","v":"Nathan"}]
[null,"Steve",null,"Mathew",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F10,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F10, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F10, $D$5:$D$12)=0), $D$5:$D$12))","v":"Garry"}]
[null,null,null,"Georgina",null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F11,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F11, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F11, $D$5:$D$12)=0), $D$5:$D$12))","v":"Alisha"}]
[null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F12,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F12, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F12, $D$5:$D$12)=0), $D$5:$D$12))","v":"Nicky"}]
[null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F13,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F13, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F13, $D$5:$D$12)=0), $D$5:$D$12))","v":"Shaun"}]
[null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F14,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F14, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F14, $D$5:$D$12)=0), $D$5:$D$12))","v":"Mathew"}]
[null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F15,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F15, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F15, $D$5:$D$12)=0), $D$5:$D$12))","v":"Jennifer"}]
[null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F16,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F16, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F16, $D$5:$D$12)=0), $D$5:$D$12))","v":"Ayesha"}]
[null,null,null,null,null,{"$f":"IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($F$4:F17,$B$5:$B$11)=0), $B$5:$B$11), LOOKUP(2, 1/(COUNTIF($F$4:F17, $C$5:$C$9)=0), $C$5:$C$9)),LOOKUP(2, 1/(COUNTIF($F$4:F17, $D$5:$D$12)=0), $D$5:$D$12))","v":"Mike"}]

{"sheet":"Pivot Table","index":7,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3]]}
[]
[null,"Use of Pivot Table"]
[]
[null,"Names",null,null,null,"Row Labels"]
[null,"Garry","Shaun","Steve",null,"Alisha"]
[null,"Nathan","Nicky","Nathan",null,"Ayesha"]
[null,"Christian","Garry","Steve",null,"Garry"]
[null,"Natasha","Natasha","Mike",null,"Georgina"]
[null,"Georgina","Alisha","Ayesha",null,"Jennifer"]
[null,"Lionel",null,"Jennifer",null,"Mathew"]
[null,"Steve",null,"Mathew",null,"Mike"]
[null,null,null,"Georgina",null,"Natasha"]
[null,null,null,null,null,"Nathan"]
[null,null,null,null,null,"Nicky"]
[null,null,null,null,null,"Steve"]
[null,null,null,null,null,"(blank)"]
[null,null,null,null,null,"Grand Total"]

{"sheet":"VBA Code","index":8,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[1,7,1,9],[3,7,3,9]]}
[]
[null,"Using VBA Code",null,null,null,null,null,"Practice"]
[]
[null,"Names",null,null,null,"Unique Names",null,"Names",null,null,null,"Unique Names"]
[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"]