Return the top 10 most common text values

Hi guys,

Newbie here and am in need of some help. I'm trying to find the most common 10 text value occurrences.

I have a column (I) which has a list of languages. I need to find the top 10 most common. The data is located in I2:I50

Any help would be greatly welcomed!

Thanks,
Carl.

Hello and welcome to the forum.

The easiest way to do this would be to use a Pivot Table.

Highlight column I > Insert > PivotTable >Put it where you want > Drag column I into ROWS and again into VALUES > Sort VALUES largest to smallest

Try this, and change the range to the one you have:
=IFERROR(INDEX($A$1:$A$54,MODE(IF(ISERROR(MATCH($A$1:$A$54,D$1:D1,0)),MATCH($A$1:$A$54,$A$1:$A$54,0)))),"")

Array entered

Thank you both 63FalconDude and PaulM100!!

Both worked a treat!

Many thanks for the help
Carl.