Count top values from a range of values (mode at the top). Useful to detect data anomalies, patterns and degree of variability in values (how different things are, how many nulls, etc)

tally.gsheet.js

/* Tally v 1.0 */
function tally (range, limit = 10){
      let total = range.length,
        values = {}
      for (let [k, v] of range) {
        k = ('' + k).replace(/\n[\s\S]*/, '…')
        values[k] = values[k] ? values[k] + 1 : 1
      }

      return Object.entries(values)
        .sort((a, b) => b[1] - a[1])
        .map(
          ([k, v]) =>
            k +
            ('' + v).padStart(6) +
            (Math.floor((100 * v) / total) + '%').padStart(5)
        )
        .slice(0, limit)
        .join('\n')
    }