+ Reply to Thread
Results 1 to 3 of 3

Macros/Finding missing and complete addresses

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    5

    Macros/Finding missing and complete addresses

    Hi All, I have a problem and hopefully could get some help. I'm trying to analyze some data from customers where it finds how many phones were missing, zip codes, city, states etc.. However, im having trouble finding a solution to find complete addresses and tally it. I have 2 address columns and one either has a PO box or a normal address. With my code, if one address cell is empty, it will consider it as an incomplete address but we all know it is still a whole and complete address. I hope I explained my issue as clear as possible and please let me know if you have questions. Example and code in attachment. Thanks and appreciate any help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Macros/Finding missing and complete addresses

    try this macro and see sheet2

    Please Login or Register  to view this content.
    I am not an expert. better solutions may be available
    [email protected]

  3. #3
    Registered User
    Join Date
    03-09-2014
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Macros/Finding missing and complete addresses

    Hi Venkat1926, thanks for your reply and appreciate your help. I tried running your script and macro but I get an error that says Subscript is out of range. It might be my computer but I'm not sure exactly what that means.

+ 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] Vb code To Find the missing triplets and complete the number series..?
    By sem in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 05-31-2012, 02:48 PM
  2. Find and complete missing times in a huge list
    By Jessica.Bush in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-05-2011, 08:34 AM
  3. finding duplicate addresses
    By diamonds in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2006, 06:40 PM
  4. Replies: 15
    Last Post: 03-21-2006, 07:10 PM
  5. finding addresses
    By donone in forum Excel General
    Replies: 5
    Last Post: 09-17-2005, 02:45 AM

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