Auto select from a list

the Max() function will allow me to capture the maximum value in a
column of data.
Is there a similar function for text? Example: I have Projects Status
file that contains varioius data about the project and a color code to
provide a "stop light" indication of status.
Project ABC consists of 4 ecp that are variously G, Y, R. At the ABC
level I want to automatically show the worst level of status - in this
R, because ecp3 is R. If ecp3 goes to G, then the rollup value would
be Y because ecp2 is Y etc.

I know that I could convert the values to 1,2,3 for G,Y,R and fix the
problem. Howeverr, I need to show the G,Y,R in the cell for printing
in B/W (and because that's the way the customer wants it).

I can also add another column, insert the numbers and do a vlookup with
Max() to fill the cell.

I was looking for a simpler approach. Is there a function I can use to
do this?

Project Status
ABC R
ecp1 G
ecp2 Y
ecp3 R
ecp4 G


Glen

I'm not sure whether or not this will help you.

This formula -
=ISNUMBER(SEARCH("YYY",A4))
will check the contents of cell A4 and return TRUE if the text includes
"YYY" and FALSE if not.

This formula -
=IF(ISNUMBER(SEARCH("YYY",A4)),1,0)
will check the contents of cell A4 and return 1 if the text includes "YYY"
and 0 if not.

Regards.

Bill Ridgeway
Computer Solutions

<glen.e.mettler@lmco.com> wrote in message
news:1142373600.113557.187470@e56g2000cwe.googlegroups.com...
> the Max() function will allow me to capture the maximum value in a
> column of data.
> Is there a similar function for text? Example: I have Projects Status
> file that contains varioius data about the project and a color code to
> provide a "stop light" indication of status.
> Project ABC consists of 4 ecp that are variously G, Y, R. At the ABC
> level I want to automatically show the worst level of status - in this
> R, because ecp3 is R. If ecp3 goes to G, then the rollup value would
> be Y because ecp2 is Y etc.
>
> I know that I could convert the values to 1,2,3 for G,Y,R and fix the
> problem. Howeverr, I need to show the G,Y,R in the cell for printing
> in B/W (and because that's the way the customer wants it).
>
> I can also add another column, insert the numbers and do a vlookup with
> Max() to fill the cell.
>
> I was looking for a simpler approach. Is there a function I can use to
> do this?
>
> Project Status
> ABC R
> ecp1 G
> ecp2 Y
> ecp3 R
> ecp4 G
>
>
> Glen
>