How to delete empty rows

I highly recommend you keep the original data and only copy the data excluding blank rows and paste to a […]

How to filter using OR logic between columns [Advanced Filter]

The built-in filter feature in Excel is a powerful tool, however, it won't allow you to filter with OR logic […]

Create a unique distinct list using Advanced Filter in a macro [VBA]

Question: hi all, thanks for the great formula/array formula. it works great. lately, i noticed that the array formula will […]

Filter unique distinct values if value contains specific string [Formula and Advanced Filter]

Table of contents Filter unique distinct values using a "contain" condition Filter unique distinct values using a "contain" condition (Advanced […]

Advanced custom date filter

Question: How do I filter the last xx years or xx months in Excel? How do I exclude the current […]

5 easy ways to extract unique distinct values

You have quite a few options to choose from if you are looking for a way to create a unique […]