In Microsoft Office Excel 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 Data Tools group on the Data To filter for unique values, use the Advanced Filter...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

In this blog, I will try to cover how to use a Custom Autofilter in Excel using Excel VBA. 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...Read More