Finding the most common words or phrases in a field

DoctorZoom

New Member
Joined
Jan 19, 2016
Messages
13
Hi, I'm doing troubleshooting on customer trouble tickets and without having to read through thousands of them, I'd like to be able to search for common words or phrases with a count in a particular field of the trouble ticket. All the tickets are in a excel spreadsheet and I want to do this for one field (column) called "customer narrative" Help would be greatly appreciated! Thanks
 
Hi again John,

Unfortunately that degree of detail is beyond my current coding capabilities as really I am only just learning this myself. As the moderator Peter mentioned in your other thread, something as complicated as this will take one of the real expert gurus to help you and it is quite possible that you may struggle to get that level of help and time commitment from a free forum.

I apologise that my suggestions were not suitable, but I think that this is probably as far as I can go.

I wish you luck with finding a solution.

Regards,

Fishboy

No Worries!
Appreciate all your time and effort!
 
Upvote 0

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,216,102
Messages
6,128,847
Members
449,471
Latest member
lachbee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top