most used word s in Column B from A

**uday1969** · 07-08-2014, 11:03 PM

Hi Guru's,

I have column A and Column B

Column A contains cells 3243 filled with sentences (A1:A3243).

In Column B - I would like to get most used words with text from A1:A3243. I do not need to counting words.

Regards
Odaiah

**:) Sixthsense :)** · 07-09-2014, 02:01 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**uday1969** · 07-09-2014, 04:38 AM

Hi Guru's

I am looking for most commonly used words from column A.
I have attached the excel file.

Thanks
Uday

**Glenn Kennedy** · 07-09-2014, 05:00 AM

This might sound like a stupid question - but what, exactly, do you mean by "word"?

**:) Sixthsense :)** · 07-09-2014, 05:30 AM

Check the attached file and confirm whether this helps you

most used word s in Column B from A

LinkBack

Thread Tools

Rate This Thread

Display

most used word s in Column B from A

Re: most used word s in Column B from A

Re: most used word s in Column B from A

Re: most used word s in Column B from A

Re: most used word s in Column B from A

Thread Information

Users Browsing this Thread

Similar Threads

macro if data in column a = set word to insert that column into sheet 2 or 3 based on word

[SOLVED] Formula Query - COUNTIF? Column A contains word and Column B contains word

VBA to enter a word, find said word in string of column & copy to another column

Forula needed to replace a word in one column with another word in a different cell

How to search for a word in a column and have entire row opaque once word is found

Bookmarks

Bookmarks

Posting Permissions