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 […]
Extract unique distinct values if value contains string
The image above demonstrates a formula in cell F3 that extracts unique distinct values from column B if they contain […]
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
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]
Unique dist. list
Most used functions
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.