Column Formulas for Duplicates
Identifying duplicates with consideration of blanks
This is the formula I am using to identify duplicates and trying to omit blanks and it is giving me a syntax error, can someone please help?
Also, could I make this a column formula?
=IF(ISBLANK([Folder Name]),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0)
Best Answer
-
Hi @Katrina Liu
It looks like you forgot an '@row' at the beginning of your formula. This should allow you to convert to a column formula.
=IF(ISBLANK([Folder Name]@row),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0))
cheers
Answers
-
Hi @Katrina Liu
It looks like you forgot an '@row' at the beginning of your formula. This should allow you to convert to a column formula.
=IF(ISBLANK([Folder Name]@row),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0))
cheers
Help Article Resources
Categories
Check out the Formula Handbook template!