As I reach out to new clients, I keep track based on the following criteria: Name, Company, City.

As I track efficiencies, I keep a list of how many clients at each company I deal with. So a spreadsheet may look like the following:

Client 1|Company 1
Client 2|Company 1
Client 3|Company 2
Client 4|Company 3
Client 5|Company 1
Client 6|Company 4
Client 7|Company 2



I'd like create a separate worksheet that will look like this:

Company 1
Company 2
Company 3
Company 4

Is there a function that would allow my to copy without duplicates?

*I'd like to do this WITHOUT advanced filter