Hi,
Hope you can help.
I work as an analyst in a hospital.
I have 3 columns in my report that are important to my work:
Column 1 - Patient number Column 2 - Admission date Column 3 - Discharge date
I can pull off a separate report from the system which has details of discharged patients:
Column 1 - Discharge date Column 2 - Hospital number
I need a formula to quickly fill Column 3 with discharge dates for patients who have discharged and have it not affect any other cells.
Bookmarks