Numbers, creating a filter using a formula

Hi,

I have a list of ca 380 Video I woul like to watch. The easiest way to find the Videominiaturen the list is to use a filter using the first letter/word of listed items to simplify the search. This works great, but means creating several Rules and physically selecting the one I want to use.

I thought it would be easier to create a single Rule, add a column to my spreadsheet and using a formula to place a "1“ in the column where the first few letters of list matched the search criteria I entered.

In theory it would work fine but I can’t seem to get my formula to only consider the first few letters of the entry in my Table. In the following example it works fine, but only if I enterbtem complete word

Here is the simple formula I have tried:

The mock-up spreadsheet I use to test out my idea is in German, so to explain

wenn - if

Teil - Table range

Suche - a separate one-cell table where I enter my dearth criteria

1). WENN(Teil=Suche::A$2;1;"")

2) WENN(A2=Suche::A$2;1;"")

I have tried using an * after A$2…but that just gives me a Syntax error.

So what am I doing wrong. If I were in excel I could write a Routine to filter the table. I don’t think Numbers has that Facility?

Can you help ?

Regards

B A Worrall