Filter only if lookup value contains text

[VBE313]

How can I filter only the cells that have text that contains the text in cell E1?

I have tried using the =FILTER =UNIQUE and =SORT functions, but I haven't had any luck trying to extract these. How can I get my answer to look like cell D6#?

 

[Fluff]

Can you please supply some sample data using the XL2BB add-in. Thanks

 

[VBE313]

Solved

=UNIQUE(FILTER(A1:A7,LEFT(A1:A7,4)="1000"))