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
|
|||
|
|||
If B2=x, then for all values of A2, place y in C3
Is this a macro that I have to run, or can I perform this as an
equation/function? I'm thinking I can do it with an array, but can't quite put it together. I'll give an example: A B C 1 1 Alex Oldest 2 2 Barbara Middle 3 3 Chloe Youngest 4 1 Oldest 5 3 Youngest 6 2 Middle In word form I want to say: If $B$1="Alex", then If A:A=1,C:C="Oldest" Even though B4 is blank, the formula knows to put "Oldest" in C4 because A4=1. Would I need to turn C:C into a helper column and put the answers in D? Thanks for any help! |
#2
|
|||
|
|||
If B2=x, then for all values of A2, place y in C3
If you have only those 3 variables:
1 = oldest 2 = middle 3 = youngest Try this... =CHOOSE(A1,"Oldest","Middle","Youngest") -- Biff Microsoft Excel MVP "Anthony" wrote in message ... Is this a macro that I have to run, or can I perform this as an equation/function? I'm thinking I can do it with an array, but can't quite put it together. I'll give an example: A B C 1 1 Alex Oldest 2 2 Barbara Middle 3 3 Chloe Youngest 4 1 Oldest 5 3 Youngest 6 2 Middle In word form I want to say: If $B$1="Alex", then If A:A=1,C:C="Oldest" Even though B4 is blank, the formula knows to put "Oldest" in C4 because A4=1. Would I need to turn C:C into a helper column and put the answers in D? Thanks for any help! |
Thread Tools | |
Display Modes | |
|
|