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!
Bookmarks