Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
is it always going to be in the same order
for example is the color always going to be 2nd
No it wont be in the same order.
I can get it to find and return a single word but I cant make it return one of many words.
My excel formulas are usually many columns wide
I need something that does. Find blue, return blue, if not blue find red, return red, if not red, find black, etc
it may be possible to do with a macro
if you create a list of words in another sheet
then it may be possible to iterate through that list to see if the value is within the big sentance
but I don't know of any formula that will do this
Ill show you what I have so far
do you mind using vba macro?
the find function will find a single word
next column =C1+8
however it wont iterate through an entire list of words
you could use nested ifs
but if you had more than 5 possible words
that would get kinda crazy
I tried that but I got #value
are you saying you would have way more than 5 possible words?
to search for
maybe 10 at most for some columns
so after I did it for "automatic"
I do it for "manual wind" and then "quartz"
its possible to do something like
And if the word is in the sentence it shows up at "automatic" but the rest are just #value....what I wanted to do wast assign each possible outcome a number value if and if the other ones are not in the sentence those results would end be 0. then I would add all the columns together
So 1 is Automatic 2 is Manual Wind and three is Quartz
can you send your actual sheet to me
i think it may be possible as long as you don't have too many words to search from
can be done without macro in that case
I would need the actual xls file
Ill send the basic idea
also which version of office are you using? 2007 or later?
your version of office
is not 2003? or earilier
well you said your formulas are long
beacuse earlier versions crap out at 7 levels of formula depth
I think i have a newer version, I bought my computer 2 years ago
if you goto that site
you can upload the file there
then provide me the download link they give you
http://wikisend.com/download/933112/TESTING CHRONO24 COMPATABILTIY.xlsx
Ok now you have to go to the sheet that say "MOVT" thats where im trying to figure out the formula
On the first sheet, I was filling out the orange part one at a time and it take forever when I have 300 items. I need to be able to just put the decriptions in and drag down the formula for things like Movement and case material
Once I now how to make the formula I can tweak it
so are you looking to know where the word starts
or do you just want to know if the word exists in the sentance or not?
The second one would probably be more helpful. but then I need it to do it for each word for each row, but only one possible phrase or word from the possibilities would be in each row.
so on the sheet 1
this is where you want this formula?
no I will copy it myself, I just need it to create the list in the proper order
I dont want to mess with that orange page at all
so where is the list of words you want to lookup from
or do we need to create one?
in other words
all of the possible values
Automatic, Manual Wind, Quartz. is fine for now, I can expand the formula and put in all the possible info later I just need the thing to work
give me a few minutes to work out a formula with those 3 values for now
and the result will go in the F column
of MOVT sheet?
oh let me look
put the result in f column , but look for the word in the a column?
The F column is acutally just a test, it finds each word I need because I made the first row Automatic, second manual, and third quartz, then I moved the 4 cells that make the answer to the 1 row. so it acutally does it three times but as you can see it returns #value if the word is not in the sentance. I was trying to make it so I could asign a number value to each word and zero if it did not show up. the just add the three numbers and change it back to the word
it could go in any column just has to work
I may have made it more complicated
doesn't need to be complicated
i just need to know where you want the result
i will have the result be the word itself
its easier that way
Yes that would work. One column with the correct answer that I can copy to the orange page after i put my full list in
yes, you could just rework the formula
How long do you think you need do I have time to run outside for a 2 minutes?
ill need about 10 - 15 mins
still working looooollolol
yeah man, its tough
thats why you seek an expert
i am done
hopefully you will be able to make sense of the formula
http://wikisend.com/download/570122/TESTING CHRONO24 COMPATABILTIY-ja-mod.xlsx
PLEASE REMEMBER TO RATE SO I GET COMPENSATED FOR MY TIME
im trying to open it but im getting an error for some reason
excel cannot open because not enough available resources
odd sometimes wikisend corrupts files
let me try a different site
ive been having this problem today, my brother put some excel in the dropbox and it did the same thing
your original opened just fine
I opened it, it seems to work, im going to test it now
Works great thank you