MostFrequentTerm ( theList )
Yields the most frequently-occurring term in a list of values.
Be the first to rate this function Log in to vote
Brian Panhuyzen - Show more from this author
Neutrino Data Systems
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Provide the function with a list of values that includes repeating terms, and it will yield the most frequently occurring term. A tie in most-frequent terms (e.g., two or more terms occur with the same frequency) will result in only the latest term in the list appearing.
The function can be adapted to show a list of all the terms in order of diminishing frequency by removing the GetValue function for the ~Result.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.