Check for Duplicates and Blanks
I want to check a column for duplicate entries, but if the field is blank, I want it to be ignored. So far, here's what I have. It works for checking duplicates, but if it's blank it still sets it's value to 1 (because there are multiple blank rows). I'm using this for an automation script in a column formula to have all rows flagged send an email.
=IF(COUNTIF([Actual Funding Source]:[Actual Funding Source], [Actual Funding Source]@row) > 1, 1, 0)
What can I add to this statement to get it to only count the rows with data input in them?
Help Article Resources
Check out the Formula Handbook template!