Countifs Unique Values

[Marc_w90]

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

 

[Woody Pecker]

Can you show the exact formula you are using?

 

[Fluff]

How about for E3

=UNIQUE(FILTER(A2:A100,A2:A100<>""))

then in F3 dragged down

=TEXTJOIN(", ",,UNIQUE(FILTER($B$2:$B$100,$A$2:$A$100=E3)))