Forum Discussion

Alecs's avatar
Alecs
Brass Contributor
Dec 08, 2022
Solved

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

 

 

Many thanks in advance!

Alecs

 

 

excel
  • Zach Prins's avatar
    Zach Prins
    Dec 08, 2022

    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

  • Zach Prins's avatar
    Zach Prins
    Brass Contributor
    Dec 08, 2022

    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

Resources