Brian Dunning's FileMaker Custom Functions

IdentifyDupes ( Original_List, i, Dupes )

Returns only unique duplicate values from a list. Most of the time we're trying to identify the unique values in a list. This CF returns the values in a list that have duplicates.

  Average rating: 4.7 (29 votes) Log in to vote

Jon Rosen   Jon Rosen

Share on Facebook Share on Twitter

  Sample input:
IdentifyDupes ( Apples
Grapes ; 1 ; "" )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Usually, we're trying to identify the unique values in a list. This custom function does the reverse. It returns a unique list of duplicate values from a list (one value per duplicate).



caps   caps, Portugal
Feb 25, 2012
This function have some issues, because when you try to past it into custom function, there are warnings about some variables that aren't identified.

1. How is possible to have "1" or empty "" as function parameter?
2. The function parameter is List_of_Values, but you use a variable called Original_List.

caps   caps, Portugal
Feb 25, 2012
Hi found the problem, the tittle is wrong should be:

IdentifyDupes ( Original_List ; i ; Dupes )
Jon Rosen   Jon Rosen, Florida
Feb 25, 2012
Thanks for pointing that out. I changed the title.
Mar 8, 2016
Thanks for sharing!

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: