excel 'mode' function w/ decimals

Discussion in 'Trading Software' started by dividend, Aug 24, 2007.

  1. 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?


    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

    none of which work.

  2. sim03



    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.
  3. That seems to be it. Thanks for your reply.