Complex Search

Hello,

Not sure where to start with creating a data filter.

I have a spreadsheet with patient data, each patient having a unique number. Each patient has multiple cancer diagnoses, each one of those with a date. What I want to do is identify all patients who have a second cancer diagnosis within 6 months of their original diagnosis.

Example.JPG

Here's a screenshot of an example of my dataset. The red box represents a patient that had 2 cancer diagnoses within 6 months. These are the people I want to create an automated search for, and then export a list of their Patient IDs.

I'm sorry for noobing out on all of you, just not sure where to start. Thanks.

Hi

Most of us will not even look at an image of your requirement.

Why would we want to waste our time retyping your data? Sometimes with errors? due to formatting?

But as this is a medical issue I will look at your data.

Hello,

Thanks for your help. I think I should clarify. I'm not simply looking for a list of unique Patient ID#s. I already found that function in excel .

What I'm trying to do is more complicated.

This is a list of events. Each row represents a single event, which happens to be a cancer diagnosis. However, every patient has at least 2 events, some have more than 7.

I need a script that will evaluate each event, as a function of each patient, and return a list of patient IDs that only contains that subset of patients who had at least 2 events occurring within 6 months of each other.

Thank you again for helping out.

Thanks!!
For some reason your script won't work on my version of Excel (2003) that I use at the hospital, but it works just fine on my version of Excel (2010) I have at home.

Unfortunately I cannot help you identify the problem area.

If you could step through the macro and tell me where it fails then I can create a work around.

Try deleting this line completely.

And try running the macro again.

I recorded the sort part of the macro,

there are often redundant lines in the recorded macros.

If that does not work then record yourself doing the search

and insert that instead of my sort routine, after modifying the cell references.