I'm looking for a custom function that will return the most frequent value in a list. Has anyone seen this or feel like trying to make one?
What you are looking for statistically is called the "mode". http://www.briandunning.com/cf/1587 is a custom function for the mode.
Have you looked at www.briandunning.com?
I have and I found something that will count the values but I just want the most frequently appearing value.
Does it need to be a custom function or could it be a script?
Depending on the size of your list you may run into the recursion limit of CFs
I need it to be a custom function. I have a list of work orders and I want to get the username of the person that has entered the most notes. These notes are related records. Doing this I will be able to see who "Owns" the work order.
Perhaps this cound be altered to fit your use...
Retrieving data ...