Script Level Priority

[brijesh1991]

Hi All,

I have data like this:

ID  Flag

1   Sent

1  Sent

1  Not Sent

2  Sent

3  Not Sent

3 Sent

Now I wanted only those ID which have flag=Sent. That can do easily.

I stuck at second requirement, I have to take those ID where Flag=Not Sent, but it should not contain those ID which are in above requirement(in Flag=Sent).

I have to do this at script level. . .

Your feedback is important to me. . .

[Gysbert_Wassenaar · Accepted solution]

See attached example

[tresesco]

Gysbert, good one.

Thanks.

[brijesh1991]

Thank you so much. . .Gysbert Wassenaar