Skip to content
Advertisement

Filter out certain rows based on condition

I have this Input Table:

I want to check each project separately then exclude

  1. If the project owner has his name inside col2 and other people with him, then remove the row which is repetitive Jack Jack,

    a. For example, In Project B Jack has his name inside Col2 and he is working with Maria , so remove Jack Jack

    b. Also remove Laura Laura in Project C

  2. If Project owner only himself working inside the project then keep it, like Project A and Project E

  3. If Project owner doesn’t have his name inside col2 then exclude the project like Project D

  4. Remove duplicate like Project E

Output Table:

I tried this here but the results didn’t show me Project A and E.

Advertisement

Answer

Please try this code:

Demo

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement