GetUniqueValues.cf ( TextList ; ExceptionsList )
Gets unique values from a list (excluding values specified in the second list)
Average rating: 4.6 (29 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Filters a list, returning only one instance of any repeated value. Items are returned in the oder of first appearance. Additionally, you can submit a list of values to be ignored—for example spaces, dashes and other characters that may have been entered into a field in lieu of a proper value. Such items will be ignored only is the *whole line* of the list matches the *whole* of one of the 'ignore-items'
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.