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
Bookmarks