Column Formulas for Duplicates

Katrina Liu

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)

Kelly Moore

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