Hi,
I've been trying to tackle this for a long time; will appreciate your help.

My data (text) is in Column B (B3:B13)

G
Y
Y
R
G
G
G
G
Y
G
Y

I want to set the following conditions: If there is even 1 "R" in the array,
return "R" in the cell where I am entering the formula. Then, if there is no
"R", return "Y" if there is even a single "Y", then, if there is no "R" OR
"Y", return "G" if there is even a single "G", then, return "C" if all cells
contain "C", then, if there is no "R", "Y","G" or "C", return N

Hope I've been able to explain this clearly. Thanks in advance for your help.

--
MMM