I have a field on a form which is a list of names, and need to check to see if there are any duplicates. I want to do this using a separate calculated field which will list any entries that appear more than once in the source field.
How do I do this using a formula. My best guess is to use the @Unique function and then compare this to the original list, but I'm not if this is possible.
Help would be appreciated!