Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    update labels (2003)

    Hi I donít know much about word. In Excel I use this formula on sheet 2 to look at sheet 1 and it will give me the updates on which names were added.
    =IF(ISNA(MATCH(A2,names,FALSE)),"keep","gone")

    Is there a way that you can do this in word? The label looks like this
    MARK MOSSER, MD
    MINOT CHIROPRACTIC CENTRE
    1825 16TH ST SW
    MINOT, ND 58701
    Two different departments are updating the info. We are paining on putting the combined one on the network but for now we have two different word documents that have over 500 addresses in each one that we need to update to the most current one.
    Iím not sure how to say this so it makes sense

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: update labels (2003)

    What is your definition of the 'most recent' address?

    If you have two independent lists of addresses and you want to merge them into one then you might be best to take it via Excel and do your weeding out there. It is better suited to this type of data anyway and you appear to have a formula you can use there already.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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