Most Common Letter

Поделиться
HTML-код
  • Опубликовано: 25 июн 2024
  • Find the most common letter in a list of words, using one formula, no helper columns
  • НаукаНаука

Комментарии • 2

  • @excelchamps
    @excelchamps 11 дней назад

    Thanks Bob. So Smooth.

  • @rickrothstein3681
    @rickrothstein3681 10 дней назад

    A proposed change to your formula so that it will be able to report multiple letters when there are ties as to their counts (my guess is there is probably a more compact way to do this, however)...
    =LET(x,TEXTJOIN("",,B4:B23),TEXTJOIN(", ",,SORT(CHAR(MODE.MULT(CODE(MID(x,SEQUENCE(LEN(x)),1)))))))