I have a large file of customers and resellers and need unique count of company name for the resellers.
SAR Inc McDonalds
SAR Inc Burger King
SAR Inc Wendy's
SAR Inc Pizza Hut
PAUL DOT Macy's
PAUL DOT McDonalds
PAUL DOT Wendy's
How do I show that SAR truly has 2 unique companies and PAUL DOT has 1 Unique company.
I gave a simple example but I have 3K resellers tied to numerous companies.
Any quick help will be appreciated!!!