I was able to find a formula that works to ignore blank cells and identify duplicates but the first entry is also being labeled a duplicate. Is there a way to ignore the first entry and only add duplicate to all proceeding?
=IF(AND([Column Name]@row <> "", COUNTIFS([Column Name]:[Column Name], [Column Name]@row) > 1), "Duplicate")
Help Article Resources
Check out the Formula Handbook template!