Array to Sort Table in another sheet

Hi there,

You all have been very helpful in the past for me, I'm hoping you can help me again. :-)

I have been trying in futility to create an array formula that will extract data from a table based on criteria, place the data into a new sheet (with no blank rows) and then sort the data by one column.

I have attached a "dummy" excel worksheet that shows the source data, and then what I want it to look like if it was functioning.

The "Source Data" table has items as "open" or "closed." For my purposes, I want to include only the "open" items in the new sheet. Then, once in the new sheet, I want the table to be sorted based on "follow up date."

I can find arrays that will sort a list, or will remove blanks, but I can't find one that will do everything that I need it to do.

Please let me know if you can help,

Thank you!

Or, if an array cannot do that much all at once, I have gotten as far as using an "intermediary sheet" that uses an array to get all of the "open" items and it removes the blank rows. So all I am looking for now is an array that will sort the list of "open" items by "follow up date."

Thanks!

See the attached

you are my hero, thanks!

You're Welcome!