Function "MODE" applied to characters.

Sorry my English!

What I need is to calculate the mode, lets say in column A2:A8, where I have in each cell diferent letters. exemple:

A2=F
A3=D
A4=H
A5=J
A6=F
A7=F
A8=F

So, the letter that most repeats is "F". Is it possibile to write a code, that gives me the mode from A2 to A8?
I Work with excel 2007.
Thank you!

Try:

=INDEX(A2:A8,MATCH(MAX(COUNTIF(A2:A8,A2:A8)),COUNTIF(A2:A8,A2:A8),0))

confirmed with CTRL+SHIFT+ENTER not just ENTER

See attachment for translations to your language/version.

Unless you have a fixed number of times you know it will repeat, you will need a couple of helpers...

So if your original list is in A2:A8, for example,

then in C2 enter formula:

=MAX(COUNTIF($A$2:$A$8,$A$2:$A$8))

confirmed with CTRL+SHIFT+ENTER

Then in B2 enter formula:

=IF(AND(COUNTIF(A$2:A2,A2)=1,COUNTIF(A$2:A$8,A2)=$C$2),COUNT(B$1:B1)+1,"")

copied down.

and in D2 enter formula:

=MAX(B2:B8)

then to get results use:

=IF(ROWS($A$1:$A1)>$D$2,"",INDEX($A$2:$A$8,SMALL(IF(COUNTIF($A$2:$A$8,$A$2:$A$8)=MAX(COUNTIF($A$2:$A$8,$A$2:$A$8)),ROW($A$2:$A$8)-ROW($A$2)+1),ROWS($A$1:$A1))))

confirmed with CTRL+SHIFT+ENTER and copied down.

If you know the number of times a max repeat will happen, then you just need the last formula copied down that many times.

Jesus! I've copied down the formulas down to my excel sheet, but didnīt study them yet, cause I'm at work right now. A2:A8 it's just an example, cause the real case is hundreds of cells, and I don't know how many times "letters" will repeat. I only know the letters I will have to use, dontīknow if that helps.
To test this formulas, I've put in A2:A8, three "F" and three "T", wrote down this formulas to excel, like you said, but didnīt understand the final result. This last formula got me the result "t". If doesnīt bother you, maybe you could send me this formulas in excell sheet, like it's sopposed to be working, in case i'm not doing it right.

Once again, thank you so much. It's people like you that make this world much better.

As is often the case, after looking at it again, I think I overcomplicated it a bit... the final formal doesn't need to be that complex... substitute it with:

=IF(ROWS($A$1:$A1)>$D$2,"",INDEX($A$2:$A$8,MATCH(ROWS($A$1:$A1),$B$2:$B$8)))

Entered only with ENTER.

I attached the document here for you.