Lookup unique identifier to see if dates fall within a range

Hi there,

I have 200,000 unique identifiers (for patients) and I'm trying to do 2 things:

1. I want to know if they came back to hospital within 28days (by using the previous discharge date and current admission date)
2. If they did come back to hospital, I want to know their previous separation mode.

I've attached workbook which has further details of what I'm trying to achieve but have no idea where to start with the formulas!.

Thanks in advance for your help!


-A

Thanks bebo, it works! But the formulas are dependent on the Patient Identifier and Discharge Dates being sorted, right? What if I need to add more current data to the dataset? I'd need to sort it each time? Is there another way of doing the formula without having to sort the data?

Hi bebo,

Thanks again for your message - I did try to "jumble' the data around but it doesn't work unless it's sorted and my computer crashed trying to apply the formula to over 200,000 episodes despite having 16GB RAM!!!


Best,
A