Please send an Excel sheet to benefit from the wonderful content
@rickrothstein3681
26 күн бұрын
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)))))))
@excelchamps
27 күн бұрын
Thanks Bob. So Smooth.
@TimTheMusicMan
Ай бұрын
Oh, this is Bob Umlas, one of the worlds perennial and foremost Excel developers. So glad he is on YT.
Пікірлер