This uses Advanced Filter.
Give each column a unique label, like this:

BinA BinB BinC
3945122 Jim Evans Group A
3815201 Ian Duffy Group B1
3815201 Lester Amp Group B1
3815201 Jay McMurray Group B1
.......

3945122 would be at location A2.
Enter these 3 cells somewhere, maybe at AA3:AA5

Test
=COUNTIF($A$2:A2,A2)=1
=COUNTIF($A$2:A2,A2)=2

Under Test, it will say either TRUE or FALSE. That's OK.

Filter Advanced Filter Copy to another location (maybe AH1)
List Range $A$1:$C$14
Criteria Range $AA$3:$AA$5
Copy To $AH$1:$AJ$1