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!
|