Shorten FILTER formula

[Brawnystaff]

I am looking to get all matching claims where a patient had a readmission 30 days before or after another admission/discharge. I have a formula, but it seems somewhat long and inefficient. Formula is as follows:

Please Login or Register  to view this content.

See attached workbook sample (formula is column I). Is there a better to either shortened it or make it more efficient? Thanks.

Patient30DayMatch.xlsx

[Fluff13]

Slightly shorter

Please Login or Register  to view this content.

[Brawnystaff]

Thanks Fluff. I tried using the plus sign earlier (OR statement), but it wasn't working. Your syntax is slightly different (and working). Thanks again..

[Fluff13]

You're welcome & thanks for the feedback.

[TMS]

Well, Fluff has worked the magic, but, just for the exercise, to shave off a few more characters:

Please Login or Register  to view this content.

One advantage of this version is there are a few less places to change the last row number (40), and the time span (30).

That takes the length from 200 => 154 => 143

[Brawnystaff]

Thank TMS, good example. I always wondered what a practical use of the LET function would be.

[TMS]

You're welcome.

[TMS]

Thanks for the rep.