I have been trying to figure out a way to take a list of hospital discharges and a list of clinic follow-up appointments, and calculate if the appointment happened within 3 days or 7 days. I abandoned my first attempts of using formulas to combine the spreadsheets. Now I am trying to group the data in a pivot table, which I hope will allow me to calculate the days between hospital admissions and follow-up visits.
I can make a pivot table, but I cannot figure out how to get the date of the visit underneath the Visit Type. Is there a way to do this?
Or is there a better way to solve this problem?
Bookmarks