FeedBack Extractor in Excel

[sanket_sk]

Dear All,



Merry Christmas !!!



I am working on consumer feedback, there are thousand of entries out of which I want to extract actual expressions of consumers, for which I am looking for formula which will return common word used in cell and count of those words.



For example …



Consumer feedbacks are captured in Column “D: D” in sheet1, in sheet2 we can apply VBA or formula which will return following result..



A1 B1

Excellent 900

Bad 400

Improve 250



And so on ..



Please help me build this formula

 

[sanket_sk]

Depends on what your data looks like, but as this is a significantly different question, it needs a new thread.

Hi Fluff,

I have created new thread..

FeedBack Sentence Extractor in Excel

Hi Fluff, Creating a new thread for feedback extractor. Although the below solution works very well, however, is it extracting only common words, Please help me build VBA code that will help extract common sentences with intervention counts in descending order.. Example... “Power...

www.mrexcel.com

Sanket

 

[sanket_sk]

Hi Fluff,

I have created new thread..

FeedBack Sentence Extractor in Excel

Hi Fluff, Creating a new thread for feedback extractor. Although the below solution works very well, however, is it extracting only common words, Please help me build VBA code that will help extract common sentences with intervention counts in descending order.. Example... “Power...

www.mrexcel.com

Sanket

Depends on what your data looks like, but as this is a significantly different question, it needs a new thread.

Hi Fluff,

Requesting you to extend your support here.

Sanket