+ Reply to Thread
Results 1 to 2 of 2

Matching journey records to expiry dates

  1. #1
    Registered User
    Join Date
    03-04-2011
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Matching journey records to expiry dates

    HI,

    I have a list of journeys made by a person and need to know if they had a valid pass in the same month. I have one sheet which shows the journeys in the following format;

    Column A: Year
    Column B: Month
    Column H: PersonID

    In a separate sheet I have a list of Pass Expiry dates and person details like so;

    Column I: PersonID
    Column J: Pass expiry date

    All passes are active for 1 year so the start date could be calculated from the expiry date if required.

    The problem I'm having is how to determine if a the person making a journey in a given year/month combination also had a valid pass. If there was only one pass expiry date by person I could use a vlookup and check if the date was within a given range. However, an individual will have a number of passes (renewals). For the purposes of determining if they had a valid pass, I'm taking it as if the pass was valid for any day in the month then it was valid for the whole month as my journey details are aggregated to month.

    Any help is greatly appreciated.

    Thanks
    Alex

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Matching journey records to expiry dates

    You don't say what kind of feedback you want. But, for instance, in a neighboring cell on sheet1 for a "Valid/NotValid" response.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

+ 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. VBA - Matching Computername + expiry
    By itselflearn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2014, 12:41 PM
  2. Pulling records matching two criteria and inserting those records into an existing list
    By desertfx41 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2014, 02:00 PM
  3. Workday Formula-Notice dates and Expiry dates
    By lamjoey in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-24-2011, 06:52 AM
  4. Calculating Expiry Dates
    By shinyell in forum Excel General
    Replies: 3
    Last Post: 10-19-2009, 03:38 AM
  5. Flag expiry dates
    By Viper200 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2008, 08:14 AM

Tags for this Thread

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