0 Replies Latest reply on Oct 29, 2018 2:51 AM by Alex Martino

    Find the mode (most common value)

    Alex Martino

      Hello. I have a column with averages by order ID. How do I find the most common average and return that value as it's own column of values? Spreadsheet attached.

       

      In this case, the new column would have all "2.0" (since 2.0 is the most common average). Thanks!