Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The mode function gives the value that shows up the most in a data set.
=mode(VALUE)