Column A - list of Company name
Column B - Contact point in sales team
Each company has multiple rows of data, in 99% of cases, the salesperson is the same in each row for that unique company.
I need to know which ones have multiple sales people related to each company.
I'm trying to sum up each company into 1 row and in doing so, i need to know which ones have multiple salespeople and who they are. all on one line of data,
I feel like countif unique is in there some where, but I can't get it to work.
Any ideas?
The picture shows an example of what I need it to do.
Thanks
Column B - Contact point in sales team
Each company has multiple rows of data, in 99% of cases, the salesperson is the same in each row for that unique company.
I need to know which ones have multiple sales people related to each company.
I'm trying to sum up each company into 1 row and in doing so, i need to know which ones have multiple salespeople and who they are. all on one line of data,
I feel like countif unique is in there some where, but I can't get it to work.
Any ideas?
The picture shows an example of what I need it to do.
Thanks