+ Reply to Thread
Results 1 to 2 of 2

Date matching program

  1. #1
    Registered User
    Join Date
    08-07-2007
    Posts
    1

    Date matching program

    I'm trying to make a date matching program to form a list of only the matching dates from two columns of dates. So far I've only been able to do it with functions, however, the function becomes huge and wastes space/time. Any ideas for another way?

    I.E. In Workbook "Business Days" Column A is business days in the US, Column B is business days in Japan. I have another Workbook to do the analysis of values "Common Business Days" where I would like to be a list of the common business days between the two.

    The current model is running an excessive amount of vlookups to find corresponding days, but if there isn't a matching day in one of the countries it has to check the next set, and so on. If one cell ends up using 4 days ahead, the cell below it now needs to be checking even farther ahead, so as missing days add up over the years the formula will eventually not be able to look far enough ahead. What I need is something that works in a more general manner rather than checking specific cells so that the missing days won't compound and make the formula blow up.

    All help is greatly appreciated!

  2. #2
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302

    A Rearrange, Fill-down, Filter, Copy solution

    Maybe this will work for you.
    Rearrange the data into a single column of dates B and mark the country
    that the date belongs to in the next column C. Sort into order by Date.
    Add the fill-down formulas to compare the dates, and use a Filter to show/select
    the US date from each matching pair.
    The attached workbook implements this.

    This can be the basis for automating the procedure, if need be.

    Please Login or Register  to view this content.
    FrankBoston is the pen name for Andrew Garland, Lexington MA
    Attached Files Attached Files
    Last edited by FrankBoston; 08-07-2007 at 04:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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