excel 'mode' function w/ decimals

D

dividend

Hello. How can I convert my array of numbers with large decmials into integers or rounded decimals so that I can use the mode function?

Example:

cell array in A1, A2, A3 = { 1.1234, 1.1357, 2 }.
MODE(A1:A3) == N/A

conversion to -> { 1.1, 1.1, 2 }
MODE(A1:A3) == 1.1



tried doing round() for each cell, and
mode(round(a1,1):round(a3,1))

none of which work.

Thanks.
 
mode(round(a1:a3,1))

You were close. "Doing round() for each cell" - as in creating another array with rounded values outside of a1:a3, then taking mode of that array - also works, although must lose points for lack of parsimoniousness.
 
You must log in or register to reply here.
Back
Top