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