I have used this and others. The problem is for example, when I have words that contain portions of the one I want to identify, such as:
I only want pool and swimming pool, and not whirlpool - but the command you suggested returns all three. How do I isolate only the words pool or swimming pool?
=IF(OR(A1="POOL",A1="SWIMMING POOL",A1="POOL TABLE"),1,0)
You can put as many conditions as you want in the OR separated by commas.
Let me know if you need any further modifications.
I would be happy to help!
I have used several combinations and the results are inconsistent. Sometimes it returns "pool" but if I "pool table" is not asked for, it still returns it as a match because it found the word "pool" - the search has to be exact for exact matches of words - not similar words or portions. Any ideas?
i thought the formula I gave you would accomplish that because you can tell it which exact words you want to search for as part of the OR function.If this is still giving you trouble then please upload an example of what you are trying to do to www.wikisend.comafter uploading they give you a file ID#paste that ID# XXXXX and I can correct it for you
File ID # XXXXX
I uploaded a sample data file. Some of the rows contain the word pool, others none, others the words swimming pool. I need to be able to identify only "pool" and "swimming pool".
I am curious - the word "lower" that does not appear to make the search case-sensitive, right?
Still have a problem:
If searching for the word "spa", the formula turns shows positive when it finds either "space" or "spacious".
How can I isolate it to only "spa" in cases like this?
Same thing for the word "pool" when the word "whirlpool" shows up - need to only isolate "pool".
Other examples might be:
"offer" when "offering" shows up
"moving" when "move" shows up
How do I isolate only the piece I am looking for?
So this means I will be unable to find phrases like:
"Seller is motivated"
"seller says bring all offers"
"seller is relocating - desperate"
when you use the word LEN in the formula, do you actually include the phrase after the parentheses or do you mean count the number of words in the phrase and enter the number of words in the phrase in the parentheses?
Ok. Last question:
In the first sheet you sent, the search was for pool and swimming pool. How do I add additional keywords, such as hottub, Jacuzzi, spa, etc. I tried adding portions but error message said I had too many arguments.
okI have made a new exampleon sheet 3the best bet is for you to add a header row, with each word or phrase you are looking for in a separate column, these are poor examples but they give you the idea.http://wikisend.com/download/951046/Sample File - Pool - JA -Mod3.xlsx
PLEASE REMEMBER TO RATE MY SERVICEYOU DO SO WITH THE SMILEYS BENEATH THIS CHAT WINDOW
When I try to download the file I get some weird pdf as follows:
review of free blog sites
A Review of the Free Blog Sites in order to the
Bank posting blogs Income program
By Neil Lesfrance 06/07/2013
Rob Benwell is something like 20 2 years old and also earns the 6-figure income from his own
home. He owns the 600 thousand dollar home, and also three fancy cars, and holidays within the
Maldives with his family. He claims which this really is all created possible through the medium of
I got the file.
It does not make a whole lot of sense to me, but I will study it and see if I can figure it out.
You have been helpful and I appreciate your time.