View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jjr1975 jjr1975 is offline
external usenet poster
 
Posts: 2
Default how do I remove repetitive cells in an excel database?

Have a customer database with everyone's name, address, etc. Most of the time
each family member is a client and therefore they have their own line item. I
have direct mailers that I wish to send out to all my customers homes, but I
only want to send one per household. How can I remove the extra rows in the
spreadsheet so I only have one line item per address?? Your help is
apprechiated.