Sirliamtron
New Member
- Joined
- Aug 16, 2017
- Messages
- 2
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
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