Explanation

This example uses the UNIQUE function, which is fully automatic.

UNIQUE is a dynamic function.

If any data in B5:B16 changes, the output from UNIQUE will update immediately.

Excel formula: Extract unique items from a list

Dynamic source range

UNIQUE won’t automatically adjust the source range if data is added or deleted.

Excel formula: Distinct values

Excel formula: Count unique values

Excel UNIQUE function