Thread: values in table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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..