I'm doing a long-term research study where I see patients for multiple visits and at two of those visits I collect lab samples (denoted by an * following the visit date). I want to track the dates of the study visits where samples were collected on a separate sheet. Samples are collected based on a date range that is unique to each patient and not at a specific visit so they can occur in any column on the row for each patient.
Here is an example (absolutely entirely deidentified using only example visit dates)- My current log on Sheet 1 and what I want on Sheet 2:
Enrollment Example.xlsx
Please please please help!! I'm pulling my hair out trying to figure this out!
Bookmarks