Assuming data in A2:A10, you could also try something like this in say, B1,
array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=INDEX(A2:A10,MATCH(MAX(COUNTIF(A2:A10,A2:A10)),CO UNTIF(A2:A10,A2:A10),0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fred" wrote:
I need a formula similar to MODE function but instead of numbers only it's
alphanumeric(combination of letters and numbers or sometimes letters only).
The output should be the most frequently reccuring data.