I have a list in a column with several names in each cell. I want to use Advanced Filter to filter the list in place so that it shows only those rows that contain the text string that is typed in. The list is in a named range called Parties. The heading Parties is in cell D1 and my criterion formula is to go in cell D2. Cell F3 contains the text the user types in. Essentially what I need is to do a filter in the same way as the custom filter that checks to see if the cell contains the relevant text.