"Mode" function - using text

[wrightr]

You can use the "mode" function to return a value that has occured the most time in a range

This only works for numeric values but I need this to work for text values as well.

Does anyone know how to do this?

 

[Andrew Poulsom]

Maybe try eg:

=INDEX(A1:A10,MATCH(MAX(COUNTIF(A1:A10,A1:A10)),COUNTIF(A1:A10,A1:A10),FALSE))

which must be confirmed with Ctrl+Shift+Enter, not just Enter. If correctly entered Excel will surround this array formula with curly braces {}.

 

[wrightr]

Andrew - that works perfectly

Thanks - has saved me several hours work!