SOLVED

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

Brass Contributor

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

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

best response confirmed by Alecs (Brass Contributor)
Solution

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

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

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

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