+ Reply to Thread
Results 1 to 5 of 5

Consolidate Rows with the same address in client list

Hybrid View

  1. #1
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Consolidate Rows with the same address in client list

    How do you know that John Smith and Mary Smith are the same household instead of being two unrelated people who happen to share the last name? What if Mary kept her maiden name so they are the same household but their names are John Smith and Mary Jones?

    If I was you I would concatenate every name that goes to the same mailing address so it looks something like "John Smith & Mary Smith," grab that list and move it to a separate list, and then remove duplicates, and feed that into mailmerge.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  2. #2
    Registered User
    Join Date
    12-11-2015
    Location
    Belmont, MA, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    1

    Re: Consolidate Rows with the same address in client list

    @ Ben_Hensel,

    This is a very smart suggestion, and one I'd love to know how to do. Are you able to share here? Do I need to start a new thread with this question?

    Thanks for your insight.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Moving variable data from multiple same-client records to one client record
    By jkilday4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-19-2015, 02:32 PM
  2. consolidate address list
    By johnweir in forum Excel General
    Replies: 8
    Last Post: 02-21-2015, 08:51 AM
  3. [SOLVED] Consolidate rows into new list
    By x65140 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2014, 07:13 AM
  4. Consolidate client data from monthwise to new sheet
    By cpramesh in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-11-2014, 07:41 AM
  5. One spreadsheet but adding hours on a client by client basis..
    By arthurArthur in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 01:58 AM
  6. Replies: 16
    Last Post: 06-20-2012, 10:19 AM
  7. Hide Rows based on Client Drop Down List
    By troyhalsey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2012, 07:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1