Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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:D? Thanks for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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:D? Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting table of numbers with different place values | Excel Worksheet Functions | |||
Compare values and place corresponding value in another sheet | Excel Discussion (Misc queries) | |||
Zero displayed in place of negative values | Excel Discussion (Misc queries) | |||
Auto sum returns a 0 value in place of sum of values in column. | Excel Discussion (Misc queries) | |||
Look up values and place in spreadsheet | Excel Discussion (Misc queries) |