Displaying posts categorized under

Technical

Delete duplicates in Excel

Once in a while I want to write an article on technology. Here is the first one.

Have you ever had a large dataset (or small) that you imported into Excel somehow and you just want to remove all the rows that duplicate on a certain column? Here’s a couple quick macros you can use to solve your problem. Just copy and paste this code into a module in Excel VBA and run them like any other macro.