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
-
You can try to use "" instead of ISBLANK. It pretty much means the same thing.
=IF([Column Name]@row = "", 0, IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) = 1, 0, 1))
Hope this works for you.
Answers
-
You can try to use "" instead of ISBLANK. It pretty much means the same thing.
=IF([Column Name]@row = "", 0, IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) = 1, 0, 1))
Hope this works for you.
-
Thank you. That worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!