Most common words formula?

[Sirliamtron]

Hi all,

Sorry if this is a bit of a dumb post but I don't often use excel and no nothing about forumulas. I need to create something that will give me the top 10 most used words in my B column in the highlighted boxed below E.G: 1st - D3, 2nd - D4, 3rd - D5 ect. I understand I'll need to use a separate formula in each cell but I can't work out how to make this work

Screenshot of document available here: Forum Ref - Album on Imgur

 

[Sirliamtron]

Whoops, type there. I meant to write "and know nothing about forumulas"

 

[SyedUsman]

=INDEX(F2:F15,MODE(MATCH(F2:F15,F2:F15,0)))

where F2:F15 is where your list is

Use Ctrl + Shift + Enter