Frequency bug?

Can someone explain to me why this happens? This example is working. FREQUENCY function returns {2; 1; 1}. 2 values (0.1 and […]

Find the longest/shortest consecutive sequence of a value

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.

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

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

How to count unique distinct items on a given date

The array formula in cell D3 calculates the number of unique distinct items on the given date. Unique distinct values […]