I have to fulfill three conditions from the three coloumns below
1st Pick 1's from Column A
2nd Pick A Company from Column B and
3rd Pick all starting from 46

Column A Column B Column C
0 A Company 46401000CC
1 B Company 46406500DC
0 C Company 54010000PO
1 A Company 46046544EJ
0 A Company 46330578LT
1 A Company 46301456DD

Any help getting the formula with that would be greatly appreciated.

Thanks in advance.
KD