AnsweredAssumed Answered

Find similar values in a List()

Question asked by FH on May 21, 2012
Latest reply on May 24, 2012 by philmodjunk

Title

Find similar values in a List()

Post

Hi,

 

I would like to calculate in a list that I populate with the List() function from different fields, which number has the most occurences, eg. for the list

2 3 2 5 1 5 2 1 

The result should be 2, since this value has the most occurences compared to the other values.

I wonder if it is possible to calculate this with a plain calculation or a custom funcion, not using a script.

Thanks,

 

Francis

Outcomes