Extracting rows from the dataset based on some condition

[Ekta]

Hi Everyone, 

I am stuck at one place in my workflow, please help me with the formula for the below logic-

if Code for any student contains "QWE" and its only 1 record in the dataset then keep the record example for Student id 4

but if there are 2 codes for any student example Student ID 2 and Student ID 6 then only keep the row without "QWE"

Input data  -

Required Output is 

Please help me with this and very TIA

[Assaf_m · Accepted solution]

Check the attached solution,

let me know if it works for you.

[afv2688 · Accepted solution]

Hello @Ekta ,

I went a little bit overkill just in case there are 2 or more lines with the same student ID. 🙂

Regards