I have some survey data with responses in individual cells. What I need to do is to take all of the words and figure out how many occurrences there are of each word (combining misspellings and plural words into one eg bathrooms, batrooms, and bathroom should all be shown as bathroom 3) Thank you for your help.
Hi,
Check this out, this should take care of plurals, however, not spelling error... Not sure if that can be done..
=SUMPRODUCT(ISNUMBER(FIND(IF(RIGHT(A1,1)="s",LEFT(A1,LEN(A1)-1),A1),Now!$A$1:$A$7))*1)
Cheers!
Deep Dave
Well I think I found a work around. It's not pretty, but it works. I'm using the text to columns and then using plugin to convert a range to a single column. From there I am using a pivot table to give me the counts and removing duplicates. Not the quickest method, but at least it works (other than the misspellings).
If you are not concerned about misspellings, then my formula will work.. Give it a try!Originally Posted by bbarth
And it will be quicker..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks