Good Evening Guys,

I want to list in Column "G" all the unique salesperson's names which are existing in column "B" but it should work according to the store code location @ "E1".

so basically whenever the value in "E1" changed according to the given values in column "A" the formula should list the unique name of that location only without being repeated.

I have attached the workbook for more reference as well as a screenshot shot for additional clarification.

thank you so much in advance.

Book1.xlsx