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.