If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unsure if there's a formula/function that can do this
I would really appreciate any advice please ....
I have an Excel spreadsheet that currently has 2 columns ... Column A = suburb name in full (eg Tewantin) Column B = abbreviated version of suburb name eg Tewnt (note, this appears in the same row as the full suburb name in Col A) I now need to enter in a new Column (Column C) of abreviated suburbs (multiple and not in the same order as those that appear in Columns A & B) Question: After I have finished entering all the info in Col C, I would like to 'ask' ... if Col C matches Col B, then insert Col A (suburb name in full) into a new column (Col D). I'm sorry, I know this is a little convoluted, but I hope someone can help me please. |
Ads |
#2
|
|||
|
|||
Unsure if there's a formula/function that can do this
You should be posting to an Excel newsgroup, not an winxp ng
"Sally.m" wrote in message ... I would really appreciate any advice please .... I have an Excel spreadsheet that currently has 2 columns ... Column A = suburb name in full (eg Tewantin) Column B = abbreviated version of suburb name eg Tewnt (note, this appears in the same row as the full suburb name in Col A) I now need to enter in a new Column (Column C) of abreviated suburbs (multiple and not in the same order as those that appear in Columns A & B) Question: After I have finished entering all the info in Col C, I would like to 'ask' ... if Col C matches Col B, then insert Col A (suburb name in full) into a new column (Col D). I'm sorry, I know this is a little convoluted, but I hope someone can help me please. |
#3
|
|||
|
|||
Unsure if there's a formula/function that can do this
Sally.m wrote:
I would really appreciate any advice please .... I have an Excel spreadsheet that currently has 2 columns ... Column A = suburb name in full (eg Tewantin) Column B = abbreviated version of suburb name eg Tewnt (note, this appears in the same row as the full suburb name in Col A) I now need to enter in a new Column (Column C) of abreviated suburbs (multiple and not in the same order as those that appear in Columns A & B) Question: After I have finished entering all the info in Col C, I would like to 'ask' ... if Col C matches Col B, then insert Col A (suburb name in full) into a new column (Col D). I'm sorry, I know this is a little convoluted, but I hope someone can help me please. Sally, Try these groups msnews.microsoft.com for the information you require. Brian G |
#4
|
|||
|
|||
Unsure if there's a formula/function that can do this
Into the D1 cell, type:
=IF(B1=C1,A1,) -- Was this post helpful to you? Then click the "Yes" button, below. Voting helps others who use the web interface. Mark L. Ferguson "Sally.m" wrote: I would really appreciate any advice please .... I have an Excel spreadsheet that currently has 2 columns ... Column A = suburb name in full (eg Tewantin) Column B = abbreviated version of suburb name eg Tewnt (note, this appears in the same row as the full suburb name in Col A) I now need to enter in a new Column (Column C) of abreviated suburbs (multiple and not in the same order as those that appear in Columns A & B) Question: After I have finished entering all the info in Col C, I would like to 'ask' ... if Col C matches Col B, then insert Col A (suburb name in full) into a new column (Col D). I'm sorry, I know this is a little convoluted, but I hope someone can help me please. |
Thread Tools | |
Display Modes | |
|
|