duplicate detection assitance
If anyone is looking for something similar here was my answer and worked 100%
=IF(AND(Agent@row <> "", COUNTM(COLLECT([Product Sold]:[Product Sold], Agent:Agent, @cell = Agent@row, Date:Date, @cell = Date@row)) > 3), "Red", "")
Once the cell worded red, conditional formatting turned the offending cells red with white text for me on the 4th instance.
Good day all,
I am working on a project that requires data to not exceed 3 entries per day. The reason for this is that the list of entries can grow long at times and missed.
I have started working on a formula for it. However I am met with the lovely Unparseable error.
I am sure I goofed this up 100% I am still learning.
What I need it to do is if there are three of the same names in the Agent column to condition it to highlight anything beyond 3 in red to make the user stop and review it first before proceeding. I hope that makes sense. Any help on this would be amazing!
In the sample provided, Test 1 has made it 3 times, so in essence the 4th entry I would like it to highlight to red.
=COUNTIFS([Agent Column]:[Agent Column], [Agent Column]@row, [Date Column]:[Date Column], [Date Column]@row) > 3
Help Article Resources
Check out the Formula Handbook template!