FUNCTION RETURN VALUE THAT IS MORE REPEAT

[rogeriobarbosa]

I NEED AN EXPRESSION OR FUNCTION TO RETURN THE VALUE THAT MORE REPEATS WITHIN A FIELD

EX: VALUE

           a

           2

           3

           3

           4

           3

  The EXPRESSION

SUM (VALUE)

SHOULD RETURN 3

THANK YOU

[Nicole-Smith]

The mode function gives the value that shows up the most in a data set.

=mode(VALUE)