+ Reply to Thread
Results 1 to 3 of 3

Unique Appointment date for every 2 week interval

  1. #1
    Registered User
    Join Date
    12-15-2009
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Unique Appointment date for every 2 week interval

    Updated with Code:
    Please Login or Register  to view this content.
    Found code online that I tried to incorporate with my scenario. I am new to VBA and I tried little steps, like fist seeing if I could find duplicates as seen in above code from only one spreadsheet. Now though I am stuck, and I would appreciate your help.

    Every two weeks I get a two week list of patients who are coming in to see the doctor. The MRN is unique and the along with the appointment date and time (appt dt) is the primary key. Problem is that some patients from the latter part of the last two week interval may appear in the current installment of the current two week interval. I wanted to make it so that if the patient in the current two week installment has the same MRN and appointment date and time as last week that they do not appear in the current worksheet (maybe create a third worksheet to reflect the unique information).

    For example:
    First two week interval: Nov 3-23, 2009
    Second two week interval:Nov 16-27,2009
    Third two week interval: Nov 30-Dec 11, 2009
    etc.

    Second two week interval: Nov 16-27,2009
    appt dt mrn lastname firstname Middle exname dateofbirth patient-address1 patient-address2 patient-city11/23/2009 8:30 707777 bryant john Female 3/3/1958 11 wat indianapolis in 46220 317-


    Third two week interval: Nov 30-Dec 11,2009
    appt dt mrn lastname firstname Middle exname dateofbirth patient-address1 patient-address2 patient-city patient-
    12/4/2009 8:30 707777 bryant john Female 3/3/1958 11 wat indianapolis in 46220 317-


    So now the doctor sees this patient's name twice, although he did see them last week (as shown in the Second two week interval spreadsheet).

    Thank you in advance for you patience and help with my question.

    These are my columns (and mrn is my unique identifer of each paitent.):
    appt dt mrn lastname firstname Middle exname dateofbirth patient-address1 patient-address2 patient-city patient-state patient-zipcode patientphone patientencounters-primaryprovidername

    I asked this question before on another website. Here is the cross link:
    http://www.mrexcel.com/forum/showthr...48#post2154448
    Last edited by leonli; 12-18-2009 at 04:38 PM. Reason: cross post update

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Unique Appointment date for every 2 week interval

    I see no need to edit the prior post - simply post a new reply if you need to reclarify - on this occasion I will lock your old thread given it had not gone anywhere - going forward please stick to the original.

    On a more pertinent note - don't cross post on other forums without providing appropriate links on your thread here so people can see if this has been resolved elsewhere (and thus not waste their free time).
    I suspect you x-posted only recently so I am assuming links are to be added imminently...

  3. #3
    Registered User
    Join Date
    12-15-2009
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Unique Appointment date for every 2 week interval

    Any feedback? Thanks in advance.
    Last edited by DonkeyOte; 12-18-2009 at 04:09 PM. Reason: unnec. quote removed

+ 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