## 'NOT function' category

Count cells with text

Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]

Table of Contents Count cells with text Count cells with text excluding cells containing a space character Count text values […]

How to use the NOT function

What is the NOT function? The NOT function returns the Boolean opposite to the given argument. TRUE returns FALSE and […]

What is the NOT function? The NOT function returns the Boolean opposite to the given argument. TRUE returns FALSE and […]

SUMPRODUCT if not blank

This article describes ways to work with the SUMPRODUCT function and blanks, error values, N/A# errors. Table of Contents SUMPRODUCT […]

This article describes ways to work with the SUMPRODUCT function and blanks, error values, N/A# errors. Table of Contents SUMPRODUCT […]

If cell contains text from list

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

Extract duplicate values with exceptions

This article demonstrates formulas that extract duplicate values from a column, however, column D contains values that you don't want […]

This article demonstrates formulas that extract duplicate values from a column, however, column D contains values that you don't want […]

Wildcard lookups and include or exclude criteria

This article demonstrates three different ways to filter a data set if a value contains a specific string and if […]

This article demonstrates three different ways to filter a data set if a value contains a specific string and if […]

Extract unique distinct values from a relational table

In this post, I am going to show you how to extract unique distinct values and duplicates using a formula, […]

In this post, I am going to show you how to extract unique distinct values and duplicates using a formula, […]

Filter values that exists in all three columns

This article explains how to extract values that exist in three different columns, they must occur in each of the […]

This article explains how to extract values that exist in three different columns, they must occur in each of the […]

True round-robin tournament

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

Merge two columns with possible blank cells

This article demonstrates two formulas, they both accomplish the same thing. The Excel 365 formula is much smaller and is […]

This article demonstrates two formulas, they both accomplish the same thing. The Excel 365 formula is much smaller and is […]

List all unique distinct rows in a given month

This article demonstrates a formula that extracts unique distinct records/rows for a given month specified in cell C2, see the […]

This article demonstrates a formula that extracts unique distinct records/rows for a given month specified in cell C2, see the […]

Extract unique distinct values sorted based on sum of adjacent values

Filtering unique distinct text values and sorting them based on the sum of adjacent values can easily be done by […]

Filtering unique distinct text values and sorting them based on the sum of adjacent values can easily be done by […]

Create unique distinct list sorted based on text length

The formula in cell D3 extracts unique distinct values from B3:B20 sorted based on the number of characters, it works […]

The formula in cell D3 extracts unique distinct values from B3:B20 sorted based on the number of characters, it works […]

Filter values in common between two cell ranges

The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]

The image above shows an array formula in cell B12 that extracts values shared by cell range B2:D4 (One) and […]

Filter unique distinct records

Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]

In this blog post I will demonstrate methods on how to find, select, and deleting blank cells and errors. Why […]

## 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