Introduction
The UNIQUE function helps you find all the different values in a list or column. It removes any repeated items so you see each value only once. This is useful when you want to quickly see all unique entries without sorting or filtering manually.
When you have a list of names and want to see each name only once.
When you track sales and want to list all different products sold.
When you collect survey answers and want to find all unique responses.
When you want to create a dropdown menu with only unique options.
When you want to count how many different items appear in a column.