Mode() that works with string's

[Guest]

I'm trying to get a function to return the mode of a range, but unlike the
standard MODE() built into excel I need it to work with text strings. I
already know of a couple ways to do this with built-in Excel functions
(below) but the problem is these get very sluggish when using large ranges.
They also don't work when using ranges with multiple columns.
INDEX(rng,MODE(MATCH(rng,rng,0)))
INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng,rng),0))

Is there a UDF I can use to do this?
Thanks.

 

[Guest]

Hi Dave - well dont no any formula can do that, but here som
sergestion u can try, - it's not perfect - not even close
but try and work with it.
by the way it dont like empty cells and strings better be more than 2 char's

=MODE(CODE(A1:C6)*CODE(RIGHT(A1:C6;1))+LEN(A1:C6))



"Dave" skrev: