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!

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!

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

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

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

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

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

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!

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!