#1   Report Post  
Posted to microsoft.public.excel.misc
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..
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicate table just values not formulas in the table Rob Charts and Charting in Excel 1 February 18th 07 12:18 PM
Extracting values from a table Rob Cherry Excel Discussion (Misc queries) 2 April 2nd 06 11:21 PM
Populating a table based on values in another table Bri Excel Worksheet Functions 0 January 26th 06 01:23 AM
Values in a Table bob Excel Worksheet Functions 2 October 25th 05 04:13 AM
Looking up values in a table LesLdh Excel Worksheet Functions 17 August 3rd 05 06:55 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"