In Excel I use the unique() function to get unique values of a column. As soon as I have empty rows in my column, they appear as "0".

Formula for D2: =UNIQUE(C2:C8)

My question:

How can I replace the "0" with another value e.g. "Empty cell"?

The result should look like this:

I know that I can use UNIQUE() with FILTER() to ignore empty values / cells. However, in my case I want to keep them just "name" them differently.

Thanks in advance

>Solution :

Why do you need filter()?

Just set the last argument to 1 in unique()

Or you can do this with if() as well: