advanced lookup

Hi All,

I'll be needing your help again.

I need to lookup all of the Analysts under the same Job ID, but (should ignore duplicates)

Attaching a sample file with the desired output.


Thanks in advance!

Hi Imran,

Thanks for the suggestion, but what I need is a fully formulated one, since the original data that I will be working on is a minimum of 10k rows each.

Also, I can't afford to insert a manual method since its a daily task

Hi Imran,

Yes, the output in J1 is my desired output.