From: Anthony on 16 Apr 2010 16:41 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:D? Thanks for any help! From: T. Valko on 16 Apr 2010 16:54 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 news:FBC78CFA-4DD0-443B-9BAF-06EBEB5DCBBE(a)microsoft.com...> 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:D? > Thanks for any help!  |  Pages: 1 Prev: hide items with no data in pivot tableNext: A Guide to succeed