Skip to content

XL n CAD

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Remove Duplicates

Remove Duplicates using Power Query in Excel

April 15, 2022June 1, 2020 by Ajay Anand
Remove Duplicates Excel

Like the Remove Duplicates feature in Excel, Power Query also can be used to remove duplicates from a data set. But, why should we use Power Query to get rid of the Duplicates? Here is why . . . Following is a sample sales data containing duplicate records (The records with arrows against them). Now, … Read more

Categories MS Excel, Power Query Tags Remove Duplicates
Microsoft Excel course by Ajay Anand

Featured course

Excel: Beginner to Confident User

The complete step-by-step course — taught the same way as my videos, at your own pace.

  • Formulas, functions & clean data
  • Charts & PivotTables
  • Shortcuts & efficient habits
Enroll on Udemy

Taught by Ajay Anand · 7× Microsoft Excel MVP

Lifetime access · 30-day guarantee

Microsoft Excel course by Ajay Anand

Featured course

Microsoft Excel Beginner to Professional (Malayalam)

The complete step-by-step course — taught the same way as my videos, at your own pace.

  • Formulas, functions & clean data
  • Charts & PivotTables
  • Shortcuts & efficient habits
Enroll on Udemy

Taught by Ajay Anand · 7× Excel MVP

Lifetime access · 30-day guarantee

Fly to

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Archives

  • September 2026
  • March 2023
  • May 2022
  • April 2022
  • March 2022
  • November 2021
  • May 2021
  • April 2021
  • February 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • April 2019
© 2026 XL n CAD • Built with GeneratePress