'Advanced filter' category
How to delete empty rows – advanced filter
I highly recommend you keep the original data and only copy the data excluding blank rows and paste to a […]
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]
Table of Contents How to filter using OR logic between columns Advanced custom date filter 1. How to filter using […]
Table of Contents How to filter using OR logic between columns Advanced custom date filter 1. How to filter using […]
Lookup with any number of criteria
This article demonstrates a formula that allows you to search a data set using any number of conditions, however, one […]
This article demonstrates a formula that allows you to search a data set using any number of conditions, however, one […]
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 […]
Question: hi all, thanks for the great formula/array formula. it works great. lately, i noticed that the array formula will […]
Advanced custom date filter
Question: How do I filter the last xx years or xx months in Excel? How do I exclude the current […]
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 […]
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values