{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Home Page","Dataset 1","1.1 CF(Duplicate Values)","1.2 CF(COUNTIF)","1.3 CF(Triplicates)","Dataset 2","1.4 CF(two WS)","1.5 CF(Rows)","2.1 COUNTIF","2.2 IF+COUNTIF","3.1 COUNTIF","3.2 SUM","3.3 IF+SUM","3.4 COUNTIFS","3.5 SUMPRODUCT","4..1 IF+COUNTIFS","4.2 SUMPRODUCT","5. Excl. 1st","6. Case Sensitive","7.1a From Two List(IFERR+VLOOK)","7.1b From Two List(UNI+FIL)","7.2 From Three List","8. Between Two WS","9. Betwen Two WB","10. VBA Macro","11.1 Return(IF+COUNTIF)","11.2 Return(UNIQUE+FILTER)","11.3 Return(VLOOKUP+COUNTIF)","Select,Copy,Move, Remove,Hide","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"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":"Home Page","index":0,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Find Duplicates in Excel"]
[]
[null,"Learn to find duplicates with this free workbook. Read the article and practice yourself."]
[]
[null,"Prepared By","MD Tanvir Rahman"]
[null,"Last Update","2023-11-23"]
[null,"Reviewed By","Nehad Ulfat"]
[null,"Article Link","https://www.exceldemy.com/learn-excel/data-cleaning/find-duplicates/"]
[]
[null,"Methods"]
[null,"1. Using Conditional Formatting to Find & Highlight Duplicates in Excel"]
[null,null,"i. Highlighting Duplicates in Excel with Duplicate Values Command"]
[null,null,"ii.  Getting Duplicate Values with COUNTIF Function"]
[null,null,"iii. Finding & Highlighting Triplicate Cells (3 Occurrences)"]
[null,null,"iv. Highlighting Duplicate Values from Two Different Worksheets"]
[null,null,"v. Applying COUNTIFS Function to Find & Highlight Duplicate Rows"]
[null,"2. Using Excel Formula to Find Duplicate Values and Return Conditional Outputs"]
[null,null,"i. Applying COUNTIF Function to Find Duplicate Values and Return TRUE or FALSE"]
[null,null,"ii. Combining IF and COUNTIF Functions and Return the Text ‘Duplicate’"]
[null,"3. Returning the Number of Occurrences & Finding Duplicates in Excel"]
[null,null,"i. Finding Number of Duplicate Instances with COUNTIF Function"]
[null,null,"ii. Using SUM Function to Count Duplicate Occurrences"]
[null,null,"iii. Joining IF and SUM Functions to Count Duplicates"]
[null,null,"iv. Counting Number of Duplicate Rows with COUNTIFS Function"]
[null,null,"v. Using SUMPRODUCT Function to Find Number of Duplicate Rows"]
[null,"4. Using Excel Functions to Find Duplicate Rows From Two or Multiple Columns"]
[null,null,"i. Combining IF and COUNTIFS Function to Find Duplicate Rows"]
[null,null,"ii. Joining IF &  SUMPRODUCT Functions to Find Duplicate Rows"]
[null,"5. Finding Duplicates in a Column Excluding 1st Occurrence"]
[null,"6. Finding Case-Sensitive Duplicates with Excel Formula"]
[null,"7. Finding Duplicates from Two or Three Columns in Excel"]
[null,null,"7.1. From Two Columns"]
[null,null,null,"i. Using VLOOKUP Function"]
[null,null,null,"ii. Combining UNIQUE, FILTER and COUNTIF Functions"]
[null,null,"7.2. From Three or More Columns"]
[null,"8. Finding Duplicate Values Across Two Sheets in Excel"]
[null,"9. Finding Duplicates Between Two Excel Workbooks"]
[null,"10. Applying VBA Macro to Find Duplicates in Excel"]
[null,"11. Applying Excel Formula to Find & Return Duplicate Values"]
[null,null,"i. Combining IF and COUNTIF Functions to Get Duplicate Values"]
[null,null,"ii. Combining UNIQUE, FILTER and COUNTIF Functions to Return Duplicate Values Only Once"]
[null,null,"iii. Joining IFERROR and VLOOKUP Functions to Return Duplicates from Two Sheets"]
[null,"How to Select, Copy, Move, Remove or Hide Duplicates in Excel after Finding Them?"]

{"sheet":"Dataset 1","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates in Excel"]
[]
[null,"Sample Dataset"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000]
[null,"A432","Usman Khaja",2018,18000]
[null,"A101","Steve Moor",2021,28000]
[null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Usman Khaja",2017,30000]
[null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Khan",2021,25000]
[null,"A432","Usman Khaja",2018,18000]
[]
[]
[null,"Home Page"]

{"sheet":"1.1 CF(Duplicate Values)","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates with Conditional Formatting Tool"]
[]
[null,"Using Duplicate Values Command",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Pro Tips:",null,null,null,"Employee Name"]
[null,"Morris King",null,"1. Click Home => Conditional Formatting",null,null,null,"Morris King"]
[null,"John Smith",null,"2.Select Highlight Cell Rules => Duplicate Values",null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"3. Select Duplicate and Choose color.",null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,null,null,null,null,"usman khaja"]
[null,"Steve Moor",null,null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,"Usman Khaja"]
[]
[]
[null,"Home Page"]

{"sheet":"1.2 CF(COUNTIF)","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates with Conditional Formatting Tool"]
[]
[null,"Using COUNTIF Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Pro Tips:",null,null,null,null,null,"Employee Name"]
[null,"Morris King",null,"1. Click Home => Conditional Formatting => New Rule",null,null,null,null,null,"Morris King"]
[null,"John Smith",null,"2. Select Use a formula to Determine which cells to format",null,null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"3. Insert formula and select cell Fill Color.",null,null,null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,null,null,null,null,null,null,"usman khaja"]
[null,"Steve Moor",null,null,null,null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,null,null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,null,null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,null,null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,null,null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,null,null,null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,null,null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,null,null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,null,null,"Usman Khaja"]
[]
[]
[null,"Home Page"]

{"sheet":"1.3 CF(Triplicates)","index":4,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates with Conditional Formatting Tool"]
[]
[null,"Finding Triplicates",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Pro Tips:",null,null,null,null,null,"Employee Name"]
[null,"Morris King",null,"1. Click Home => Conditional Formatting => New Rule",null,null,null,null,null,"Morris King"]
[null,"John Smith",null,"2. Select Use a formula to Determine which cells to format",null,null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"3. Insert formula and select cell Fill Color.",null,null,null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,null,null,null,null,null,null,"usman khaja"]
[null,"Steve Moor",null,null,null,null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,null,null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,null,null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,null,null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,null,null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,null,null,null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,null,null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,null,null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,null,null,"Usman Khaja"]
[]
[]
[null,"Home Page"]

{"sheet":"Dataset 2","index":5,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Dataset"]
[]
[null,"Employee Name"]
[null,"Benjamin Russel"]
[null,"Steve Austin"]
[null,"Stephen Dulbarg"]
[null,"Usman Khaja"]
[null,"Steve Moor"]
[null,"Wilfred Chomosky"]
[null,"Emily Sparkle"]
[null,"Jacky Chan"]
[null,"Alisha Stokes"]
[null,"Gregory Mills"]
[null,"Kane Simpson"]
[null,"Aujeeta Milia"]
[]
[]
[null,"Home Page"]

{"sheet":"1.4 CF(two WS)","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates with Conditional Formatting Tool"]
[]
[null,"Highlighting Duplicates from Two Different Sheets (Dataset 2)",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Pro Tips:",null,null,null,"Employee Name"]
[null,"Morris King",null,"1. Click Home => Conditional Formatting => New Rule",null,null,null,"Morris King"]
[null,"John Smith",null,"2. Select Use a formula to Determine which cells to format",null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"3. Insert formula and select cell Fill Color.",null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,null,null,null,null,"Usman Khaja"]
[null,"Steve Moor",null,"Note:",null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,"We are using Dataset 2 as another worksheet.",null,null,null,"Natasha Marlo"]
[null,"Jack Alfred",null,null,null,null,null,"Jack Alfred"]
[null,"Benjamin Hick",null,null,null,null,null,"Benjamin Hick"]
[null,"Kane Simpson",null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,null,null,null,null,"Irfan Khan"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"1.5 CF(Rows)","index":7,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates with Conditional Formatting Tool"]
[]
[null,"Finding Duplicate Rows with COUNTIFS Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Pro Tips:",null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,null,"1. Click Home => Conditional Formatting => New Rule",null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,"2. Select Use a formula to Determine which cells to format",null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,"3. Insert formula and select cell Fill Color.",null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","usman khaja",2018,18000,null,null,null,null,null,"A432","usman khaja",2018,18000]
[null,"A101","Steve Moor",2021,28000,null,null,null,null,null,"A101","Steve Moor",2021,28000]
[null,"A178","Natasha Marlo",2019,25000,null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Usman Khaja",2017,30000,"<< Ignored",null,null,null,null,"A452","Usman Khaja",2017,30000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Khan",2021,25000,null,null,null,null,null,"A099","Irfan Khan",2021,25000]
[null,"A432","Usman Khaja",2018,18000,null,null,null,null,null,"A432","Usman Khaja",2018,18000]
[]
[]
[]
[null,"Home Page"]

{"sheet":"2.1 COUNTIF","index":8,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicate Values with Excel Formula"]
[]
[null,"Applying COUNTIF Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Duplicate?",null,null,null,"Employee Name","Duplicate?"]
[null,"Morris King",{"$f":"COUNTIF($B:$B,B6)>1","v":true},null,null,null,"Morris King"]
[null,"John Smith",{"$f":"COUNTIF($B:$B,B7)>1","v":false},null,null,null,"John Smith"]
[null,"Alisha Stokes",true,null,null,null,"Alisha Stokes"]
[null,"usman khaja",true,null,null,null,"Usman Khaja"]
[null,"Steve Moor",false,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",false,null,null,null,"Natasha Marlo"]
[null,"Morris King",true,null,null,null,"Morris King"]
[null,"Jack Alfred",false,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",true,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",false,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",true,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",false,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",false,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",true,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"2.2 IF+COUNTIF","index":9,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicate Values with Excel Formula"]
[]
[null,"Combining IF and COUNTIF Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Duplicate?",null,null,null,null,"Employee Name","Duplicate?"]
[null,"Morris King",{"$f":"IF(COUNTIF($B$6:$B$19,$B6)>1,\"Duplicate\",\"\")","v":"Duplicate"},null,null,null,null,"Morris King"]
[null,"John Smith",{"$f":"IF(COUNTIF($B$6:$B$19,$B7)>1,\"Duplicate\",\"\")","v":""},null,null,null,null,"John Smith"]
[null,"Alisha Stokes","Duplicate",null,null,null,null,"Alisha Stokes"]
[null,"usman khaja","Duplicate",null,null,null,null,"Usman Khaja"]
[null,"Steve Moor","",null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo","",null,null,null,null,"Natasha Marlo"]
[null,"Morris King","Duplicate",null,null,null,null,"Morris King"]
[null,"Jack Alfred","",null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes","Duplicate",null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick","",null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja","Duplicate",null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson","",null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan","",null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja","Duplicate",null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"3.1 COUNTIF","index":10,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates and Return Number of Occurrences"]
[]
[null,"Using COUNTIF Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Number of Occurrence",null,null,null,"Employee Name","Number of Occurrence"]
[null,"Morris King",{"$f":"COUNTIF($B$6:$B$19,$B6)","v":2},null,null,null,"Morris King"]
[null,"John Smith",{"$f":"COUNTIF($B$6:$B$19,$B7)","v":1},null,null,null,"John Smith"]
[null,"Alisha Stokes",2,null,null,null,"Alisha Stokes"]
[null,"usman khaja",3,null,null,null,"Usman Khaja"]
[null,"Steve Moor",1,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",1,null,null,null,"Natasha Marlo"]
[null,"Morris King",2,null,null,null,"Morris King"]
[null,"Jack Alfred",1,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",2,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",1,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",3,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",1,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",1,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",3,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"3.2 SUM","index":11,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates and Return Number of Occurrences"]
[]
[null,"Using SUM Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Number of Occurrence",null,null,null,"Employee Name","Number of Occurrence"]
[null,"Morris King",{"$f":"SUM(--($B$6:$B$19 = $B6))","v":2},null,null,null,"Morris King"]
[null,"John Smith",{"$f":"SUM(--($B$6:$B$19 = $B7))","v":1},null,null,null,"John Smith"]
[null,"Alisha Stokes",{"$f":"SUM(--($B$6:$B$19 = $B8))","v":2},null,null,null,"Alisha Stokes"]
[null,"usman khaja",{"$f":"SUM(--($B$6:$B$19 = $B9))","v":3},null,null,null,"Usman Khaja"]
[null,"Steve Moor",{"$f":"SUM(--($B$6:$B$19 = $B10))","v":1},null,null,null,"Steve Moor"]
[null,"Natasha Marlo",{"$f":"SUM(--($B$6:$B$19 = $B11))","v":1},null,null,null,"Natasha Marlo"]
[null,"Morris King",{"$f":"SUM(--($B$6:$B$19 = $B12))","v":2},null,null,null,"Morris King"]
[null,"Jack Alfred",{"$f":"SUM(--($B$6:$B$19 = $B13))","v":1},null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",{"$f":"SUM(--($B$6:$B$19 = $B14))","v":2},null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",{"$f":"SUM(--($B$6:$B$19 = $B15))","v":1},null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",{"$f":"SUM(--($B$6:$B$19 = $B16))","v":3},null,null,null,"Usman Khaja"]
[null,"Kane Simpson",{"$f":"SUM(--($B$6:$B$19 = $B17))","v":1},null,null,null,"Kane Simpson"]
[null,"Irfan Khan",{"$f":"SUM(--($B$6:$B$19 = $B18))","v":1},null,null,null,"Irfan Khan"]
[null,"Usman Khaja",{"$f":"SUM(--($B$6:$B$19 = $B19))","v":3},null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"3.3 IF+SUM","index":12,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates and Return Number of Occurrences"]
[]
[null,"Combining IF and SUM Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Number of Occurrence",null,null,null,"Employee Name","Number of Occurrence"]
[null,"Morris King",{"$f":"SUM(IF($B$6:$B$19=$B6,1,0))","v":2},null,null,null,"Morris King"]
[null,"John Smith",{"$f":"SUM(IF($B$6:$B$19=$B7,1,0))","v":1},null,null,null,"John Smith"]
[null,"Alisha Stokes",{"$f":"SUM(IF($B$6:$B$19=$B8,1,0))","v":2},null,null,null,"Alisha Stokes"]
[null,"usman khaja",{"$f":"SUM(IF($B$6:$B$19=$B9,1,0))","v":3},null,null,null,"Usman Khaja"]
[null,"Steve Moor",{"$f":"SUM(IF($B$6:$B$19=$B10,1,0))","v":1},null,null,null,"Steve Moor"]
[null,"Natasha Marlo",{"$f":"SUM(IF($B$6:$B$19=$B11,1,0))","v":1},null,null,null,"Natasha Marlo"]
[null,"Morris King",{"$f":"SUM(IF($B$6:$B$19=$B12,1,0))","v":2},null,null,null,"Morris King"]
[null,"Jack Alfred",{"$f":"SUM(IF($B$6:$B$19=$B13,1,0))","v":1},null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",{"$f":"SUM(IF($B$6:$B$19=$B14,1,0))","v":2},null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",{"$f":"SUM(IF($B$6:$B$19=$B15,1,0))","v":1},null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",{"$f":"SUM(IF($B$6:$B$19=$B16,1,0))","v":3},null,null,null,"Usman Khaja"]
[null,"Kane Simpson",{"$f":"SUM(IF($B$6:$B$19=$B17,1,0))","v":1},null,null,null,"Kane Simpson"]
[null,"Irfan Khan",{"$f":"SUM(IF($B$6:$B$19=$B18,1,0))","v":1},null,null,null,"Irfan Khan"]
[null,"Usman Khaja",{"$f":"SUM(IF($B$6:$B$19=$B19,1,0))","v":3},null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"3.4 COUNTIFS","index":13,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,7,10,8]]}
[null,"Find Duplicates and Return Number of Occurances"]
[]
[null,"Using COUNTIFS Function to Find Duplicate Rows",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Number of Occurance",null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary","Number of Occurance"]
[null,"A124","Morris King",2019,20000,{"$f":"COUNTIFS($B$6:$B$19,$B6,$C$6:$C$19,$C6,$D$6:$D$19,$D6,$E$6:$E$19,$E6)","v":2},null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,{"$f":"COUNTIFS($B$6:$B$19,$B7,$C$6:$C$19,$C7,$D$6:$D$19,$D7,$E$6:$E$19,$E7)","v":1},null,"Note:",null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,1,null,"C16 = Usman Khaja is ignored due to different Employee ID, Joining Year and Salary.",null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","usman khaja",2018,18000,2,null,null,null,null,"A432","usman khaja",2018,18000]
[null,"A101","Steve Moor",2021,28000,1,null,null,null,null,"A101","Steve Moor",2021,28000]
[null,"A178","Natasha Marlo",2019,25000,1,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,2,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,1,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,1,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,1,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Usman Khaja",2017,30000,1,"<< Ignored",null,null,null,"A452","Usman Khaja",2017,30000]
[null,"A554","Kane Simpson",2016,20000,1,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Khan",2021,25000,1,null,null,null,null,"A099","Irfan Khan",2021,25000]
[null,"A432","Usman Khaja",2018,18000,2,null,null,null,null,"A432","Usman Khaja",2018,18000]
[]
[]
[]
[]
[null,"Home Page"]

{"sheet":"3.5 SUMPRODUCT","index":14,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,7,12,8]]}
[null,"Find Duplicate Values and Return Number of Occurrences"]
[]
[null,"Using SUMPRODUCT Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Number of Occurrence",null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary","Number of Occurrence"]
[null,"A124","Morris King",2019,20000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B6)*1,($C$6:$C$19=$C6)*1,($D$6:$D$19=$D6)*1)","v":2},null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B7)*1,($C$6:$C$19=$C7)*1,($D$6:$D$19=$D7)*1)","v":1},null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B8)*1,($C$6:$C$19=$C8)*1,($D$6:$D$19=$D8)*1)","v":1},null,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","usman khaja",2018,18000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B9)*1,($C$6:$C$19=$C9)*1,($D$6:$D$19=$D9)*1)","v":2},null,"Note:",null,null,"A432","Usman Khaja",2018,18000]
[null,"A101","Steve Moor",2021,28000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B10)*1,($C$6:$C$19=$C10)*1,($D$6:$D$19=$D10)*1)","v":1},null,"C16 = Usman Khaja is ignored due to different Employee ID, Joining Year and Salary.",null,null,"A101","Steve Moor",2021,28000]
[null,"A178","Natasha Marlo",2019,25000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B11)*1,($C$6:$C$19=$C11)*1,($D$6:$D$19=$D11)*1)","v":1},null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B12)*1,($C$6:$C$19=$C12)*1,($D$6:$D$19=$D12)*1)","v":2},null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B13)*1,($C$6:$C$19=$C13)*1,($D$6:$D$19=$D13)*1)","v":1},null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B14)*1,($C$6:$C$19=$C14)*1,($D$6:$D$19=$D14)*1)","v":1},null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B15)*1,($C$6:$C$19=$C15)*1,($D$6:$D$19=$D15)*1)","v":1},null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Usman Khaja",2017,30000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B16)*1,($C$6:$C$19=$C16)*1,($D$6:$D$19=$D16)*1)","v":1},"<< Ignored",null,null,null,"A452","Usman Khaja",2017,30000]
[null,"A554","Kane Simpson",2016,20000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B17)*1,($C$6:$C$19=$C17)*1,($D$6:$D$19=$D17)*1)","v":1},null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Khan",2021,25000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B18)*1,($C$6:$C$19=$C18)*1,($D$6:$D$19=$D18)*1)","v":1},null,null,null,null,"A099","Irfan Khan",2021,25000]
[null,"A432","Usman Khaja",2018,18000,{"$f":"SUMPRODUCT(($B$6:$B$19=$B19)*1,($C$6:$C$19=$C19)*1,($D$6:$D$19=$D19)*1)","v":2},null,null,null,null,"A432","Usman Khaja",2018,18000]
[]
[]
[]
[]
[null,"Home Page"]

{"sheet":"4..1 IF+COUNTIFS","index":15,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,7,10,9]]}
[null,"Find Duplicate Rows with Excel Functions"]
[]
[null,"Combining IF and COUNTIFS Functions",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate?",null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate?"]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B$19,$B6,$C$6:$C$19,$C6,$D$6:$D$19,$D6,$E$6:$E$19,$E6)>1,\"Duplicate\",\"Unique \")","v":"Duplicate"},null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,{"$f":"IF(COUNTIFS($B$6:$B$19,$B7,$C$6:$C$19,$C7,$D$6:$D$19,$D7,$E$6:$E$19,$E7)>1,\"Duplicate\",\"Unique \")","v":"Unique "},null,null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,"Unique ",null,"Note:",null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","usman khaja",2018,18000,"Duplicate",null,"C16 = Usman Khaja is ignored due to different Employee ID, Joining Year and Salary.",null,null,null,"A432","usman khaja",2018,18000]
[null,"A101","Steve Moor",2021,28000,"Unique ",null,null,null,null,null,"A101","Steve Moor",2021,28000]
[null,"A178","Natasha Marlo",2019,25000,"Unique ",null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,"Duplicate",null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,"Unique ",null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,"Unique ",null,",",null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,"Unique ",null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Usman Khaja",2017,30000,"Unique ","<< Ignored",null,null,null,null,"A452","Usman Khaja",2017,30000]
[null,"A554","Kane Simpson",2016,20000,"Unique ",null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Khan",2021,25000,"Unique ",null,null,null,null,null,"A099","Irfan Khan",2021,25000]
[null,"A432","Usman Khaja",2018,18000,"Duplicate",null,null,null,null,null,"A432","Usman Khaja",2018,18000]
[]
[]
[]
[null,"Home Page"]

{"sheet":"4.2 SUMPRODUCT","index":16,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,7,11,9]]}
[null,"Find Duplicate Rows with Excel Functions"]
[]
[null,"Combining IF and SUMPRODUCT Functions",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate?",null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate?"]
[null,"A124","Morris King",2019,20000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B6)*1,($C$6:$C$19=$C6)*1,($D$6:$D$19=$D6)*1,($E$6:$E$19=$E6)*1)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"},null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B7)*1,($C$6:$C$19=$C7)*1,($D$6:$D$19=$D7)*1,($E$6:$E$19=$E7)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B8)*1,($C$6:$C$19=$C8)*1,($D$6:$D$19=$D8)*1,($E$6:$E$19=$E8)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","usman khaja",2018,18000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B9)*1,($C$6:$C$19=$C9)*1,($D$6:$D$19=$D9)*1,($E$6:$E$19=$E9)*1)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"},null,"Note:",null,null,null,"A432","usman khaja",2018,18000]
[null,"A101","Steve Moor",2021,28000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B10)*1,($C$6:$C$19=$C10)*1,($D$6:$D$19=$D10)*1,($E$6:$E$19=$E10)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,"C16 = Usman Khaja is ignored due to different Employee ID, Joining Year and Salary.",null,null,null,"A101","Steve Moor",2021,28000]
[null,"A178","Natasha Marlo",2019,25000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B11)*1,($C$6:$C$19=$C11)*1,($D$6:$D$19=$D11)*1,($E$6:$E$19=$E11)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B12)*1,($C$6:$C$19=$C12)*1,($D$6:$D$19=$D12)*1,($E$6:$E$19=$E12)*1)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"},null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B13)*1,($C$6:$C$19=$C13)*1,($D$6:$D$19=$D13)*1,($E$6:$E$19=$E13)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B14)*1,($C$6:$C$19=$C14)*1,($D$6:$D$19=$D14)*1,($E$6:$E$19=$E14)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B15)*1,($C$6:$C$19=$C15)*1,($D$6:$D$19=$D15)*1,($E$6:$E$19=$E15)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Usman Khaja",2017,30000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B16)*1,($C$6:$C$19=$C16)*1,($D$6:$D$19=$D16)*1,($E$6:$E$19=$E16)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},"<< Ignored",null,null,null,null,"A452","Usman Khaja",2017,30000]
[null,"A554","Kane Simpson",2016,20000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B17)*1,($C$6:$C$19=$C17)*1,($D$6:$D$19=$D17)*1,($E$6:$E$19=$E17)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Khan",2021,25000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B18)*1,($C$6:$C$19=$C18)*1,($D$6:$D$19=$D18)*1,($E$6:$E$19=$E18)*1)>1,\"Duplicate\",\"Unique\")","v":"Unique"},null,null,null,null,null,"A099","Irfan Khan",2021,25000]
[null,"A432","Usman Khaja",2018,18000,{"$f":"IF(SUMPRODUCT(($B$6:$B$19=$B19)*1,($C$6:$C$19=$C19)*1,($D$6:$D$19=$D19)*1,($E$6:$E$19=$E19)*1)>1,\"Duplicate\",\"Unique\")","v":"Duplicate"},null,null,null,null,null,"A432","Usman Khaja",2018,18000]
[]
[]
[]
[null,"Home Page"]

{"sheet":"5. Excl. 1st","index":17,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates Excluding 1st Occurrence"]
[]
[null,"Using IF and COUNTIF Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Duplicate?",null,null,null,"Employee Name","Duplicate?"]
[null,"Morris King",{"$f":"IF(COUNTIF($B$6:$B6, $B6)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Morris King"]
[null,"John Smith",{"$f":"IF(COUNTIF($B$6:$B7, $B7)>1, \"Duplicate\", \"\")","v":""},null,null,null,"John Smith"]
[null,"Alisha Stokes",{"$f":"IF(COUNTIF($B$6:$B8, $B8)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Alisha Stokes"]
[null,"usman khaja",{"$f":"IF(COUNTIF($B$6:$B9, $B9)>1, \"Duplicate\", \"\")","v":""},null,null,null,"usman khaja"]
[null,"Steve Moor",{"$f":"IF(COUNTIF($B$6:$B10, $B10)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Steve Moor"]
[null,"Natasha Marlo",{"$f":"IF(COUNTIF($B$6:$B11, $B11)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Natasha Marlo"]
[null,"Morris King",{"$f":"IF(COUNTIF($B$6:$B12, $B12)>1, \"Duplicate\", \"\")","v":"Duplicate"},null,null,null,"Morris King"]
[null,"Jack Alfred",{"$f":"IF(COUNTIF($B$6:$B13, $B13)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",{"$f":"IF(COUNTIF($B$6:$B14, $B14)>1, \"Duplicate\", \"\")","v":"Duplicate"},null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",{"$f":"IF(COUNTIF($B$6:$B15, $B15)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",{"$f":"IF(COUNTIF($B$6:$B16, $B16)>1, \"Duplicate\", \"\")","v":"Duplicate"},null,null,null,"Usman Khaja"]
[null,"Kane Simpson",{"$f":"IF(COUNTIF($B$6:$B17, $B17)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Kane Simpson"]
[null,"Irfan Khan",{"$f":"IF(COUNTIF($B$6:$B18, $B18)>1, \"Duplicate\", \"\")","v":""},null,null,null,"Irfan Khan"]
[null,"Usman Khaja",{"$f":"IF(COUNTIF($B$6:$B19, $B19)>1, \"Duplicate\", \"\")","v":"Duplicate"},null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"6. Case Sensitive","index":18,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Case-Sensitive Duplicates with Excel Formula"]
[]
[null,"Combining IF, SUM, EXACT Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Duplicate?",null,null,null,"Employee Name","Duplicate?"]
[null,"Morris King",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B6)))<=1,\"\",\"Duplicate\")","v":"Duplicate"},null,null,null,"Morris King"]
[null,"John Smith",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B7)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"John Smith"]
[null,"Alisha Stokes",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B8)))<=1,\"\",\"Duplicate\")","v":"Duplicate"},null,null,null,"Alisha Stokes"]
[null,"usman khaja",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B9)))<=1,\"\",\"Duplicate\")","v":""},"<< Ignored",null,null,"usman khaja"]
[null,"Steve Moor",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B10)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"Steve Moor"]
[null,"Natasha Marlo",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B11)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"Natasha Marlo"]
[null,"Morris King",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B12)))<=1,\"\",\"Duplicate\")","v":"Duplicate"},null,null,null,"Morris King"]
[null,"Jack Alfred",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B13)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B14)))<=1,\"\",\"Duplicate\")","v":"Duplicate"},null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B15)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B16)))<=1,\"\",\"Duplicate\")","v":"Duplicate"},null,null,null,"Usman Khaja"]
[null,"Kane Simpson",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B17)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"Kane Simpson"]
[null,"Irfan Khan",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B18)))<=1,\"\",\"Duplicate\")","v":""},null,null,null,"Irfan Khan"]
[null,"Usman Khaja",{"$f":"IF(SUM((--EXACT($B$6:$B$19,B19)))<=1,\"\",\"Duplicate\")","v":"Duplicate"},null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"7.1a From Two List(IFERR+VLOOK)","index":19,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates From Two Columns"]
[]
[null,"Combining IFERROR and VLOOKUP Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee List- 1","Employee List- 2",null,"Duplicate Names",null,null,null,"Employee List- 1","Employee List- 2",null,"Duplicate Names"]
[null,"Morris King","Benjamin Russel",null,{"$f":"IFERROR(VLOOKUP(C6,$B$6:$B$19,1,FALSE),\"-\")","v":"-"},null,null,null,"Morris King","Benjamin Russel"]
[null,"John Smith","Steve Austin",null,{"$f":"IFERROR(VLOOKUP(C7,$B$6:$B$19,1,FALSE),\"-\")","v":"-"},null,null,null,"John Smith","Steve Austin"]
[null,"Alisha Stokes","Stephen Dulbarg",null,"-",null,null,null,"Alisha Stokes","Stephen Dulbarg"]
[null,"Usman Khaja","Usman Khaja",null,"Usman Khaja",null,null,null,"Usman Khaja","Usman Khaja"]
[null,"Steve Moor","Steve Moor",null,"Steve Moor",null,null,null,"Steve Moor","Steve Moor"]
[null,"Natasha Marlo","Wilfred Chomosky",null,"-",null,null,null,"Natasha Marlo","Wilfred Chomosky"]
[null,"Morris King","Emily Sparkle",null,"-",null,null,null,"Morris King","Emily Sparkle"]
[null,"Jack Alfred","Jacky Chan",null,"-",null,null,null,"Jack Alfred","Jacky Chan"]
[null,"Alisha Stokes","Alisha Stokes",null,"Alisha Stokes",null,null,null,"Alisha Stokes","Alisha Stokes"]
[null,"Benjamin Hick","Gregory Mills",null,"-",null,null,null,"Benjamin Hick","Gregory Mills"]
[null,"Usman Khaja","Kane Simpson",null,"Kane Simpson",null,null,null,"Usman Khaja","Kane Simpson"]
[null,"Kane Simpson","Aujeeta Milia",null,"-",null,null,null,"Kane Simpson","Aujeeta Milia"]
[null,"Irfan Khan",null,null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"7.1b From Two List(UNI+FIL)","index":20,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates From Two Columns"]
[]
[null,"Combining UNIQUE, FILTER and COUNTIF Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee List- 1","Employee List- 2",null,"Duplicate Names",null,null,null,"Employee List- 1","Employee List- 2",null,"Duplicate Names"]
[null,"Morris King","Benjamin Russel",null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(B6:B19,COUNTIF(C6:C17,B6:B19)>0))","v":"Alisha Stokes"},null,null,null,"Morris King","Benjamin Russel"]
[null,"John Smith","Steve Austin",null,"Usman Khaja",null,null,null,"John Smith","Steve Austin"]
[null,"Alisha Stokes","Stephen Dulbarg",null,"Steve Moor",null,null,null,"Alisha Stokes","Stephen Dulbarg"]
[null,"Usman Khaja","Usman Khaja",null,"Kane Simpson",null,null,null,"Usman Khaja","Usman Khaja"]
[null,"Steve Moor","Steve Moor",null,null,null,null,null,"Steve Moor","Steve Moor"]
[null,"Natasha Marlo","Wilfred Chomosky",null,null,null,null,null,"Natasha Marlo","Wilfred Chomosky"]
[null,"Morris King","Emily Sparkle",null,null,null,null,null,"Morris King","Emily Sparkle"]
[null,"Jack Alfred","Jacky Chan",null,null,null,null,null,"Jack Alfred","Jacky Chan"]
[null,"Alisha Stokes","Alisha Stokes",null,null,null,null,null,"Alisha Stokes","Alisha Stokes"]
[null,"Benjamin Hick","Gregory Mills",null,null,null,null,null,"Benjamin Hick","Gregory Mills"]
[null,"Usman Khaja","Kane Simpson",null,null,null,null,null,"Usman Khaja","Kane Simpson"]
[null,"Kane Simpson","Aujeeta Milia",null,null,null,null,null,"Kane Simpson","Aujeeta Milia"]
[null,"Irfan Khan",null,null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"7.2 From Three List","index":21,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates from Three Columns"]
[]
[null,"Combining FILTER and COUNTIF Functions",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee List- 1","Employee List- 2","Employee List- 3",null,"Duplicate Names",null,null,null,"Employee List- 1","Employee List- 2","Employee List- 3",null,"Duplicate Names"]
[null,"Morris King","Benjamin Russel","Steve Moor",null,{"$f":"_xlfn._xlws.FILTER(_xlfn._xlws.FILTER(B6:B19,COUNTIF(C6:C17,B6:B19)>0),COUNTIF(D6:D14,_xlfn._xlws.FILTER(B6:B19,COUNTIF(C6:C17,B6:B19)>0))>0)","v":"Steve Moor"},null,null,null,"Morris King","Benjamin Russel","Steve Moor"]
[null,"John Smith","Steve Austin","Alisa Stokes",null,null,null,null,null,"John Smith","Steve Austin","Alisa Stokes"]
[null,"Alisha Stokes","Stephen Dulbarg","Wilfred Stones",null,null,null,null,null,"Alisha Stokes","Stephen Dulbarg","Wilfred Stones"]
[null,"Usman Khaja","Usman Khaja","Jack Jonas",null,null,null,null,null,"Usman Khaja","Usman Khaja","Jack Jonas"]
[null,"Steve Moor","Steve Moor","Monty Shaw",null,null,null,null,null,"Steve Moor","Steve Moor","Monty Shaw"]
[null,"Natasha Marlo","Wilfred Chomosky","Luka Enrique",null,null,null,null,null,"Natasha Marlo","Wilfred Chomosky","Luka Enrique"]
[null,"Morris King","Emily Sparkle","Wilson Ted",null,null,null,null,null,"Morris King","Emily Sparkle","Wilson Ted"]
[null,"Jack Alfred","Jacky Chan","Ben Yameen",null,null,null,null,null,"Jack Alfred","Jacky Chan","Ben Yameen"]
[null,"Alisha Stokes","Alisha Stokes","Sam Idress",null,null,null,null,null,"Alisha Stokes","Alisha Stokes","Sam Idress"]
[null,"Benjamin Hick","Gregory Mills",null,null,null,null,null,null,"Benjamin Hick","Gregory Mills"]
[null,"Usman Khaja","Kane Simpson",null,null,null,null,null,null,"Usman Khaja","Kane Simpson"]
[null,"Kane Simpson","Aujeeta Milia",null,null,null,null,null,null,"Kane Simpson","Aujeeta Milia"]
[null,"Irfan Khan",null,null,null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"8. Between Two WS","index":22,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicate Values Across Two Sheets (Dataset 2)"]
[]
[null,"Combining ISNUMBER and MATCH Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Duplicate?",null,null,null,null,"Employee Name","Duplicate?"]
[null,"Morris King",{"$f":"ISNUMBER(MATCH($B6,'Dataset 2'!B4:B15,0))","v":false},null,"Note:",null,null,"Morris King"]
[null,"John Smith",{"$f":"ISNUMBER(MATCH($B7,'Dataset 2'!B5:B16,0))","v":false},null,"We are using Dataset 2 as another worksheet.",null,null,"John Smith"]
[null,"Alisha Stokes",{"$f":"ISNUMBER(MATCH($B8,'Dataset 2'!B6:B17,0))","v":true},null,null,null,null,"Alisha Stokes"]
[null,"usman khaja",{"$f":"ISNUMBER(MATCH($B9,'Dataset 2'!B7:B18,0))","v":true},null,null,null,null,"usman khaja"]
[null,"Steve Moor",{"$f":"ISNUMBER(MATCH($B10,'Dataset 2'!B8:B19,0))","v":true},null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",{"$f":"ISNUMBER(MATCH($B11,'Dataset 2'!B9:B20,0))","v":false},null,null,null,null,"Natasha Marlo"]
[null,"Morris King",{"$f":"ISNUMBER(MATCH($B12,'Dataset 2'!B10:B21,0))","v":false},null,null,null,null,"Morris King"]
[null,"Jack Alfred",{"$f":"ISNUMBER(MATCH($B13,'Dataset 2'!B11:B22,0))","v":false},null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",{"$f":"ISNUMBER(MATCH($B14,'Dataset 2'!B12:B23,0))","v":true},null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",{"$f":"ISNUMBER(MATCH($B15,'Dataset 2'!B13:B24,0))","v":false},null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",{"$f":"ISNUMBER(MATCH($B16,'Dataset 2'!B14:B25,0))","v":false},null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",{"$f":"ISNUMBER(MATCH($B17,'Dataset 2'!B15:B26,0))","v":false},null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",{"$f":"ISNUMBER(MATCH($B18,'Dataset 2'!B16:B27,0))","v":false},null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",{"$f":"ISNUMBER(MATCH($B19,'Dataset 2'!B17:B28,0))","v":false},null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"9. Betwen Two WB","index":23,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates Between Two Workbooks (Source Data)"]
[]
[null,"Combining IF and COUNTIF Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Duplicate?",null,"Note:",null,"Employee Name","Duplicate?"]
[null,"Morris King",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B6),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,"1. You must open two workbooks at a time. Otherwise it will show #VALUE error.",null,"Morris King"]
[null,"John Smith",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B7),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,"2. Please fix the file directory while applying the formula.",null,"John Smith"]
[null,"Alisha Stokes",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B8),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Alisha Stokes"]
[null,"usman khaja",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B9),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"usman khaja"]
[null,"Steve Moor",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B10),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Steve Moor"]
[null,"Natasha Marlo",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B11),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Natasha Marlo"]
[null,"Morris King",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B12),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Morris King"]
[null,"Jack Alfred",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B13),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B14),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B15),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B16),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Usman Khaja"]
[null,"Kane Simpson",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B17),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Kane Simpson"]
[null,"Irfan Khan",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B18),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Irfan Khan"]
[null,"Usman Khaja",{"$f":"IF(COUNTIF([1]Dataset3!$B$4:$B$15,$B19),TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"10. VBA Macro","index":24,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Find Duplicates in Excel"]
[]
[null,"Using VBA Macro Tool",null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Duplicate Names",null,null,"Employee Name"]
[null,"Morris King",null,"Morris King",null,null,"Morris King"]
[null,"John Smith",null,"Alisha Stokes",null,null,"John Smith"]
[null,"Alisha Stokes",null,"Usman Khaja",null,null,"Alisha Stokes"]
[null,"Usman Khaja",null,null,null,null,"Usman Khaja"]
[null,"Steve Moor",null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,"Usman Khaja"]
[]
[]
[]
[]
[null,"Home Page"]

{"sheet":"11.1 Return(IF+COUNTIF)","index":25,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Return Duplicates with Excel Formula"]
[]
[null,"Returning Values Including All Occurrences",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Duplicate Names",null,null,null,null,"Employee Name",null,"Duplicate Names"]
[null,"Morris King",null,{"$f":"IF(COUNTIF($B$6:$B$19,B6)>1,B6,\"\")","v":"Morris King"},null,null,null,null,"Morris King"]
[null,"John Smith",null,{"$f":"IF(COUNTIF($B$6:$B$19,B7)>1,B7,\"\")","v":""},null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"Alisha Stokes",null,null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,"usman khaja",null,null,null,null,"usman khaja"]
[null,"Steve Moor",null,"",null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,"",null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,"Morris King",null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,"",null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,"Alisha Stokes",null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,"",null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,"Usman Khaja",null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,"",null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,"",null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,"Usman Khaja",null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"11.2 Return(UNIQUE+FILTER)","index":26,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Return Duplicates with Excel Formula"]
[]
[null,"Returning Values Only Once",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Duplicate Names",null,null,null,"Employee Name",null,"Duplicate Names"]
[null,"Morris King",null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(B6:B19,COUNTIF(B6:B19,B6:B19)>1))","v":"Morris King"},null,null,null,"Morris King"]
[null,"John Smith",null,"Alisha Stokes",null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"usman khaja",null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,null,null,null,null,"usman khaja"]
[null,"Steve Moor",null,null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,null,null,null,null,"Usman Khaja"]
[]
[]
[]
[null,"Home Page"]

{"sheet":"11.3 Return(VLOOKUP+COUNTIF)","index":27,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Return Duplicates Comparing with Another Sheet (Dataset 2)"]
[]
[null,"Using VLOOKUP Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name",null,"Duplicate Names",null,"Note:",null,null,"Employee Name",null,"Duplicate Names"]
[null,"Morris King",null,{"$f":"IFERROR(VLOOKUP(B6,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,"We are using Dataset 2 as another worksheet.",null,null,"Morris King"]
[null,"John Smith",null,{"$f":"IFERROR(VLOOKUP(B7,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,{"$f":"IFERROR(VLOOKUP(B8,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Alisha Stokes"},null,null,null,null,"Alisha Stokes"]
[null,"usman khaja",null,{"$f":"IFERROR(VLOOKUP(B9,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Usman Khaja"},null,null,null,null,"usman khaja"]
[null,"Steve Moor",null,{"$f":"IFERROR(VLOOKUP(B10,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Steve Moor"},null,null,null,null,"Steve Moor"]
[null,"Natasha Marlo",null,{"$f":"IFERROR(VLOOKUP(B11,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,{"$f":"IFERROR(VLOOKUP(B12,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,{"$f":"IFERROR(VLOOKUP(B13,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,{"$f":"IFERROR(VLOOKUP(B14,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Alisha Stokes"},null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,{"$f":"IFERROR(VLOOKUP(B15,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,null,null,null,"Benjamin Hick"]
[null,"Usman Khaja",null,{"$f":"IFERROR(VLOOKUP(B16,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Usman Khaja"},null,null,null,null,"Usman Khaja"]
[null,"Kane Simpson",null,{"$f":"IFERROR(VLOOKUP(B17,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Kane Simpson"},null,null,null,null,"Kane Simpson"]
[null,"Irfan Khan",null,{"$f":"IFERROR(VLOOKUP(B18,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"-"},null,null,null,null,"Irfan Khan"]
[null,"Usman Khaja",null,{"$f":"IFERROR(VLOOKUP(B19,'Dataset 2'!$B$4:$B$15, 1, FALSE),\"-\")","v":"Usman Khaja"},null,null,null,null,"Usman Khaja"]
[]
[]
[]
[]
[null,"Home Page"]

{"sheet":"Select,Copy,Move, Remove,Hide","index":28,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Select, Copy, Move, Remove and Hide Duplicates in Excel"]
[]
[null,"Using Filter Tool",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate?",null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate?"]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B$19,$B6,$C$6:$C$19,$C6,$D$6:$D$19,$D6,$E$6:$E$19,$E6)>1,\"Duplicate\",\"Unique \")","v":"Duplicate"},null,null,null,null,null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B$19,$B6,$C$6:$C$19,$C6,$D$6:$D$19,$D6,$E$6:$E$19,$E6)>1,\"Duplicate\",\"Unique \")","v":"Duplicate"}]
[null,"A054","John Smith",2020,25000,{"$f":"IF(COUNTIFS($B$6:$B$19,$B7,$C$6:$C$19,$C7,$D$6:$D$19,$D7,$E$6:$E$19,$E7)>1,\"Duplicate\",\"Unique \")","v":"Unique "},null,null,null,null,null,"A054","John Smith",2020,25000,{"$f":"IF(COUNTIFS($B$6:$B$19,$B7,$C$6:$C$19,$C7,$D$6:$D$19,$D7,$E$6:$E$19,$E7)>1,\"Duplicate\",\"Unique \")","v":"Unique "}]
[null,"A231","Alisha Stokes",2019,25000,"Unique ",null,null,null,null,null,"A231","Alisha Stokes",2019,25000,"Unique "]
[null,"A432","Usman Khaja",2018,18000,"Duplicate",null,null,null,null,null,"A432","Usman Khaja",2018,18000,"Duplicate"]
[null,"A101","Steve Moor",2021,28000,"Unique ",null,null,null,null,null,"A101","Steve Moor",2021,28000,"Unique "]
[null,"A178","Natasha Marlo",2019,25000,"Unique ",null,null,null,null,null,"A178","Natasha Marlo",2019,25000,"Unique "]
[null,"A124","Morris King",2019,20000,"Duplicate",null,null,null,null,null,"A124","Morris King",2019,20000,"Duplicate"]
[null,"A452","Jack Alfred",2020,35000,"Unique ",null,null,null,null,null,"A452","Jack Alfred",2020,35000,"Unique "]
[null,"A343","Alisha Stokes",2019,35000,"Unique ",null,",",null,null,null,"A343","Alisha Stokes",2019,35000,"Unique "]
[null,"A423","Benjamin Hick",2020,28000,"Unique ",null,null,null,null,null,"A423","Benjamin Hick",2020,28000,"Unique "]
[null,"A452","Usman Khaja",2017,30000,"Unique ",null,null,null,null,null,"A452","Usman Khaja",2017,30000,"Unique "]
[null,"A554","Kane Simpson",2016,20000,"Unique ",null,null,null,null,null,"A554","Kane Simpson",2016,20000,"Unique "]
[null,"A099","Irfan Khan",2021,25000,"Unique ",null,null,null,null,null,"A099","Irfan Khan",2021,25000,"Unique "]
[null,"A432","Usman Khaja",2018,18000,"Duplicate",null,null,null,null,null,"A432","Usman Khaja",2018,18000,"Duplicate"]
[]
[null,null,null,null,null,null,null,"Pro Tips:"]
[null,null,null,null,null,null,null,"1. Select all filtered data with Mouse"]
[null,null,null,null,null,null," ","2. Copy them by pressing Ctrl + C keys"]
[null,null,null,null,null,null,null,"3. Paste into the new location by pressing Ctrl + V keys"]
[null,null,null,null,null,null,null,"4. Hide by unchecking Duplicate from the Filter Drop-down."]
[null,"Home Page"]

{"sheet":"Sheet1","index":29,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Employee ID","Employee Name","Joining Year","Salary","Duplicate?"]
["A124","Morris King",2019,20000,"Duplicate"]
["A432","Usman Khaja",2018,18000,"Duplicate"]
["A124","Morris King",2019,20000,"Duplicate"]
["A432","Usman Khaja",2018,18000,"Duplicate"]