Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please Help Guys!
Hi guys! I need some help with the following: I have this excel file with many lines of customer data. every line has a long description field. I need to identify if the description field contains any of the following words: computer, mouse, keyboard and if any of them appears to return 1 in another column. If let's say two or three of the words appear in the same description, I still need to see 1. If none of them appears, I want to see 0. The reason I am doing it is for me to identify only individuals that have been hurt by these. can you give me the formula that will do this? example: AFTER BENDING AND MOVING COMPUTERS, FELT KNEE PAIN SPRAIN TO RIGHT KNEE is in cell H47. The formula will be written in H48. How do I search H47 if it contains computer, mouse, keyboard and in this case since it does, to return 1 in H48 -- ivanov_nv ------------------------------------------------------------------------ ivanov_nv's Profile: http://www.excelforum.com/member.php...o&userid=16229 View this thread: http://www.excelforum.com/showthread...hreadid=276615 |
#2
|
|||
|
|||
Hi,
Try =IF(OR(ISNUMBER(SEARCH("*computers*",H47)),ISNUMBE R(SEARCH("*mouse*",H47)),ISNUMBER(SEARCH("*keyboar d*",H47))),1,0) Regards Govind. ivanov_nv wrote: Hi guys! I need some help with the following: I have this excel file with many lines of customer data. every line has a long description field. I need to identify if the description field contains any of the following words: computer, mouse, keyboard and if any of them appears to return 1 in another column. If let's say two or three of the words appear in the same description, I still need to see 1. If none of them appears, I want to see 0. The reason I am doing it is for me to identify only individuals that have been hurt by these. can you give me the formula that will do this? example: AFTER BENDING AND MOVING COMPUTERS, FELT KNEE PAIN SPRAIN TO RIGHT KNEE is in cell H47. The formula will be written in H48. How do I search H47 if it contains computer, mouse, keyboard and in this case since it does, to return 1 in H48 |
#3
|
|||
|
|||
One way:
H48: =--(SUM(COUNTIF(H47,{"*computer*","*keyboard*","*mous e*"}))0) In article , ivanov_nv wrote: Hi guys! I need some help with the following: I have this excel file with many lines of customer data. every line has a long description field. I need to identify if the description field contains any of the following words: computer, mouse, keyboard and if any of them appears to return 1 in another column. If let's say two or three of the words appear in the same description, I still need to see 1. If none of them appears, I want to see 0. The reason I am doing it is for me to identify only individuals that have been hurt by these. can you give me the formula that will do this? example: AFTER BENDING AND MOVING COMPUTERS, FELT KNEE PAIN SPRAIN TO RIGHT KNEE is in cell H47. The formula will be written in H48. How do I search H47 if it contains computer, mouse, keyboard and in this case since it does, to return 1 in H48 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|