values in table
 

I have a list:

client #s Fname Lname


The client #s are replicated at times (that's okay). But in the list some
client numbers are skipped

001
002
004

and sometimes the Fname+Lname is different for the same client #

001 frank jones
001 sally jones

I'm want to find a way to have replicated client #s match the same names and
to find missing client #s.

Any help appreciated..