I have no idea to create a formula. Here is my situation..
I need to search specific word in a sentence. If it is found, the result will appear as Track.
Example:
If Cell A1 contains specific word such as Kit, keyboard or mouse..the result should be Track in cell B1.
In cell A1, it contains a text such as "Laptop without mouse"
Currently, i'm tracing manually using my eyes..and i have more than 300 records daily...
I hope someone can help me to speed up my task..
Do you have source of those words?
Can you upload spreadsheet?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Here is the file. Please help me..
How do you know for wich word to search for?
Do you have only 4 words?
What if we had
"HP 2400W Gold Ht Plg Pwr Monitor"
If i see the text contains below words, i know that i need to "track" the item and the result is "track". if we had "HP 2400W Gold Ht Plg Pwr Monitor", the result should be "Not track"
List
Kit
SSD
Keyboard
Cable
Mouse
Vmaware
hi mikail, welcome to the forum. you can put the list somewhere say in E1:E7, then in B1:
=IF(SUMPRODUCT(COUNTIF(A1,"*"&$E$1:$E$7&"*")),"Track","Not Track")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks, Guys. You are awesome!!!
Unless the you will not get "mauset" in your data or any slighlty different name(like scable) the formula will work.
Otherwise will return "Track".
Unless your word is always the last word in sentence(this could be done by formula" I would suggest to look here:
http://www.excelfox.com/forum/f22/fi...ther-word-603/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks