Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Make A Customer List With Extra Entries Per Customer
Greetings,
I have a customer list of which 70% have only one entry per customer. The problem is the oddballs: Customers who change their names (get married) Customers who change their address Customers with more then one service address (Real estate agents) Customers who have more then one phone number or change their phone numbers And customer who nave many of these exceptions I would like to have one record per customer. What I have is a separate record for any changes that occur. Is there anyway to redesign this customer list to limit it to one record per customer? Any suggestions would be most appreciated TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
customer Name against Unique customer number count | Excel Worksheet Functions | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
How to make customer database with search engine by addy or name | Excel Discussion (Misc queries) | |||
Can I make a customer list that converts to labels? | Excel Discussion (Misc queries) | |||
How can I find and mark double entries in a customer database? | Excel Worksheet Functions |