Duplicate Formula Not Working As Expected
Hello,
I have two columns, one has job numbers in it, and the one beside it has this formula to detect if the first coiumn has duplicates: =IF(COUNTIF([Complete Job Number]:[Complete Job Number], [Complete Job Number]51) > 1, 1).
The row number51 in my example formulachanges for each row.
It doesn't turn on when I have duplicates, but in the empty cells (you only see one in the screenshot but there are more below it), it does come on. What am I missing here?
Thanks for the help. I appreciate it.
Answers

Try
=IF([Complete Job Number]@row = "", 0, IF(COUNTIF([Complete Job Number]:[Complete Job Number], [Complete Job Number]@row) > 1, 1, 0))
This way, if the cell is blank, the box will automatically be checked and if it is not blank, then it will process the equation. Let me know if you have any questions!

Well, that got rid of the false positives for blank cells, but the checkboxes still aren't coming on when there is a duplicate number in the "Complete Job Number" column.
Thanks.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.4K Get Help
 61 Global Discussions
 46 Industry Talk
 384 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!