Auto select from a list

[glen.e.mettler]

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

 

[Bill Ridgeway]

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