Forum Discussion

Copper Contributor

Jun 09, 2017

Help counting duplicate values/words

Hello, I have a worksheet with about 80 responses that are in a sentence format that I am trying to figure out how to count and sort keywords that are used multiple times. These are verbatim respons...

Example Sheet.xlsx10 KB

Formulas & Functions

tips and tricks

Amber McCurtis

Copper Contributor

Jun 10, 2017

Thank you, Sergei! I'm not familiar with Power Query and not really experienced in Excel. I've tried following your instruction with no success. I've attached an example in my original post. I'm trying to extract the top 20 words/terms used from the worksheet. I've been trying to look on YouTube because I'm visual but, still no luck.

SergeiBaklan

Diamond Contributor

Jun 10, 2017

Hi Amber,

When things bit more complex, but since that's practically ready-to-use solution you may use it as black box so far.

First, you have to have Power Query with your Excel. If you are on version Excel 2016 it's built-in (and called Get & Transform now). Nothing to do here.

If you are on earlier version

you need to download and install Microsoft Power Query for Excel add-in. Installation is straight forward and usually no problems are here.

If you are on even earlier version of Excel - no luck with this solution.

I'll check your file when understand how to download it - TechComm changed the interface and so far i see no way to do that.