Identify hierarchies where a member is missing from

[kaushik_c]

Hi All,

I have two columns in Excel file. Column A contains 4 hierarchies, column B contains the members in those hierarchies. I need to ensure that a member must be present in all 4 hierarchies, and flag the hierarchies where the member is missing from.

Please see attachment for Sample input and intended output.

Thank you in advance for your help!

[messi007 · Accepted solution]

@kaushik_c,

Please see below 

Attached the workflow,

Hope this helps!

Regards

[Qiu]

@kaushik_c 
Mine is not so pretty, though😁

[Sebastiaandb]

Hi @kaushik_c ,

Here you go:

Greetings,

Seb 

[Sebastiaandb]

haha @Qiu @messi007  what an overwhelming response! high five to you guys!

[Qiu]

@Sebastiaandb 
Thanks for the kind word.
and yours is also an excellent one! 

[kaushik_c]

Thank you everyone for your quick support and help. Really appreciate it. All the solutions were equally helpful.

[kaushik_c]

Thank you!