Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extracting records (Version 2003)

    I have a large spreadsheet ..about 575 pages. I need to extract records that have more than 1 entry. Let me explain.....it contains patient information. I am doing an audit for a year. I want to extract only the patients who have been to this doctor more than 3 times in a year. Can this be done? How?

    Thanks,
    Deborah

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Extracting records (Version 2003)

    I think it should be able to be done. How directly or indirectly would depend on the setup...

    Since yoru original is so large (and most likely contains confidential info) could you post an exampel file with your setup (and fake data) so that we can examine it and perhaps offer some suggestions.

    Steve

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Extracting records (Version 2003)

    Hello Deborah

    Assuming that your worksheet is configured with one row per record per patient visit, your requirement is satisfied with two additional columns; one to identify the number of visits each patient has required, the second to indicate whether the record is the first record for that patient or a subsequent record. It will also be necessary to have a header row to allow for data filtering. With this set-up you will be able to display the selection you are interested in, and copy/paste the results wherever needed.

    The attached file provides a small example.

    H.T.H.
    Attached Files Attached Files
    Regards
    Don

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extracting records (Version 2003)

    Thanks for your help.
    I really like the column about the visit - first, etc. This will be a big plus since all the records are not sorted by patient's name.

    Deborah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •