Using the mode function
"Leo Rod" <leo@rod_com wrote...
Try
=Mode(max(values))
let me know.
....
Learn to test before responding. MAX(anything) returns only one value,
and MODE(just_one_value) *ALWAYS* returns #N/A. MODE will only return
a value when passed values, arrays or ranges that contain at least two
equal values. So MODE(1,2) returns #N/A, while MODE(3,3) returns 3.
|