Find if value already exists in list and do not return duplicates

[Alecs]

Hello,

I need a formula that ignores all blank cells and displays only the first value from a list - once in first cell - ignoring duplicates.

The list is displayed in column A

Column B needs to return the result as shown in the screenshot below:

cell B4 returns "TEST1" and all the other cells from below are empty

Many thanks in advance!

Alecs

[#2 · Accepted solution]

Hi @Alecs,

You can copy and paste the following formula into B1, and simply drag it down.

=IF(A1="","",IF(COUNTIF(A$1:A1,A1)=1,A1,""))

Regards,
Zach