+ Reply to Thread
Results 1 to 2 of 2

Using Formula to Search List of 1st Visit and Evaluate Outcome to Specified Criteria

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    1

    Using Formula to Search List of 1st Visit and Evaluate Outcome to Specified Criteria

    Hello:

    I am looking to use Excel to search a list of identification numbers (people) with multiple visits to return the date of 1st visit with qualifying criteria (e.g. an exam visit versus some other visit).
    Once complete, I would like to evaluate the result to find the duration (in days) until the next qualifying event (e.g. the next exam).
    This may entail a vlookup to a list of codes to employ in the formula.
    Please see attached sample with masked data.

    Thank you for your help!
    Chris
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-02-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Using Formula to Search List of 1st Visit and Evaluate Outcome to Specified Criteria

    Hi Chris,

    I am assuming that
    • you use Excel 365
    • by second visit, you are referring to one of the listed dates instead of a predicted date

    For patient 1000002, there is no 2nd visit, and hence an error.

    For "Note that this will probably include a vlookup to the cpt definition of clinic and infusion.", do you meant to call a patient "New patient" whenever there is the word "New" in CPT Description, then if there is not, check duration is less than 365 days?

+ 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. [SOLVED] Formula to evaluate a matrix and return a supplier list
    By The_Snook in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2018, 12:10 PM
  2. [SOLVED] Formula to evaluate criteria across two matrices
    By The_Snook in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-03-2018, 04:47 AM
  3. [SOLVED] Formula to evaluate criteria across two matrices
    By The_Snook in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-28-2018, 03:56 AM
  4. [SOLVED] Drop Down List Multiple Outcome Formula
    By RachelMads02 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 05-06-2017, 06:57 PM
  5. Replies: 7
    Last Post: 07-06-2015, 07:56 AM
  6. Search Multiple Worksheets Against List of Non-Exact Search Criteria?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 03:46 PM
  7. Make Search formula evaluate to blank
    By XP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2006, 06:15 PM

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