I have Multiple text/sentences and number in multiple columns. I need to find "list and number" of unique words in next sheet. Then I need to find "list and number" of given sentences. Can anybody help me out ?
I have Multiple text/sentences and number in multiple columns. I need to find "list and number" of unique words in next sheet. Then I need to find "list and number" of given sentences. Can anybody help me out ?
Same as your previous thread?
VBA: Find all sentences with a given word. Partial match preferred with regex.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Excel sheet attached. Thank you in advance.
Try
Please Login or Register to view this content.
Not working
..........................
Hmm the "BEFORE sheet" Column A has data. After the macro has ran successfully the result should be as in "AFTER sheet1". In AFTER sheet1 output data should be like in column B - G; until there are keys left. Hope its clear now. For each key there are two column. One for exact match and another for partial match. So sentences are copied as per key.
I see
Please Login or Register to view this content.
Last edited by jindon; 06-25-2017 at 08:01 AM.
Thank you again but the output is not matching with the "AFTER sheet1" columns.
words from same row with matching key should be grouped in same row.
For each key there are two columns column: Exact word: "XXXXXX" & column: Similar to word: "XXXXXX" Please check the output in AFTER sheet1 for key "win".
Moreover if I change any key it seems its not working.
Please ignore small letter capital letter issue.
OK, I think I understand what you are trying to do now.
Then I need a clear definition of difference between "Exact" & "Similar" words.
Please Login or Register to view this content.
Thank you very much again from the core of my heart. It didn't cached the data from cell A4.
Try replace the code with this one
Please Login or Register to view this content.
With same condition's -- if I want to get the same kind of result with with two or more cell data making a pair with one another in reference then ?
I don't understand what you are asking.
Found a bug in the previous code.
Please Login or Register to view this content.
Thank you very very much.
1. I mean I want to extract same result with two ref cell instead of 1 reference as above.
Example: say
if there are 2 reference. 1 will make pair with 1, 1 with 2, then 2 with 1 and 2 with 2.
If there is 3 reference then 1-1, 1-2, 1-3, 2-1, 2-2, 2-3, 3-1, 3-2, 3-3.
2. Can I check the existence of the refs [two column for each ref like before] and giving the result ?
Last edited by first_jaguar; 07-05-2017 at 03:55 AM.
Still not sure.
If you upload a workbook showing before/after, it would help.
Here it is.
Dear Jindon now I need to work the previous code to run in multiple sheet.
It will be too much work for free forum, so I suggest you to go to Commercial Services where you will get prompt reply quickly.
O.K.
with little change do the previous code can find only the matching strings only in similarly formatted output sheet ?
Last edited by first_jaguar; 07-17-2017 at 12:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks