Each ID to fall in one of 4 buckets

[D19PAL]

Hi,

I want each ID to fall in one bucket

ID,GROUP,CODE

1,BMW,YES

1,BMW,YES

1,VW,YES

2,FORD,YES 

2,BMW,YES

2,VW,YES

3,BMW,NO

3,VW,

4,FORD,YES 

4,BMW 

4,VW,YES 

Group 1

If group = single BMW and code = null = ID4

Group 2

Single BMW and no = ID3

Group 3

VW and more than 1 BMW and yes = ID1

Group 4

VW and single bmw and yes = ID4

I know its a lot to ask, I just cant get it to work and some one might enjoy a challenge.

Thanks 

[abhijitnalekar]

Hi @D19PAL ,

can you please elaborate on what exactly constitutes an error, best with some more examples with grouping. 

[D19PAL]

It's harder to explain to do.

Will the if statements work as four separate or will it have to be a nested if statement?

I've tried separate, first two work, I'm hoping the IDs that dont fit in the first two can stay there, I only want to count thr condition is true.

I was hoping the ones that don't fit in the first two will fill options 3 and 4 but I'm not getting anything

 They are separate if statements, dont they do row by row?

[abhijitnalekar]

Can you share your expression