need help filter not working properly

So heres my problem... we have an excel spreadsheet set up to track training. One the first column we have company names, the second column persons names from that company. now the first column the ...