A
Anthony
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!
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!