Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
Hello,
I have a column with names. In 3 columns to follow, I have these names distributed for the 3 columns: Bad, Mediums and Good. I intend that in one another column appears I - if the name is in the column Bad, C - if the the name is in column Mediums and S - if the name is in the column Good. Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
=IF(B2<"","I",IF(C2<"","C",IF(D2<"","S","")))
-- __________________________________ HTH Bob "Alexandra Lopes" wrote in message ... Hello, I have a column with names. In 3 columns to follow, I have these names distributed for the 3 columns: Bad, Mediums and Good. I intend that in one another column appears I - if the name is in the column Bad, C - if the the name is in column Mediums and S - if the name is in the column Good. Thanks in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
Bob Phillips wrote:
=IF(B2<"","I",IF(C2<"","C",IF(D2<"","S",""))) No. What I want is the following one: I have the data of the columns A, B, C and D and want that through a function to get the data of the column E, having in account the conditions that I related previously: I - if the name is in the column B, C - if the the name is in column C and S - if the nameis in the column D. Example: A B C D E Name Bad Medium Good Groupe Ana Ana S Maria Maria S João João S Pedro Pedro C António António C Marco Marco C Filipa Filipa C Nuno Nuno I Mario Mario I Vasco vasco I |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
I'm sorry, the datas are not formated. I'm sending an example xls. Thanks in advance Alexandra Lopes wrote: Bob Phillips wrote: =IF(B2<"","I",IF(C2<"","C",IF(D2<"","S",""))) No. What I want is the following one: I have the data of the columns A, B, C and D and want that through a function to get the data of the column E, having in account the conditions that I related previously: I - if the name is in the column B, C - if the the name is in column C and S - if the nameis in the column D. Example: A B C D E Name Bad Medium Good Groupe Ana Ana S Maria Maria S João João S Pedro Pedro C António António C Marco Marco C Filipa Filipa C Nuno Nuno I Mario Mario I Vasco vasco I |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
I am not going to open an attachment, but from your follow-up post, I think
my previous formula is exactly what you want. -- __________________________________ HTH Bob "Alexandra Lopes" wrote in message ... I'm sorry, the datas are not formated. I'm sending an example xls. Thanks in advance Alexandra Lopes wrote: Bob Phillips wrote: =IF(B2<"","I",IF(C2<"","C",IF(D2<"","S",""))) No. What I want is the following one: I have the data of the columns A, B, C and D and want that through a function to get the data of the column E, having in account the conditions that I related previously: I - if the name is in the column B, C - if the the name is in column C and S - if the nameis in the column D. Example: A B C D E Name Bad Medium Good Groupe Ana Ana S Maria Maria S João João S Pedro Pedro C António António C Marco Marco C Filipa Filipa C Nuno Nuno I Mario Mario I Vasco vasco I |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
Bob Phillips wrote:
I am not going to open an attachment, but from your follow-up post, I think my previous formula is exactly what you want. Hi again! To solve my problem i'm using this formula: =IF(B9=VLOOKUP(B9;$AE$9:$AE$40;1;0);"S";IF(B9=VLOO KUP(B9;$AC$9:$AC$40;1;0);"I";IF(B9=VLOOKUP(B9;$AD$ 9:$AD$40;1;0);"C";0))) But i have a new problem, that is: when i have a result N/A in one of the cells, the result it's N/A, and not the real result that i expect. Can you help me please? Thanks Alexandra |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
This is simpler
=IF(B2<"";"I",IF(C2<"";"C",IF(D2<"";"S";""))) or even =CHOOSE(MATCH(A2;B2:D2;0);"I";"C";"S") -- __________________________________ HTH Bob "Alexandra Lopes" wrote in message ... Bob Phillips wrote: I am not going to open an attachment, but from your follow-up post, I think my previous formula is exactly what you want. Hi again! To solve my problem i'm using this formula: =IF(B9=VLOOKUP(B9;$AE$9:$AE$40;1;0);"S";IF(B9=VLOO KUP(B9;$AC$9:$AC$40;1;0);"I";IF(B9=VLOOKUP(B9;$AD$ 9:$AD$40;1;0);"C";0))) But i have a new problem, that is: when i have a result N/A in one of the cells, the result it's N/A, and not the real result that i expect. Can you help me please? Thanks Alexandra |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
Bob Phillips wrote:
This is simpler =IF(B2<"";"I",IF(C2<"";"C",IF(D2<"";"S";""))) or even =CHOOSE(MATCH(A2;B2:D2;0);"I";"C";"S") This results! Thank you very much! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns_if
It was my use of commas that was the problem, your Excel requires
semi-colons as separators. -- __________________________________ HTH Bob "Alexandra Lopes" wrote in message ... Bob Phillips wrote: This is simpler =IF(B2<"";"I",IF(C2<"";"C",IF(D2<"";"S";""))) or even =CHOOSE(MATCH(A2;B2:D2;0);"I";"C";"S") This results! Thank you very much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|