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!
Solved! Go to Solution.
@kaushik_c
Mine is not so pretty, though😁
@Sebastiaandb
Thanks for the kind word.
and yours is also an excellent one!
Thank you everyone for your quick support and help. Really appreciate it. All the solutions were equally helpful.
Thank you!