Extracting rows from the dataset based on some condition

Question

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 Answer

Check the attached solution,

let me know if it works for you.

afv2688 · Accepted Answer

Hello @Ekta ,

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

Regards