I have two data sets, one has entries like this:
Item start date end date
EG 1/10/08 3/10/08
and the other data looks like this:
Item Date
EG 1/10/08
EG 2/10/08
EG 3/10/08
Is there a simple way to check if the dates in one data set are
represented in the other? The lists are big and I was hoping for a
simple formula that checks each entry to see if it is in the above
range.
-k-
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
