Check for duplicates and exclude blank cells


Hi. I am trying to write a formula that will check for duplicates in a column but skip the blanks. The normal formula I use is Countif([Column Name]:[Column Name], [Column Name]@row) this counts blanks. I have tried =IF(ISBLANK([Column Name]@row), 0, IF(COUNTIF([Column Name]:[Column Name], [AColumn Name]@row) > 1, 1)) I get an incorrect argument error. I have also tried =IF([Column Name]@row ISBLANK(), "0", COUNTIF([Column Name]:[Column Name], [Column Name]@row)) but I get an unparsable error.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!