You don't need to build anything to do that, Excel already has that capability.
On the Data menu, there is a "Remove Duplicates" feature that will do this for you.
To what end?
How/why does it need to work differently than the built-in functionality?
Also, what is the structure of your data (how many columns are being included in the duplicate determination)?
Are you looking for a VBA or non-VBA solution?
To do it strictly by formula is possible, but the formulas are very complex. I have never attempted them, as I have always used one of the three options:
- Built-in "Remove Duplicates" functionality
- Advanced Filters
- Microsoft Access
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.