I am trying to extract a unique list of customers for each on of my locations so using advanced filter will not work (or so I think) Attached is a very brief example of what im trying to do .

thanks

example.xlsx