Log In
Register
Home
September 6, 2019
Offline
Hi All,
Really, I’m very happy to find myonlinetraininghub.com as it is very valuable and I’m sure about I will learn a lot after I joined.
I would appreciate if you can help us to create macro as I have a lot of words and I want to know if it is found in other cells or not.
Like this word “Texas” and I want to know if it is found in these words or not.
Texas Instruments Incorporated : Found
Texasins device : Not Found
The Texas Company : Found
Note: the word should be found exact not part of word.
Please can anyone help me to create macro to do this.
Input:
Column “A”, will contain the word that’s need to search about it.
Column “B”, will contain the words will search on it.
Column “C”, contain website
Column “D”, contain Year
Output:
Column “F”: will contain the found word from Column”A”.
Column “G”: will contain the names which contain the word.
Column “H”: contain website
Column “I”: contain Year
Please check Attached file to get more sample.
Thanks;
Marsil
VIP
Trusted Members
June 25, 2016
Offline
Hi Marsil
Give this a try.
Sunny
September 6, 2019
Offline
Hi Sunny.
It works perfectly.
Thank you very much; your support is greatly appreciated.
just can you help me to let this macro ignore character sensitivity
I mean don't care the upper or lower case.
macro result for TExas is the same for texas
Thanks;
Marsil
VIP
Trusted Members
June 25, 2016
Offline
Hi Marsil
Hope this helps.
Sunny
September 6, 2019
Offline
Hi Sunny,
You are amazing! Thank you so much!
If u can fix the run-time error 13 – Type mismatch issue, please.
see attached file.
Thanks;
Marsil
VIP
Trusted Members
June 25, 2016
Offline
Try this
September 6, 2019
Offline
Please let me know why I got this red words in macro Although "TEXAs" is part from "Texasins".
is there any wrong from my side?
Thanks;
Marsil
VIP
Trusted Members
June 25, 2016
Offline
Hi Marsil
I think you should include as many All name scenarios as possible so that I could test it all at once.
See if this works.
Sunny
September 6, 2019
Offline
Hi Sunny,
Can you check attached result, as I added spaces in yellow space, If u can apply trim to avoid as this issue.
Thanks;
Marsil
VIP
Trusted Members
June 25, 2016
Offline
Hope this is correct.
Sunny
1 Guest(s)
