RGB Issue help please

[#1]

Esc	Follow	Direct	Legal	Indirect	Company
					G
					Y
			C		G
			C		Y
			G		G
			G		Y
			G	Y	G
			Y		G
			Y	Y	G
		NA	G		C

I have these 6 columns with R,Y,G,C,NA.

I have to pick the least indicator meaning if one row has

G,Y,G Pick G

Y,G Pick Y

R,G Pick R

Y,Y,G Pick Y

NA,G,C Pick C

R,Y,G,C pick C

But if any row has C in it pick C.

How can I do this ?

[sunny_talwar]

May be RangeMinString() function:

RangeMinString(Direct, Legal, Indirect, Company)

[#3]

That is for the alphabetical range A,B,C right..I need the range in Red ,yellow,green,complete where Complete is max and Red is least

[Gysbert_Wassenaar]

If(match('C',Direct, Legal, Indirect, Company),

     'C',

     if(Len(Trim(Direct)),

          Direct,

          If(Len(Trim(Legal)),

               Legal,

               If(Len(Trim(Indirect)),

                    Indirect,

                    Company))))

[sunny_talwar]

May be assign numeric values to these terms using Dual function and then use RangeMin() to make it work.