## 'FREQUENCY function' category

Sum numerical ranges between two numbers

This article explains how to build an array formula that sums numerical ranges. Example, I want to know how to […]

This article explains how to build an array formula that sums numerical ranges. Example, I want to know how to […]

How to calculate overlapping time ranges

I found an old post that I think is interesting to write about today. Think of two overlapping ranges, it […]

I found an old post that I think is interesting to write about today. Think of two overlapping ranges, it […]

Extract the most repeated adjacent values in a column

The array formula in cell D3 returnsÂ the the length of longest consecutive sequence of a value in column A. Â Cell […]

The array formula in cell D3 returnsÂ the the length of longest consecutive sequence of a value in column A. Â Cell […]

How to use the FREQUENCY function

Returns how many times values exist in a given range. Note, this function returns an array of values.

Returns how many times values exist in a given range. Note, this function returns an array of values.

Count unique distinct values in a filtered Excel defined Table

This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]

This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]

Extract table headers based on a condition

This article demonstrates an array formula that returns the table header based on a condition. For example, in cell C8 […]

This article demonstrates an array formula that returns the table header based on a condition. For example, in cell C8 […]

Count unique distinct values that meet multiple criteria

This post demonstrates how to build an array formula that counts unique distinct values based on criteria. What's on this […]

This post demonstrates how to build an array formula that counts unique distinct values based on criteria. What's on this […]

Fuzzy VLOOKUP

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

Count digits and ignore duplicates

Question: I have a question that I canâ€™t seem to find an answer to: I want to make a full […]

Question: I have a question that I canâ€™t seem to find an answer to: I want to make a full […]

Sort rows based on frequency and criteria

Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]

Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]

Create numbers based on numerical ranges

The image above shows an array formula in cell B3 that calculates numbers based on the numerical ranges in cell […]

The image above shows an array formula in cell B3 that calculates numbers based on the numerical ranges in cell […]

Find empty hours in a weekly schedule

The image above demonstartesÂ an array formula in cell B34 that extracts empty hours in a weekly calendar. I have created […]

The image above demonstartesÂ an array formula in cell B34 that extracts empty hours in a weekly calendar. I have created […]

Extract dates from overlapping date ranges

The array formula in cell B3 extracts overlapping dates based on the date ranges in columns D and E. What's […]

The array formula in cell B3 extracts overlapping dates based on the date ranges in columns D and E. What's […]

Count unique distinct values within same week, month or year

The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]

The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]

How to count unique distinct values based on a date

The array formula in cell D3 calculates the number of unique distinct items based on the given date in columnÂ B. […]

The array formula in cell D3 calculates the number of unique distinct items based on the given date in columnÂ B. […]

Count unique distinct numbers across multiple sheets

The image above demonstrates three different formulas in column E that counts unique numbers unique distinct numbers duplicate numbers from […]

The image above demonstrates three different formulas in column E that counts unique numbers unique distinct numbers duplicate numbers from […]

Count unique distinct values

This article describes how to count unique distinct values. What are unique distinct values?Â They are all values but duplicates are […]

This article describes how to count unique distinct values. What are unique distinct values?Â They are all values but duplicates are […]

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 […]

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