Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
May be RangeMinString() function:
RangeMinString(Direct, Legal, Indirect, Company)
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
If(match('C',Direct, Legal, Indirect, Company),
'C',
if(Len(Trim(Direct)),
Direct,
If(Len(Trim(Legal)),
Legal,
If(Len(Trim(Indirect)),
Indirect,
Company))))
May be assign numeric values to these terms using Dual function and then use RangeMin() to make it work.