how to solve range Problem

[#1]

Hi All,

Can anyone help me on below issue?

Lets say I have data like this

Part             Critical

A                    High

B                    Medium

A                     Medium

C                     Low

A                      Low

C                      High

B                     High

D                      High

D                      High

now i should have a condition such that if all the criticals of particular part is high then it should show High , if the part is having high and medium then it should show medium , if the part has all 3 criticals then it should show Low .

So O/P should be

Part             Critical

A                   Low

B                   Medium

C                   Low

D                    High

BR

[anbu1984]

Load Part,If(Critical Like '*Low*','Low',If(Critical Like '*Medium*','Medium','High'));

Load Part,Concat(DISTINCT Critical) As Critical Group by Part;

Load * Inline [

Part,Critical

A,High

B,Medium

A,Medium

C,Low

A,Low

C,High

B,High

D,High

D,High ];

[tresesco · Accepted solution]

Straight table:

Dim: Part

Exp: =If(Index(Concat(Distinct Critical, ','), 'Low'), 'Low', If(

          Index(Concat(Distinct Critical, ','), 'Medium'), 'Medium', 'High'))

[#4]

Thanks a Lot Tresesco..Works perfect