Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP HELP
I think it may help if I showed the formula I have been trying to use. Need
Help. I need a formula that would allow me to enter a the names of multiple countries into a column and have it automatically placed into another column by continent. For example: If: Then: A1 is United States B1 should be North America A2 is Mexico B2 should be North America A3 is France B3 should be Europe A4 is Germany B4 should be Europe A5 is Japan B5 should be Asia So, if A1:A5 is United States, then B1:B5 should automatically be North America. Here is the formula I have been trying to work with =SUBSTITUTE(D103:D164,"Germany,Spain,France","Euro pe") Can someone help. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP HELP
Why don't you tell us what is wrong with the answers you got in your other
post instead of starting a new thread "ISAF Media Analysis" wrote: I think it may help if I showed the formula I have been trying to use. Need Help. I need a formula that would allow me to enter a the names of multiple countries into a column and have it automatically placed into another column by continent. For example: If: Then: A1 is United States B1 should be North America A2 is Mexico B2 should be North America A3 is France B3 should be Europe A4 is Germany B4 should be Europe A5 is Japan B5 should be Asia So, if A1:A5 is United States, then B1:B5 should automatically be North America. Here is the formula I have been trying to work with =SUBSTITUTE(D103:D164,"Germany,Spain,France","Euro pe") Can someone help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|