Formula that writes most repetitive text from selected cells

Hi,
I have excel table that looks like this:

text1
text2
text3
text2
text2
text2
text1
text3
text2
text2
text2
text2

The most repetitive text in this table is "text2". Now I want formula to automatically find most repetitive text and write it.
It would be best if it can be done within one cell.

Originally Posted by 63falcondude

Hello and welcome to the forum. Try this:

=INDEX(A1:A12,MODE(MATCH(A1:A12,A1:A12,0)))

Adjust the ranges to suit your data.

Thanks for trying to help but unfortunately this just returns value not available error.
I adjusted ranges to suit my data but error still persists. I also checked that data is valid.
Anyone who knows something about this please post here.

Originally Posted by Phuocam

Or try this:

=INDEX(A1:A12,MATCH(MAX(COUNTIF(A1:A12,A1:A12)),COUNTIF(A1:A12,A1:A12),0))

Enter with Ctrl+Shift+Enter.

Thank you on your help. This is working perfectly.
If I will have any other questions I will post.