Identify hierarchies where a member is missing from

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!

Member Hierarchies.xlsx

Help

Data Investigation

Accepted answers

messi007

@kaushik_c,

Please see below

Attached the workflow,

Hope this helps!

Regards

Check_20211214.yxmd

All comments

messi007

@kaushik_c,

Please see below

Attached the workflow,

Hope this helps!

Regards

Check_20211214.yxmd

Qiu

@kaushik_c
Mine is not so pretty, though😁

1214-kaushik_c.yxmd

Sebastiaandb

Hi @kaushik_c ,

Here you go:

Greetings,

Seb

Checkitnow.yxzp

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703