I am trying to delete one patient at a time.

If you change the estimated discharge date (column D) to anything before today (i.e. 6/14) column AJ values change to 0.

Filtering by clicking on "Show past pts" shows only patients whose discharge date is before today. I was hoping to use the same filter to be able to delete visible cells after filtering AJ for "0", but it always seems to delete the top row (row 3), in addition to deleting discharged patients.