Unique values with multiple criteria

To extract a list of unique values from a set of data, while applying one or more logical criteria, you can use the UNIQUE function together with the FILTER function. In the example shown, the formula in D5 is: =UNIQUE(FILTER(B5:B16,(C5:C16="b")*(D5:D16>5))) which returns the 3 unique colors in group B with a quantity > 5.

April 14, 2025 · 1 min · 68 words · Brianna Palmer

Table of Contents

Explanation

This example uses the UNIQUE function together with the FILTER function.

UNIQUE then removes duplicates, and returns the final array:

UNIQUE and FILTER aredynamic functions.

If source data changes, output will update immediately.

Excel formula: Unique values

The output from FILTER is dynamic.

If source data or criteria change, FILTER will return a new set of results.

This makes FILTER a flexible way to isolate and inspect data without altering the…

Excel formula: Unique values with criteria

Excel formula: Distinct values

Excel formula: Unique values ignore blanks

Excel formula: Extract unique items from a list

Excel UNIQUE function

Excel FILTER function