Having trouble with the duplicate formula and where to input.
I am trying to set-up a formula, so if there is a duplicate in the Family ID column, the box becomes checked in the Duplicate column. So far, during the searching I have done for other users with this same problem, I am still left with an error message each time.
Is there a way to run the formula on the whole column, or do I need to do it for each entry?
I would appreciate any help. Thank you in advance. 😊
Help Article Resources
Check out the Formula Handbook template!