SOLVED

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

Brass Contributor

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

Alecs_2-1670485788120.png

 

 

Many thanks in advance!

Alecs

 

 

1 Reply
best response confirmed by Alecs (Brass Contributor)
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

1 best response

Accepted Solutions
best response confirmed by Alecs (Brass Contributor)
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

View solution in original post