How to get an excerpt of a table in Excel in a different table?

Question

I have got an Excel document that is used as patient database for a practice. In the first table there is a complete list of all patients with the date of their first appointment and (if applicable) the date of their final appointment.

In the second table, I would like to have a list of all current patients (no final appointment). In the third table, I would like to have a list of all patients that are done (have a final appointment). Final appointments are only entered after the patient has shown up, so there is no need for a date check.

Is there a way to extract these sub-tables from the main table?

Answer 1

What about filter by first appointment or final appointment?...if you dont care with only one table...