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:
