{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Home Page","Dataset","1.1 Remove Duplicates(Single)","1.2 Remove Duplicates(Multiple)","2. From Table","3. Removing Duplicate Rows","4. UNIQUE","5. Keeping 1st Instance","6. Formula & Filter","7. Based on Criteria","8. VBA Macro","9. Power Query","Undo Remove Duplicate","Hide Duplicates","Fix Issues"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"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":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Remove Duplicates in Excel"]
[null,"Learn to remove duplicate cells and rows with this free workbook. Read the article and practice yourself."]
[]
[null,"Prepared By","MD Tanvir Rahman"]
[null,"Last Update",{"$f":"TODAY()","v":"2023-12-04"}]
[null,"Reviewed By","Nehad Ulfat"]
[null,"Article Link","https://www.exceldemy.com/learn-excel/extract-data/"]
[]
[null,"Methods"]
[null,"1. Using Remove Duplicates Command to Erase Duplicates in Excel"]
[null,null,"1.1. From a Single Column"]
[null,null,null,"Keyboard Shortcut to Remove Duplicates"]
[null,null,"1.2. Across Multiple Columns"]
[null,"2. Removing Duplicate Rows From Excel Table"]
[null,"3. Removing Duplicate Rows Based on Multiple Excel Columns"]
[null,"4. Applying Excel UNIQUE Function to Remove Duplication"]
[null,"5. Removing Duplicates in Excel But Keeping 1st Instance Only"]
[null,"6. Using Excel Formula and Filter Tool to Remove Duplicates in Excel"]
[null,"7. Removing Duplicates Based on Criteria in Excel"]
[null,"8. Apply VBA Macro to Remove Duplicates in Excel"]
[null,"9. Using Excel Power Query Tool to Remove Duplicates"]
[null,"How to Undo Remove Duplicates in Excel?"]
[null,"How to Hide Duplicate Values Instead of Removing Them in Excel?"]
[null,"What Can be the Possible Reasons If You Can’t Remove Duplicates in Excel Properly?"]

{"sheet":"Dataset","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Remove 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","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000]
[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","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000]
[]
[]
[null,"Home Page"]

{"sheet":"1.1 Remove Duplicates(Single)","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates from a Single Column"]
[]
[null,"Using Remove Duplicates Command",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee Name",null,"Employee Name",null,null,null,null,null,null,null,"Employee Name"]
[null,"Morris King",null,"Morris King",null,"Note:",null,null,null,null,null,"Morris King"]
[null,"John Smith",null,"John Smith",null,"1. Select dataset and click as follows:",null,null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"Alisha Stokes",null,"Data => Data Tools => Remove Duplicates",null,null,null,null,null,"Alisha Stokes"]
[null,"jaime shaw",null,"jaime shaw",null,"2. The following dataset will be converted into range D6:D14.",null,null,null,null,null,"jaime shaw"]
[null,"Irfan Iqbal",null,"Irfan Iqbal",null,null,null,null,null,null,null,"Irfan Iqbal"]
[null,"Natasha Marlo",null,"Natasha Marlo",null,null,null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,"Jack Alfred",null,null,null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,"Benjamin Hick",null,null,null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,"Kane Simpson",null,null,null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,null,null,null,null,null,"Benjamin Hick"]
[null,"Jaime Shaw",null,null,null,"Keyboard Shortcut >>",null,null,null,null,null,"Jaime Shaw"]
[null,"Kane Simpson",null,null,null,null,null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Iqbal",null,null,null,null,null,null,null,null,null,"Irfan Iqbal"]
[null,"Jaime Shaw",null,null,null,null,null,null,null,null,null,"Jaime Shaw"]
[]
[]
[null,"Home Page"]

{"sheet":"1.2 Remove Duplicates(Multiple)","index":3,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates from Multiple Columns"]
[]
[null,"Using Remove Duplicates Command",null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee ID","Employee Name","Joining Year","Salary",null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,null,"A124","Morris King",2019,20000,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,"A054","John Smith",2020,25000,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,"A231","Alisha Stokes",2019,25000,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,null,"A432","jaime shaw",2018,18000,null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,null,"A099","Irfan Iqbal",2021,25000,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,null,"A178","Natasha Marlo",2019,25000,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,null,"A452","Jack Alfred",2020,35000,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,null,"A343","Alisha Stokes",2019,35000,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,null,"A423","Benjamin Hick",2020,28000,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,null,"A452","Jaime Shaw",2017,30000,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000,null,"A554","Kane Simpson",2016,20000,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,null,null,null,null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[null,null,null,null,null,null,"Note: Orange marked data are removed. Alisa Stokes and Jaime Shaw didn’t removed because of different employee ID."]
[null,null,null,null,null,null,"Pro Tips:"]
[null,null,null,null,null,null,"2. Select dataset and click as follows:"]
[null,"Home Page",null,null,null,null,"Data => Data Tools => Remove Duplicates"]
[null,null,null,null,null,null,"1. The following dataset will converted into range G6:J15."]

{"sheet":"2. From Table","index":4,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates Rows from Table"]
[]
[null,"Using Remove Duplicates Command",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Pro Tips:",null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,null,"1. Make Table by pressing Ctrl + T keys.",null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,"2. Select table and click as follows:",null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,"Table Design => Remove Duplicates",null,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,null,null,null,null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,null,null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A452","Jack Alfred",2020,35000,null,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A343","Alisha Stokes",2019,35000,null,null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A423","Benjamin Hick",2020,28000,null,null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A452","Jaime Shaw",2017,30000,null,null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,null,null,null,null,null,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,null,null,null,null,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,null,null,null,null,null,null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[null,"Home Page"]
[null,"Note: Alisa Stokes and Jaime Shaw didn’t removed because of different employee ID."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Home Page"]

{"sheet":"3. Removing Duplicate Rows","index":5,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicate Rows Based on Multiple Columns"]
[]
[null,"Using Advanced Filter Tool",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,null,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,null,null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,null,null,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,null,null,null,null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,null,null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,null,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,null,null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,null,null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,null,null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000,null,null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,null,null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[null,null,null,null,null,null,"Note: Orange marked data are removed. Alisa Stokes and Jaime Shaw didn’t removed because of different employee ID."]
[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","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000]
[null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000]
[]
[null,"Home Page"]

{"sheet":"4. UNIQUE","index":6,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates in Excel"]
[]
[null,"Using UNIQUE Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee Name",null,"Employee Name",null,null,null,null,null,null,null,"Employee Name"]
[null,"Morris King",null,{"$f":"_xlfn.UNIQUE(B6:B19)","v":"Morris King"},null,null,null,null,null,null,null,"Morris King"]
[null,"John Smith",null,"John Smith",null,null,null,null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,"Alisha Stokes",null,null,null,null,null,null,null,"Alisha Stokes"]
[null,"jaime shaw",null,"jaime shaw",null,null,null,null,null,null,null,"jaime shaw"]
[null,"Irfan Iqbal",null,"Irfan Iqbal",null,null,null,null,null,null,null,"Irfan Iqbal"]
[null,"Natasha Marlo",null,"Natasha Marlo",null,null,null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,"Jack Alfred",null,null,null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,"Benjamin Hick",null,null,null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,"Kane Simpson",null,null,null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,null,null,null,null,null,null,null,null,"Benjamin Hick"]
[null,"Jaime Shaw",null,null,null,null,null,null,null,null,null,"Jaime Shaw"]
[null,"Kane Simpson",null,null,null,null,null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Iqbal",null,null,null,null,null,null,null,null,null,"Irfan Iqbal"]
[null,"Jaime Shaw",null,null,null,null,null,null,null,null,null,"Jaime Shaw"]
[]
[]
[null,"Home Page"]

{"sheet":"5. Keeping 1st Instance","index":7,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates But Keeping 1st Instance Only"]
[]
[null,"Using IF and COUNTIF Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee Name",null,"Employee Name",null,null,null,null,null,null,"Employee Name"]
[null,"Morris King",null,{"$f":"IF(COUNTIF($B$6:$B6, $B6)=1, B6, \"\")","v":"Morris King"},null,null,null,null,null,null,"Morris King"]
[null,"John Smith",null,{"$f":"IF(COUNTIF($B$6:$B7, $B7)=1, B7, \"\")","v":"John Smith"},null,null,null,null,null,null,"John Smith"]
[null,"Alisha Stokes",null,{"$f":"IF(COUNTIF($B$6:$B8, $B8)=1, B8, \"\")","v":"Alisha Stokes"},null,null,null,null,null,null,"Alisha Stokes"]
[null,"jaime shaw",null,{"$f":"IF(COUNTIF($B$6:$B9, $B9)=1, B9, \"\")","v":"jaime shaw"},null,null,null,null,null,null,"jaime shaw"]
[null,"Irfan Iqbal",null,{"$f":"IF(COUNTIF($B$6:$B10, $B10)=1, B10, \"\")","v":"Irfan Iqbal"},null,null,null,null,null,null,"Irfan Iqbal"]
[null,"Natasha Marlo",null,{"$f":"IF(COUNTIF($B$6:$B11, $B11)=1, B11, \"\")","v":"Natasha Marlo"},null,null,null,null,null,null,"Natasha Marlo"]
[null,"Morris King",null,{"$f":"IF(COUNTIF($B$6:$B12, $B12)=1, B12, \"\")","v":""},null,null,null,null,null,null,"Morris King"]
[null,"Jack Alfred",null,{"$f":"IF(COUNTIF($B$6:$B13, $B13)=1, B13, \"\")","v":"Jack Alfred"},null,null,null,null,null,null,"Jack Alfred"]
[null,"Alisha Stokes",null,{"$f":"IF(COUNTIF($B$6:$B14, $B14)=1, B14, \"\")","v":""},null,null,null,null,null,null,"Alisha Stokes"]
[null,"Benjamin Hick",null,{"$f":"IF(COUNTIF($B$6:$B15, $B15)=1, B15, \"\")","v":"Benjamin Hick"},null,null,null,null,null,null,"Benjamin Hick"]
[null,"Jaime Shaw",null,{"$f":"IF(COUNTIF($B$6:$B16, $B16)=1, B16, \"\")","v":""},null,null,null,null,null,null,"Jaime Shaw"]
[null,"Kane Simpson",null,{"$f":"IF(COUNTIF($B$6:$B17, $B17)=1, B17, \"\")","v":"Kane Simpson"},null,null,null,null,null,null,"Kane Simpson"]
[null,"Irfan Iqbal",null,{"$f":"IF(COUNTIF($B$6:$B18, $B18)=1, B18, \"\")","v":""},null,null,null,null,null,null,"Irfan Iqbal"]
[null,"Jaime Shaw",null,{"$f":"IF(COUNTIF($B$6:$B19, $B19)=1, B19, \"\")","v":""},null,null,null,null,null,null,"Jaime Shaw"]
[]
[]
[null,"Home Page"]

{"sheet":"6. Formula & Filter","index":8,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates  Rows in Excel"]
[]
[null,"Using IF-COUNTIF Formula and Filter Tool",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate Row?",null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate Row?"]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B6, $B6, $C$6:$C6, $C6, $D$6:$D6, $D6,$E$6:$E6, $E6)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"Pro Tips:",null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,{"$f":"IF(COUNTIFS($B$6:$B7, $B7, $C$6:$C7, $C7, $D$6:$D7, $D7,$E$6:$E7, $E7)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"1. Find out unique and duplicate row.",null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,{"$f":"IF(COUNTIFS($B$6:$B8, $B8, $C$6:$C8, $C8, $D$6:$D8, $D8,$E$6:$E8, $E8)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2. Filter out Duplicate row.",null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,{"$f":"IF(COUNTIFS($B$6:$B9, $B9, $C$6:$C9, $C9, $D$6:$D9, $D9,$E$6:$E9, $E9)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"3. Click as follows: Find & Select => Go to Special.",null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,{"$f":"IF(COUNTIFS($B$6:$B10, $B10, $C$6:$C10, $C10, $D$6:$D10, $D10,$E$6:$E10, $E10)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"4. Select Visible cells Only.",null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,{"$f":"IF(COUNTIFS($B$6:$B11, $B11, $C$6:$C11, $C11, $D$6:$D11, $D11,$E$6:$E11, $E11)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"5. Delete Duplicate rows.",null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B12, $B12, $C$6:$C12, $C12, $D$6:$D12, $D12,$E$6:$E12, $E12)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,"6. Select Unique from the Filter drop-down.",null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,{"$f":"IF(COUNTIFS($B$6:$B13, $B13, $C$6:$C13, $C13, $D$6:$D13, $D13,$E$6:$E13, $E13)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,{"$f":"IF(COUNTIFS($B$6:$B14, $B14, $C$6:$C14, $C14, $D$6:$D14, $D14,$E$6:$E14, $E14)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,{"$f":"IF(COUNTIFS($B$6:$B15, $B15, $C$6:$C15, $C15, $D$6:$D15, $D15,$E$6:$E15, $E15)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000,{"$f":"IF(COUNTIFS($B$6:$B16, $B16, $C$6:$C16, $C16, $D$6:$D16, $D16,$E$6:$E16, $E16)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,{"$f":"IF(COUNTIFS($B$6:$B17, $B17, $C$6:$C17, $C17, $D$6:$D17, $D17,$E$6:$E17, $E17)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,{"$f":"IF(COUNTIFS($B$6:$B18, $B18, $C$6:$C18, $C18, $D$6:$D18, $D18,$E$6:$E18, $E18)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,{"$f":"IF(COUNTIFS($B$6:$B19, $B19, $C$6:$C19, $C19, $D$6:$D19, $D19,$E$6:$E19, $E19)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate Row?"]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($C$6:$C22, $C22, $D$6:$D22, $D22, $E$6:$E22, $E22,$F$6:$F22, $F22)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A054","John Smith",2020,25000,{"$f":"IF(COUNTIFS($C$6:$C23, $C23, $D$6:$D23, $D23, $E$6:$E23, $E23,$F$6:$F23, $F23)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A231","Alisha Stokes",2019,25000,{"$f":"IF(COUNTIFS($C$6:$C24, $C24, $D$6:$D24, $D24, $E$6:$E24, $E24,$F$6:$F24, $F24)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A432","jaime shaw",2018,18000,{"$f":"IF(COUNTIFS($C$6:$C25, $C25, $D$6:$D25, $D25, $E$6:$E25, $E25,$F$6:$F25, $F25)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A101","Steve Moor",2021,28000,{"$f":"IF(COUNTIFS($C$6:$C26, $C26, $D$6:$D26, $D26, $E$6:$E26, $E26,$F$6:$F26, $F26)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A178","Natasha Marlo",2019,25000,{"$f":"IF(COUNTIFS($C$6:$C27, $C27, $D$6:$D27, $D27, $E$6:$E27, $E27,$F$6:$F27, $F27)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A452","Jack Alfred",2020,35000,{"$f":"IF(COUNTIFS($C$6:$C28, $C28, $D$6:$D28, $D28, $E$6:$E28, $E28,$F$6:$F28, $F28)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A343","Alisha Stokes",2019,35000,{"$f":"IF(COUNTIFS($C$6:$C29, $C29, $D$6:$D29, $D29, $E$6:$E29, $E29,$F$6:$F29, $F29)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A423","Benjamin Hick",2020,28000,{"$f":"IF(COUNTIFS($C$6:$C30, $C30, $D$6:$D30, $D30, $E$6:$E30, $E30,$F$6:$F30, $F30)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A452","Jaime Shaw",2017,30000,{"$f":"IF(COUNTIFS($C$6:$C31, $C31, $D$6:$D31, $D31, $E$6:$E31, $E31,$F$6:$F31, $F31)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A554","Kane Simpson",2016,20000,{"$f":"IF(COUNTIFS($C$6:$C32, $C32, $D$6:$D32, $D32, $E$6:$E32, $E32,$F$6:$F32, $F32)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[null,"A099","Irfan Khan",2021,25000,{"$f":"IF(COUNTIFS($C$6:$C33, $C33, $D$6:$D33, $D33, $E$6:$E33, $E33,$F$6:$F33, $F33)>1, \"Duplicate row\", \"Unique\")","v":"Unique"}]
[]
[null,"Home Page"]

{"sheet":"7. Based on Criteria","index":9,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicate Rows Based on Criteria in Excel"]
[]
[null,"Using Advanced Filter Tool",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product ID","Product Name","Order Date","Vendor Name","Price",null,"Pro Tips:",null,null,null,null,"Product ID","Product Name","Order Date","Vendor Name","Price"]
[null,101,"Apple","2023-11-05","Orbit Fruits",20000,null,"1. Select Data => Advanced.",null,null,null,null,101,"Apple","2023-11-05","Orbit Fruits",20000]
[null,102,"Grape","2023-11-05","Believe Farmers",25000,null,"2. Select input, criteria and output locations.",null,null,null,null,102,"Grape","2023-11-05","Believe Farmers",25000]
[null,101,"Apple","2023-11-05","Orbit Fruits",20000,null,null,null,null,null,null,101,"Apple","2023-11-05","Orbit Fruits",20000]
[null,103,"Mango","2023-11-05","ABC Fruits",18000,null,null,null,null,null,null,103,"Mango","2023-11-05","ABC Fruits",18000]
[null,104,"Banana","2023-11-06","Orbit Fruits",25000,null,null,null,null,null,null,104,"Banana","2023-11-06","Orbit Fruits",25000]
[null,102,"Water Melon","2023-11-06","Believe Farmers",25000,null,null,null,null,null,null,102,"Water Melon","2023-11-06","Believe Farmers",25000]
[null,102,"Water Melon","2023-11-06","Believe Farmers",25000,null,null,null,null,null,null,102,"Water Melon","2023-11-06","Believe Farmers",25000]
[null,105,"Avocado","2023-11-06","ABC Fruits",35000,null,null,null,null,null,null,105,"Avocado","2023-11-06","ABC Fruits",35000]
[null,105,"Avocado","2023-11-06","ABC Fruits",35000,null,null,null,null,null,null,105,"Avocado","2023-11-06","ABC Fruits",35000]
[]
[null,null,null,"Criteria >>","Vendor Name","Price",null,null,null,null,null,null,null,null,"Criteria >>","Vendor Name","Price"]
[null,null,null,null,"Believe Farmers",">15000",null,null,null,null,null,null,null,null,null,"Believe Farmers",">18000"]
[]
[null,"Product ID","Product Name","Order Date","Vendor Name","Price"]
[null,102,"Grape","2023-11-05","Believe Farmers",25000]
[null,102,"Water Melon","2023-11-06","Believe Farmers",25000]
[]
[null,"Home Page"]

{"sheet":"8. VBA Macro","index":10,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates in Excel"]
[]
[null,"Using VBA Macro Tool",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Pro Tips:",null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,null,"1. Go to Developer => Macro => Remove_Duplicates_in_Excel",null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,"2. Select input range, and hit OK.",null,null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,null,null,null,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,null,null,null,null,null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,null,null,null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,null,null,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,null,null,null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,null,null,null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,null,null,null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000,null,null,null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,null,null,null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[]
[null,"Home Page"]

{"sheet":"9. Power Query","index":11,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Remove Duplicates in Excel"]
[]
[null,"Using Power Query Tool",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[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. Select data.",null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,"2. Click as follows: Data => From Table/Range command.",null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,"3. Open in Power Query Editor.",null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,null,"4. Right click on the mouse and click Remove Duplicates.",null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,null,"5. Click on Load to button and import data into the existing worksheet.",null,null,null,"A099","Irfan Iqbal",2021,25000]
[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","Jaime Shaw",2017,30000,null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[]
[null,"Home Page"]
[]
[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","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000]
[null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000]
[null,"A554","Kane Simpson",2016,20000]

{"sheet":"Undo Remove Duplicate","index":12,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Undo Remove Duplicates in Excel"]
[]
[null,"Using Quick Access ToolBar",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,null,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,null,"Pro Tips:",null,null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,null,"1. Use Undo command from the Quick Access Toolbar.",null,null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,null,"2. Alternative: Press Ctrl + Z to undo.",null,null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,null,null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,null,null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,null,null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,null,null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,null,null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000,null,null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,null,null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,null,null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,null,null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[]
[null,"Home Page",null,null,null,null,null,null,null,null,null,"Home Page"]

{"sheet":"Hide Duplicates","index":13,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"Hide Duplicate Values Instead of Removing Them"]
[]
[null,"Using Filter Tool",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate Row?",null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B6, $B6,$C$6:$C6, $C6, $D$6:$D6, $D6, $E$6:$E6, $E6)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A054","John Smith",2020,25000,{"$f":"IF(COUNTIFS($B$6:$B7, $B7,$C$6:$C7, $C7, $D$6:$D7, $D7, $E$6:$E7, $E7)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"Pro Tips:",null,null,null,"A054","John Smith",2020,25000]
[null,"A231","Alisha Stokes",2019,25000,{"$f":"IF(COUNTIFS($B$6:$B8, $B8,$C$6:$C8, $C8, $D$6:$D8, $D8, $E$6:$E8, $E8)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"1. Find out duplicate rows without 1st instances.",null,null,null,"A231","Alisha Stokes",2019,25000]
[null,"A432","jaime shaw",2018,18000,{"$f":"IF(COUNTIFS($B$6:$B9, $B9,$C$6:$C9, $C9, $D$6:$D9, $D9, $E$6:$E9, $E9)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2. Filter out the duplicate rows.",null,null,null,"A432","jaime shaw",2018,18000]
[null,"A099","Irfan Iqbal",2021,25000,{"$f":"IF(COUNTIFS($B$6:$B10, $B10,$C$6:$C10, $C10, $D$6:$D10, $D10, $E$6:$E10, $E10)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A178","Natasha Marlo",2019,25000,{"$f":"IF(COUNTIFS($B$6:$B11, $B11,$C$6:$C11, $C11, $D$6:$D11, $D11, $E$6:$E11, $E11)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A178","Natasha Marlo",2019,25000]
[null,"A124","Morris King",2019,20000,{"$f":"IF(COUNTIFS($B$6:$B12, $B12,$C$6:$C12, $C12, $D$6:$D12, $D12, $E$6:$E12, $E12)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,null,null,null,null,"A124","Morris King",2019,20000]
[null,"A452","Jack Alfred",2020,35000,{"$f":"IF(COUNTIFS($B$6:$B13, $B13,$C$6:$C13, $C13, $D$6:$D13, $D13, $E$6:$E13, $E13)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A452","Jack Alfred",2020,35000]
[null,"A343","Alisha Stokes",2019,35000,{"$f":"IF(COUNTIFS($B$6:$B14, $B14,$C$6:$C14, $C14, $D$6:$D14, $D14, $E$6:$E14, $E14)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A343","Alisha Stokes",2019,35000]
[null,"A423","Benjamin Hick",2020,28000,{"$f":"IF(COUNTIFS($B$6:$B15, $B15,$C$6:$C15, $C15, $D$6:$D15, $D15, $E$6:$E15, $E15)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A423","Benjamin Hick",2020,28000]
[null,"A452","Jaime Shaw",2017,30000,{"$f":"IF(COUNTIFS($B$6:$B16, $B16,$C$6:$C16, $C16, $D$6:$D16, $D16, $E$6:$E16, $E16)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A452","Jaime Shaw",2017,30000]
[null,"A554","Kane Simpson",2016,20000,{"$f":"IF(COUNTIFS($B$6:$B17, $B17,$C$6:$C17, $C17, $D$6:$D17, $D17, $E$6:$E17, $E17)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,null,null,null,null,"A554","Kane Simpson",2016,20000]
[null,"A099","Irfan Iqbal",2021,25000,{"$f":"IF(COUNTIFS($B$6:$B18, $B18,$C$6:$C18, $C18, $D$6:$D18, $D18, $E$6:$E18, $E18)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,null,null,null,null,"A099","Irfan Iqbal",2021,25000]
[null,"A432","Jaime Shaw",2018,18000,{"$f":"IF(COUNTIFS($B$6:$B19, $B19,$C$6:$C19, $C19, $D$6:$D19, $D19, $E$6:$E19, $E19)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,null,null,null,null,"A432","Jaime Shaw",2018,18000]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary","Duplicate Row?"]
[null,"A124","Morris King",2019,20000,"Unique"]
[null,"A054","John Smith",2020,25000,"Unique"]
[null,"A231","Alisha Stokes",2019,25000,"Unique"]
[null,"A432","jaime shaw",2018,18000,"Unique"]
[null,"A099","Irfan Iqbal",2021,25000,"Unique"]
[null,"A178","Natasha Marlo",2019,25000,"Unique"]
[null,"A124","Morris King",2019,20000,"Duplicate row"]
[null,"A452","Jack Alfred",2020,35000,"Unique"]
[null,"A343","Alisha Stokes",2019,35000,"Unique"]
[null,"A423","Benjamin Hick",2020,28000,"Unique"]
[null,"A452","Jaime Shaw",2017,30000,"Unique"]
[null,"A554","Kane Simpson",2016,20000,"Unique"]
[null,"A099","Irfan Iqbal",2021,25000,"Duplicate row"]
[null,"A432","Jaime Shaw",2018,18000,"Duplicate row"]
[]
[null,"Home Page"]

{"sheet":"Fix Issues","index":14,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Why Remove Duplicates Not Working"]
[]
[null,"Using Remove Duplicates Command"]
[]
[null,"Employee Name","Sales Region-1","Sales Region-2",null,"Sales Regions",null,"Pro Tips:",null,null,null,"Employee Name","Sales Region-1","Sales Region-2"]
[null,"Morris King","Ohio","New York",null,"Ohio",null,"1. copy all the data from Sales Region-1 and Sales Region-2.",null,null,null,"Morris King","Ohio","New York"]
[null,"John Smith","Texas","California",null,"Texas",null,"2. Gather data in Sales Region column.",null,null,null,"John Smith","Texas","California"]
[null,"Alisha Stokes","Houston","Texas",null,"Houston",null,"3. Use Remove Duplicates command.",null,null,null,"Alisha Stokes","Houston","Texas"]
[null,"jaime shaw","Dallas","Ohio",null,"Dallas",null,null,null,null,null,"jaime shaw","Dallas","Ohio"]
[null,"Irfan Iqbal","New Mexico","Texas",null,"New Mexico",null,null,null,null,null,"Irfan Iqbal","New Mexico","Texas"]
[null,"Natasha Marlo","Ohio","Houston",null,"New York",null,null,null,null,null,"Natasha Marlo","Ohio","Houston"]
[null,"Nisa Kingston","New York","Dallas",null,"California",null,null,null,null,null,"Nisa Kingston","New York","Dallas"]
[null,"Jack Alfred","California","New Mexico",null,null,null,null,null,null,null,"Jack Alfred","California","New Mexico"]
[null,"Benjamin Hick","Texas","New York",null,null,null,null,null,null,null,"Benjamin Hick","Texas","New York"]
[]
[null,"Home Page"]