How to Find and Remove Duplicates in Excel In Microsoft Office Excel 2007, Excel 2010, Excel 2013, Excel 2016, you have several ways to filter for unique values or find and remove duplicates in Excel. Now, you will learn how to find & remove duplicate values in excel. Use the Remove Duplicates command in the...Read More

In this blog, I will try to cover how to use a custom Excel VBA autofilter in excel. This Advanced Excel filter technique is meant for Advanced Excel users.  We all know how to use a custom filter or advanced filter in Excel which is also knows as Excel VBA auto filter. Creating custom Excel VBA...Read More

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S....Read More