Populate array with large filtered range

I said

Originally Posted by jindon

If you know the filtered criteria/column, it could be done.

Means if you know the criteria, it could all be done within a memory. No helper sheet.