Explore Free Excel Tutorials and Online Excel Videos

Subscribe Us and Get an Excel E-Book, Shortcuts and Excel Tutorial Addin


VBA Code to Remove Duplicate Records

Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.

Excel Function Replace

How to use “REPLACE” function in Excel REPLACE function is used to replace the existing [...]

Chapter 1 – Introduction to VBA

In this chapter, we are going to understand what is VBA, why we need VBA. [...]


SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k

Popular Products on Excelsirji

Simple, Smart and Automated Utilities
Duplicate Files Finder Tool
Duplicate File Remover - Windows version
/ Single User
Remover Duplicate Files/Folders
No Installation Needed. Only Excel Driven
Remove/Move Duplicate Files
Bulk Movement/Removal
Purchase now
Employee Database Tool
Employee Database Management - MS Access
/Single User
One Time Fees/No Installation
Lifetime Free Updation
Custom Trackers Creation
Excel Import Option Available
Purchase now
Random Rows Selector Tool
Random Data Sampling
/Single Users
Random Sampling Free Tool
Includes Stratified Sampling
Windows Version
Purchase now

Views From Readers