Forum Discussion
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 need...
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
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