Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search and Replace
Greetings. Is this possible in Excel 2007 (beta)? I have four columns: A,
B, C, and D (which is blank). If the word in a particular row in A is "hat," the word in the same row in B is "bug," and the word in the same row in C is "flower," I want to place the word "tree" in the same row in blank column in D. I want this to happen to all the rows with this particular combition (hat, bug, and flower). Of course, I will go through the spreadsheet row by row to fill in all the words. This is a translation exercise, with A (the Hebrew word), B (the parsing), and C (the dictionary form of the word in A) words in one langauge (Hebrew), and D will be the translation of the words (in English). I hope this will not involve complicated programing or macro building, because I am a new user. If this is possible, and if so could you please explain to me how to do this, and in simple English, step-by-step? Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search and Replace
Oh, and to reply to my own post, if you think it strange to be doing
something this in Excel, there is a reason I'm using it instead of, say, Access or the like. I realize Excel is mostly used for calculating and the like, but after each word is translated into English, there will be some calculations done here and there. "Rebecca" wrote: Greetings. Is this possible in Excel 2007 (beta)? I have four columns: A, B, C, and D (which is blank). If the word in a particular row in A is "hat," the word in the same row in B is "bug," and the word in the same row in C is "flower," I want to place the word "tree" in the same row in blank column in D. I want this to happen to all the rows with this particular combition (hat, bug, and flower). Of course, I will go through the spreadsheet row by row to fill in all the words. This is a translation exercise, with A (the Hebrew word), B (the parsing), and C (the dictionary form of the word in A) words in one langauge (Hebrew), and D will be the translation of the words (in English). I hope this will not involve complicated programing or macro building, because I am a new user. If this is possible, and if so could you please explain to me how to do this, and in simple English, step-by-step? Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search and Replace
In D2 (or whatever row your data starts) put
=IF(AND(A2="hat",B2="bug",C2="flower"),"tree","") copy down, if you want some more flexibility you can use =IF(AND(A2=$F$1,B2=$G$1,C2=$H$1),"tree","") where you would put the 3 words in F1, G1 and H1 respectively -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Rebecca" wrote in message ... Oh, and to reply to my own post, if you think it strange to be doing something this in Excel, there is a reason I'm using it instead of, say, Access or the like. I realize Excel is mostly used for calculating and the like, but after each word is translated into English, there will be some calculations done here and there. "Rebecca" wrote: Greetings. Is this possible in Excel 2007 (beta)? I have four columns: A, B, C, and D (which is blank). If the word in a particular row in A is "hat," the word in the same row in B is "bug," and the word in the same row in C is "flower," I want to place the word "tree" in the same row in blank column in D. I want this to happen to all the rows with this particular combition (hat, bug, and flower). Of course, I will go through the spreadsheet row by row to fill in all the words. This is a translation exercise, with A (the Hebrew word), B (the parsing), and C (the dictionary form of the word in A) words in one langauge (Hebrew), and D will be the translation of the words (in English). I hope this will not involve complicated programing or macro building, because I am a new user. If this is possible, and if so could you please explain to me how to do this, and in simple English, step-by-step? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and replace chunks of html code | Excel Discussion (Misc queries) | |||
Unicode and Search and Replace | New Users to Excel | |||
Search and replace | Excel Worksheet Functions | |||
Search and Replace | Excel Discussion (Misc queries) | |||
GLOBAL search and replace | New Users to Excel |