+ Reply to Thread
Results 1 to 2 of 2

Comparing rows of data

  1. #1
    Registered User
    Join Date

    Comparing rows of data

    I have hundreds of rows of patient data and within that data I need to look
    at each individual patients data.
    For every patient I have several rows of data, each row contains the same
    fields but they relate to different events in their hospital stay which are
    numbered 1,2,3,etc. I am trying to compare the latest event with the previous event (e.g. event 3 with event 2) and show whether their test results (which is a number) increase or decrease and if for instance it increases and is now over 30, count it as a yes and if it goes down count it as a no. The macro will need to identify the most recent event and then compare this to the previous event, this will be different for each patient record. Can you help?

  2. #2
    Forum Contributor Stuie's Avatar
    Join Date
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Hi Stewpot,

    I think i can solve this for you but i would need some test data, it doesnt have to be real data if it is confidentual but at least realistic so that i could understand how the data is stored.

    if you could provide this i could most probably put something to gether for you.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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