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 ErgoSoma http://www.ergosoma.com

  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).

Comments

		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. Developer, 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. Thanks,

		caps, Portugal Feb 25, 2012
Hi found the problem, the tittle is wrong should be: IdentifyDupes ( Original_List ; i ; Dupes )

		Jon Rosen, Florida Feb 25, 2012
Thanks for pointing that out. I changed the title.

		H, CHCH Mar 8, 2016
Thanks for sharing!

Log in to post comments.

Note: these functions are not guaranteed or supported by BrianDunning.com. 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 20 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: